| --! qt:dataset:src |
| set hive.explain.user=false; |
| set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; |
| set hive.mapred.mode=nonstrict; |
| set hive.map.aggr=false; |
| set hive.groupby.skewindata=true; |
| SET hive.vectorized.execution.enabled=true; |
| set hive.fetch.task.conversion=none; |
| |
| CREATE TABLE srcorc_n0 STORED AS ORC AS SELECT * FROM src; |
| |
| -- SORT_QUERY_RESULTS |
| |
| CREATE TABLE dest1_n73(c1 STRING) STORED AS ORC; |
| |
| EXPLAIN VECTORIZATION EXPRESSION |
| FROM srcorc_n0 |
| INSERT OVERWRITE TABLE dest1_n73 SELECT DISTINCT substr(srcorc_n0.value,5,1); |
| |
| FROM srcorc_n0 |
| INSERT OVERWRITE TABLE dest1_n73 SELECT DISTINCT substr(srcorc_n0.value,5,1); |
| |
| SELECT dest1_n73.* FROM dest1_n73; |
| |
| |