| ==== |
| ---- QUERY |
| create table t1_default (c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 boolean, c6 float, |
| c7 real, c8 double, c9 decimal(20,15), c10 timestamp, c11 char(10), |
| c13 varchar(20), c14 string) stored as parquet; |
| ==== |
| ---- QUERY |
| create table t1_zstd_gzip (c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 boolean, c6 float, |
| c7 real, c8 double, c9 decimal(20,15), c10 timestamp, c11 char(10), |
| c13 varchar(20), c14 string) stored as parquet; |
| ==== |
| ---- QUERY |
| insert into t1_default select tinyint_col, smallint_col, id, bigint_col, bool_col, |
| float_col, double_col, double_col, cast(float_col as decimal(20,15)), |
| timestamp_col, cast(year as char(10)), cast(double_col as varchar(10)), |
| string_col from functional.alltypes; |
| ==== |
| ---- QUERY |
| insert into t1_default(c3) values (8000),(9000); |
| ==== |
| ---- QUERY |
| set COMPRESSION_CODEC=ZSTD; |
| insert into t1_zstd_gzip select tinyint_col, smallint_col, id, bigint_col, bool_col, |
| float_col, double_col, double_col, cast(float_col as decimal(20,15)), |
| timestamp_col, cast(year as char(10)), cast(double_col as varchar(10)), string_col |
| from functional.alltypes where id < 4000; |
| ==== |
| ---- QUERY |
| set COMPRESSION_CODEC=GZIP; |
| insert into t1_zstd_gzip(c3) values (9000); |
| ==== |
| ---- QUERY |
| set COMPRESSION_CODEC=GZIP; |
| insert into t1_zstd_gzip select tinyint_col, smallint_col, id, bigint_col, bool_col, |
| float_col, double_col, double_col, cast(float_col as decimal(20,15)), |
| timestamp_col, cast(year as char(10)), cast(double_col as varchar(10)), string_col |
| from functional.alltypes where id >= 4000; |
| ==== |
| ---- QUERY |
| set COMPRESSION_CODEC=ZSTD; |
| insert into t1_zstd_gzip(c3) values(8000); |
| ==== |