| --! qt:dataset:src | |
| set hive.vectorized.execution.enabled=false; | |
| set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; | |
| -- SORT_QUERY_RESULTS | |
| -- NO_SESSION_REUSE | |
| CREATE TABLE dest1_n22(key INT, value STRING); | |
| ADD FILE ../../ql/src/test/scripts/testgrep; | |
| FROM ( | |
| FROM src | |
| SELECT TRANSFORM(src.key, src.value) | |
| USING 'testgrep' AS (tkey, tvalue) | |
| CLUSTER BY tkey | |
| ) tmap | |
| INSERT OVERWRITE TABLE dest1_n22 SELECT tmap.tkey, tmap.tvalue; | |
| SELECT dest1_n22.* FROM dest1_n22; |