| -- Disable vectorization |
| SET hive.vectorized.execution.enabled=false; |
| |
| create table testbasicint (uint_32_col int) stored as parquet; |
| load data local inpath '../../data/files/test_uint.parquet' into table testbasicint; |
| select * from testbasicint; |
| drop table testbasicint; |
| |
| create table testbigintinv |
| (col_INT32_UINT_8 bigint, |
| col_INT32_UINT_16 bigint, |
| col_INT32_UINT_32 bigint, |
| col_INT64_UINT_64 bigint) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testbigintinv; |
| select * from testbigintinv; |
| drop table testbigintinv; |
| |
| create table testintinv |
| (col_INT32_UINT_8 int, |
| col_INT32_UINT_16 int, |
| col_INT32_UINT_32 int, |
| col_INT64_UINT_64 int) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testintinv; |
| select * from testintinv; |
| drop table testintinv; |
| |
| create table testsmallintinv |
| (col_INT32_UINT_8 smallint, |
| col_INT32_UINT_16 smallint, |
| col_INT32_UINT_32 smallint, |
| col_INT64_UINT_64 smallint) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testsmallintinv; |
| select * from testsmallintinv; |
| drop table testsmallintinv; |
| |
| create table testtinyintinv |
| (col_INT32_UINT_8 tinyint, |
| col_INT32_UINT_16 tinyint, |
| col_INT32_UINT_32 tinyint, |
| col_INT64_UINT_64 tinyint) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testtinyintinv; |
| select * from testtinyintinv; |
| drop table testtinyintinv; |
| |
| create table testfloatinv |
| (col_INT32_UINT_8 float, |
| col_INT32_UINT_16 float, |
| col_INT32_UINT_32 float, |
| col_INT64_UINT_64 float) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testfloatinv; |
| select * from testfloatinv; |
| drop table testfloatinv; |
| |
| create table testdoubleinv |
| (col_INT32_UINT_8 double, |
| col_INT32_UINT_16 double, |
| col_INT32_UINT_32 double, |
| col_INT64_UINT_64 double) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdoubleinv; |
| select * from testdoubleinv; |
| drop table testdoubleinv; |
| |
| create table testdecimal22_2inv |
| (col_INT32_UINT_8 decimal(22,2), |
| col_INT32_UINT_16 decimal(22,2), |
| col_INT32_UINT_32 decimal(22,2), |
| col_INT64_UINT_64 decimal(22,2)) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal22_2inv; |
| select * from testdecimal22_2inv; |
| drop table testdecimal22_2inv; |
| |
| create table testdecimal13_2inv |
| (col_INT32_UINT_8 decimal(13,2), |
| col_INT32_UINT_16 decimal(13,2), |
| col_INT32_UINT_32 decimal(13,2), |
| col_INT64_UINT_64 decimal(13,2)) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal13_2inv; |
| select * from testdecimal13_2inv; |
| drop table testdecimal13_2inv; |
| |
| create table testdecimal8_2inv |
| (col_INT32_UINT_8 decimal(8,2), |
| col_INT32_UINT_16 decimal(8,2), |
| col_INT32_UINT_32 decimal(8,2), |
| col_INT64_UINT_64 decimal(8,2)) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal8_2inv; |
| select * from testdecimal8_2inv; |
| drop table testdecimal8_2inv; |
| |
| create table testdecimal6_2inv |
| (col_INT32_UINT_8 decimal(6,2), |
| col_INT32_UINT_16 decimal(6,2), |
| col_INT32_UINT_32 decimal(6,2), |
| col_INT64_UINT_64 decimal(6,2)) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal6_2inv; |
| select * from testdecimal6_2inv; |
| drop table testdecimal6_2inv; |
| |
| create table testdecimal3_2inv |
| (col_INT32_UINT_8 decimal(3,2), |
| col_INT32_UINT_16 decimal(3,2), |
| col_INT32_UINT_32 decimal(3,2), |
| col_INT64_UINT_64 decimal(3,2)) stored as parquet; |
| load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal3_2inv; |
| select * from testdecimal3_2inv; |
| drop table testdecimal3_2inv; |
| |
| create table testbigintvalid |
| (col_INT32_UINT_8 bigint, |
| col_INT32_UINT_16 bigint, |
| col_INT32_UINT_32 bigint, |
| col_INT64_UINT_64 bigint) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testbigintvalid; |
| select * from testbigintvalid; |
| drop table testbigintvalid; |
| |
| create table testintvalid |
| (col_INT32_UINT_8 int, |
| col_INT32_UINT_16 int, |
| col_INT32_UINT_32 int, |
| col_INT64_UINT_64 int) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testintvalid; |
| select * from testintvalid; |
| drop table testintvalid; |
| |
| create table testsmallintvalid |
| (col_INT32_UINT_8 smallint, |
| col_INT32_UINT_16 smallint, |
| col_INT32_UINT_32 smallint, |
| col_INT64_UINT_64 smallint) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testsmallintvalid; |
| select * from testsmallintvalid; |
| drop table testsmallintvalid; |
| |
| create table testtinyintvalid |
| (col_INT32_UINT_8 tinyint, |
| col_INT32_UINT_16 tinyint, |
| col_INT32_UINT_32 tinyint, |
| col_INT64_UINT_64 tinyint) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testtinyintvalid; |
| select * from testtinyintvalid; |
| drop table testtinyintvalid; |
| |
| create table testfloatvalid |
| (col_INT32_UINT_8 float, |
| col_INT32_UINT_16 float, |
| col_INT32_UINT_32 float, |
| col_INT64_UINT_64 float) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testfloatvalid; |
| select * from testfloatvalid; |
| drop table testfloatvalid; |
| |
| create table testdoublevalid |
| (col_INT32_UINT_8 double, |
| col_INT32_UINT_16 double, |
| col_INT32_UINT_32 double, |
| col_INT64_UINT_64 double) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdoublevalid; |
| select * from testdoublevalid; |
| drop table testdoublevalid; |
| |
| create table testdecimal22_2valid |
| (col_INT32_UINT_8 decimal(22,2), |
| col_INT32_UINT_16 decimal(22,2), |
| col_INT32_UINT_32 decimal(22,2), |
| col_INT64_UINT_64 decimal(22,2)) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal22_2valid; |
| select * from testdecimal22_2valid; |
| drop table testdecimal22_2valid; |
| |
| create table testdecimal13_2valid |
| (col_INT32_UINT_8 decimal(13,2), |
| col_INT32_UINT_16 decimal(13,2), |
| col_INT32_UINT_32 decimal(13,2), |
| col_INT64_UINT_64 decimal(13,2)) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal13_2valid; |
| select * from testdecimal13_2valid; |
| drop table testdecimal13_2valid; |
| |
| create table testdecimal8_2valid |
| (col_INT32_UINT_8 decimal(8,2), |
| col_INT32_UINT_16 decimal(8,2), |
| col_INT32_UINT_32 decimal(8,2), |
| col_INT64_UINT_64 decimal(8,2)) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal8_2valid; |
| select * from testdecimal8_2valid; |
| drop table testdecimal8_2valid; |
| |
| create table testdecimal6_2valid |
| (col_INT32_UINT_8 decimal(6,2), |
| col_INT32_UINT_16 decimal(6,2), |
| col_INT32_UINT_32 decimal(6,2), |
| col_INT64_UINT_64 decimal(6,2)) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal6_2valid; |
| select * from testdecimal6_2valid; |
| drop table testdecimal6_2valid; |
| |
| create table testdecimal3_2valid |
| (col_INT32_UINT_8 decimal(3,2), |
| col_INT32_UINT_16 decimal(3,2), |
| col_INT32_UINT_32 decimal(3,2), |
| col_INT64_UINT_64 decimal(3,2)) stored as parquet; |
| load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal3_2valid; |
| select * from testdecimal3_2valid; |
| drop table testdecimal3_2valid; |