| ==== | |
| ---- QUERY: TPDCS-STR-INSERT-SETUP | |
| CREATE TABLE str_insert (s string) STORED AS $FILE_FORMAT | |
| ---- RESULTS | |
| 'Table has been created.' | |
| ==== | |
| ---- QUERY: TPDCS-STR-INSERT-CASE | |
| INSERT INTO str_insert | |
| SELECT case when ss_promo_sk % 2 = 0 then 'even' else 'odd' end | |
| FROM tpcds.store_sales | |
| ---- RUNTIME_PROFILE | |
| NumModifiedRows: 2880404 | |
| ==== | |
| ---- QUERY: TPCDS-STR-INSERT-CASE | |
| SELECT COUNT(*) FROM str_insert | |
| ---- RESULTS | |
| 2880404 | |
| ==== |