-- Enable vectorization
SET hive.vectorized.execution.enabled=true;
SET hive.fetch.task.conversion=none;

create table testbasicint_n0 (uint_32_col int) stored as parquet;
load data local inpath '../../data/files/test_uint.parquet' into table testbasicint_n0;
select * from testbasicint_n0;
drop table testbasicint_n0;

create table testbigintinv_n0
(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_n0;
select * from testbigintinv_n0;
drop table testbigintinv_n0;

create table testintinv_n0
(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_n0;
select * from testintinv_n0;
drop table testintinv_n0;

create table testsmallintinv_n0
(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_n0;
select * from testsmallintinv_n0;
drop table testsmallintinv_n0;

create table testtinyintinv_n0
(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_n0;
select * from testtinyintinv_n0;
drop table testtinyintinv_n0;

create table testfloatinv_n0
(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_n0;
select * from testfloatinv_n0;
drop table testfloatinv_n0;

create table testdoubleinv_n0
(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_n0;
select * from testdoubleinv_n0;
drop table testdoubleinv_n0;

create table testdecimal22_2inv_n0
(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_n0;
select * from testdecimal22_2inv_n0;
drop table testdecimal22_2inv_n0;

create table testdecimal13_2inv_n0
(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_n0;
select * from testdecimal13_2inv_n0;
drop table testdecimal13_2inv_n0;

create table testdecimal8_2inv_n0
(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_n0;
select * from testdecimal8_2inv_n0;
drop table testdecimal8_2inv_n0;

create table testdecimal6_2inv_n0
(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_n0;
select * from testdecimal6_2inv_n0;
drop table testdecimal6_2inv_n0;

create table testdecimal3_2inv_n0
(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_n0;
select * from testdecimal3_2inv_n0;
drop table testdecimal3_2inv_n0;

create table testbigintvalid_n0
(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_n0;
select * from testbigintvalid_n0;
drop table testbigintvalid_n0;

create table testintvalid_n0
(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_n0;
select * from testintvalid_n0;
drop table testintvalid_n0;

create table testsmallintvalid_n0
(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_n0;
select * from testsmallintvalid_n0;
drop table testsmallintvalid_n0;

create table testtinyintvalid_n0
(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_n0;
select * from testtinyintvalid_n0;
drop table testtinyintvalid_n0;

create table testfloatvalid_n0
(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_n0;
select * from testfloatvalid_n0;
drop table testfloatvalid_n0;

create table testdoublevalid_n0
(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_n0;
select * from testdoublevalid_n0;
drop table testdoublevalid_n0;

create table testdecimal22_2valid_n0
(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_n0;
select * from testdecimal22_2valid_n0;
drop table testdecimal22_2valid_n0;

create table testdecimal13_2valid_n0
(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_n0;
select * from testdecimal13_2valid_n0;
drop table testdecimal13_2valid_n0;

create table testdecimal8_2valid_n0
(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_n0;
select * from testdecimal8_2valid_n0;
drop table testdecimal8_2valid_n0;

create table testdecimal6_2valid_n0
(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_n0;
select * from testdecimal6_2valid_n0;
drop table testdecimal6_2valid_n0;

create table testdecimal3_2valid_n0
(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_n0;
select * from testdecimal3_2valid_n0;
drop table testdecimal3_2valid_n0;