| --! qt:dataset:src |
| |
| set hive.vectorized.execution.enabled=false; |
| set hive.mapred.mode=nonstrict; |
| |
| drop table staging_n3; |
| drop table parquet_ctas; |
| drop table parquet_ctas_advanced; |
| drop table parquet_ctas_alias; |
| drop table parquet_ctas_mixed; |
| |
| create table staging_n3 (key int, value string) stored as textfile; |
| insert into table staging_n3 select * from src order by key limit 10; |
| |
| create table parquet_ctas stored as parquet as select * from staging_n3; |
| describe parquet_ctas; |
| select * from parquet_ctas; |
| |
| create table parquet_ctas_advanced stored as parquet as select key+1,concat(value,"value") from staging_n3; |
| describe parquet_ctas_advanced; |
| select * from parquet_ctas_advanced; |
| |
| create table parquet_ctas_alias stored as parquet as select key+1 as mykey,concat(value,"value") as myvalue from staging_n3; |
| describe parquet_ctas_alias; |
| select * from parquet_ctas_alias; |
| |
| create table parquet_ctas_mixed stored as parquet as select key,key+1,concat(value,"value") as myvalue from staging_n3; |
| describe parquet_ctas_mixed; |
| select * from parquet_ctas_mixed; |