You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vi...@apache.org on 2018/05/16 21:46:38 UTC
[3/4] hive git commit: HIVE-19317 : Handle schema evolution from int
like types to decimal (Janaki Lahorani, reviewed by Vihang Karajgaonkar)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb6dee1c/ql/src/test/queries/clientpositive/type_change_test_int_vectorized.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/type_change_test_int_vectorized.q b/ql/src/test/queries/clientpositive/type_change_test_int_vectorized.q
index 90a390b..9e93a2f 100644
--- a/ql/src/test/queries/clientpositive/type_change_test_int_vectorized.q
+++ b/ql/src/test/queries/clientpositive/type_change_test_int_vectorized.q
@@ -91,6 +91,81 @@ alter table testAltColT replace columns
select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+-- bigint, int, smallint, and tinyint: type changed to float
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to double
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- all values fit and should return all values
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int doesn't fit and should return null where it didn't fit
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int and int doesn't fit and should return null where it didn't fit
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int, int and small int doesn't fit and should return null where it didn't fit
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- only single digit fits and should return null where it didn't fit
+alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId;
+
drop table if exists testAltColT;
-- Text type: End
@@ -141,6 +216,81 @@ alter table testAltColSF replace columns
select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+-- bigint, int, smallint, and tinyint: type changed to float
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to double
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- all values fit and should return all values
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int doesn't fit and should return null where it didn't fit
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int and int doesn't fit and should return null where it didn't fit
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int, int and small int doesn't fit and should return null where it didn't fit
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- only single digit fits and should return null where it didn't fit
+alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId;
+
drop table if exists testAltColSF;
-- Sequence File type: End
@@ -191,6 +341,81 @@ alter table testAltColRCF replace columns
select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+-- bigint, int, smallint, and tinyint: type changed to float
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to double
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- all values fit and should return all values
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int doesn't fit and should return null where it didn't fit
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int and int doesn't fit and should return null where it didn't fit
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int, int and small int doesn't fit and should return null where it didn't fit
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- only single digit fits and should return null where it didn't fit
+alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId;
+
drop table if exists testAltColRCF;
-- RCFile type: End
@@ -241,6 +466,81 @@ alter table testAltColORC replace columns
select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+-- bigint, int, smallint, and tinyint: type changed to float
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to double
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- all values fit and should return all values
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int doesn't fit and should return null where it didn't fit
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int and int doesn't fit and should return null where it didn't fit
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int, int and small int doesn't fit and should return null where it didn't fit
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- only single digit fits and should return null where it didn't fit
+alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId;
+
drop table if exists testAltColORC;
-- ORC type: End
@@ -291,6 +591,81 @@ alter table testAltColPDE replace columns
select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+-- bigint, int, smallint, and tinyint: type changed to float
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to double
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- all values fit and should return all values
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int doesn't fit and should return null where it didn't fit
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int and int doesn't fit and should return null where it didn't fit
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int, int and small int doesn't fit and should return null where it didn't fit
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- only single digit fits and should return null where it didn't fit
+alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId;
+
drop table if exists testAltColPDE;
-- Parquet type with Dictionary encoding enabled: End
@@ -342,6 +717,81 @@ alter table testAltColPDD replace columns
select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+-- bigint, int, smallint, and tinyint: type changed to float
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to double
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE);
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- all values fit and should return all values
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int doesn't fit and should return null where it didn't fit
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int and int doesn't fit and should return null where it didn't fit
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- some of big int, int and small int doesn't fit and should return null where it didn't fit
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
+-- bigint, int, smallint, and tinyint: type changed to decimal
+-- only single digit fits and should return null where it didn't fit
+alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2));
+
+select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId;
+
drop table if exists testAltColPDD;
-- Parquet type with Dictionary encoding enabled: End
http://git-wip-us.apache.org/repos/asf/hive/blob/cb6dee1c/ql/src/test/results/clientpositive/read_uint_parquet.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/read_uint_parquet.q.out b/ql/src/test/results/clientpositive/read_uint_parquet.q.out
index b34f8d4..eb58f3d 100644
--- a/ql/src/test/results/clientpositive/read_uint_parquet.q.out
+++ b/ql/src/test/results/clientpositive/read_uint_parquet.q.out
@@ -231,6 +231,349 @@ POSTHOOK: query: drop table testtinyintinv
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@testtinyintinv
POSTHOOK: Output: default@testtinyintinv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testfloatinv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testfloatinv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testfloatinv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testfloatinv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testfloatinv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testfloatinv
+PREHOOK: query: select * from testfloatinv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testfloatinv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testfloatinv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testfloatinv
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+32767.0 32767.0 32767.0 32767.0
+65535.0 65535.0 65535.0 65535.0
+2.14748365E9 2.14748365E9 2.14748365E9 2.14748365E9
+NULL NULL NULL 4.2949673E9
+NULL NULL NULL 9.223372E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testfloatinv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testfloatinv
+PREHOOK: Output: default@testfloatinv
+POSTHOOK: query: drop table testfloatinv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testfloatinv
+POSTHOOK: Output: default@testfloatinv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdoubleinv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdoubleinv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdoubleinv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdoubleinv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdoubleinv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdoubleinv
+PREHOOK: query: select * from testdoubleinv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdoubleinv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdoubleinv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdoubleinv
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+32767.0 32767.0 32767.0 32767.0
+65535.0 65535.0 65535.0 65535.0
+2.147483648E9 2.147483648E9 2.147483648E9 2.147483647E9
+NULL NULL NULL 4.294967295E9
+NULL NULL NULL 9.223372036854776E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdoubleinv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdoubleinv
+PREHOOK: Output: default@testdoubleinv
+POSTHOOK: query: drop table testdoubleinv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdoubleinv
+POSTHOOK: Output: default@testdoubleinv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal22_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal22_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal22_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal22_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal22_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal22_2inv
+PREHOOK: query: select * from testdecimal22_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal22_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal22_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal22_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+32767.00 32767.00 32767.00 32767.00
+65535.00 65535.00 65535.00 65535.00
+2147483647.00 2147483647.00 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL 9223372036854775807.00
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal22_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal22_2inv
+PREHOOK: Output: default@testdecimal22_2inv
+POSTHOOK: query: drop table testdecimal22_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal22_2inv
+POSTHOOK: Output: default@testdecimal22_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal13_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal13_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal13_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal13_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal13_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal13_2inv
+PREHOOK: query: select * from testdecimal13_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal13_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal13_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal13_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+32767.00 32767.00 32767.00 32767.00
+65535.00 65535.00 65535.00 65535.00
+2147483647.00 2147483647.00 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal13_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal13_2inv
+PREHOOK: Output: default@testdecimal13_2inv
+POSTHOOK: query: drop table testdecimal13_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal13_2inv
+POSTHOOK: Output: default@testdecimal13_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal8_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal8_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal8_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal8_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal8_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal8_2inv
+PREHOOK: query: select * from testdecimal8_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal8_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal8_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal8_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+32767.00 32767.00 32767.00 32767.00
+65535.00 65535.00 65535.00 65535.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal8_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal8_2inv
+PREHOOK: Output: default@testdecimal8_2inv
+POSTHOOK: query: drop table testdecimal8_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal8_2inv
+POSTHOOK: Output: default@testdecimal8_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal6_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal6_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal6_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal6_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal6_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal6_2inv
+PREHOOK: query: select * from testdecimal6_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal6_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal6_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal6_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal6_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal6_2inv
+PREHOOK: Output: default@testdecimal6_2inv
+POSTHOOK: query: drop table testdecimal6_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal6_2inv
+POSTHOOK: Output: default@testdecimal6_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal3_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal3_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal3_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal3_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal3_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal3_2inv
+PREHOOK: query: select * from testdecimal3_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal3_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal3_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal3_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal3_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal3_2inv
+PREHOOK: Output: default@testdecimal3_2inv
+POSTHOOK: query: drop table testdecimal3_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal3_2inv
+POSTHOOK: Output: default@testdecimal3_2inv
PREHOOK: query: create table testbigintvalid
(col_INT32_UINT_8 bigint,
col_INT32_UINT_16 bigint,
@@ -427,3 +770,346 @@ POSTHOOK: query: drop table testtinyintvalid
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@testtinyintvalid
POSTHOOK: Output: default@testtinyintvalid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testfloatvalid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testfloatvalid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testfloatvalid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testfloatvalid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testfloatvalid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testfloatvalid
+PREHOOK: query: select * from testfloatvalid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testfloatvalid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testfloatvalid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testfloatvalid
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+NULL 32767.0 32767.0 32767.0
+NULL 65535.0 65535.0 65535.0
+NULL NULL 2.14748365E9 2.14748365E9
+NULL NULL NULL 4.2949673E9
+NULL NULL NULL 9.223372E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testfloatvalid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testfloatvalid
+PREHOOK: Output: default@testfloatvalid
+POSTHOOK: query: drop table testfloatvalid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testfloatvalid
+POSTHOOK: Output: default@testfloatvalid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdoublevalid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdoublevalid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdoublevalid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdoublevalid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdoublevalid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdoublevalid
+PREHOOK: query: select * from testdoublevalid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdoublevalid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdoublevalid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdoublevalid
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+NULL 32767.0 32767.0 32767.0
+NULL 65535.0 65535.0 65535.0
+NULL NULL 2.147483648E9 2.147483647E9
+NULL NULL NULL 4.294967295E9
+NULL NULL NULL 9.223372036854776E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdoublevalid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdoublevalid
+PREHOOK: Output: default@testdoublevalid
+POSTHOOK: query: drop table testdoublevalid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdoublevalid
+POSTHOOK: Output: default@testdoublevalid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal22_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal22_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal22_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal22_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal22_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal22_2valid
+PREHOOK: query: select * from testdecimal22_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal22_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal22_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal22_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL 32767.00 32767.00 32767.00
+NULL 65535.00 65535.00 65535.00
+NULL NULL 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL 9223372036854775807.00
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal22_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal22_2valid
+PREHOOK: Output: default@testdecimal22_2valid
+POSTHOOK: query: drop table testdecimal22_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal22_2valid
+POSTHOOK: Output: default@testdecimal22_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal13_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal13_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal13_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal13_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal13_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal13_2valid
+PREHOOK: query: select * from testdecimal13_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal13_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal13_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal13_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL 32767.00 32767.00 32767.00
+NULL 65535.00 65535.00 65535.00
+NULL NULL 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal13_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal13_2valid
+PREHOOK: Output: default@testdecimal13_2valid
+POSTHOOK: query: drop table testdecimal13_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal13_2valid
+POSTHOOK: Output: default@testdecimal13_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal8_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal8_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal8_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal8_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal8_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal8_2valid
+PREHOOK: query: select * from testdecimal8_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal8_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal8_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal8_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL 32767.00 32767.00 32767.00
+NULL 65535.00 65535.00 65535.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal8_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal8_2valid
+PREHOOK: Output: default@testdecimal8_2valid
+POSTHOOK: query: drop table testdecimal8_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal8_2valid
+POSTHOOK: Output: default@testdecimal8_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal6_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal6_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal6_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal6_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal6_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal6_2valid
+PREHOOK: query: select * from testdecimal6_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal6_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal6_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal6_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal6_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal6_2valid
+PREHOOK: Output: default@testdecimal6_2valid
+POSTHOOK: query: drop table testdecimal6_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal6_2valid
+POSTHOOK: Output: default@testdecimal6_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal3_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal3_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal3_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal3_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal3_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal3_2valid
+PREHOOK: query: select * from testdecimal3_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal3_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal3_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal3_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal3_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal3_2valid
+PREHOOK: Output: default@testdecimal3_2valid
+POSTHOOK: query: drop table testdecimal3_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal3_2valid
+POSTHOOK: Output: default@testdecimal3_2valid
http://git-wip-us.apache.org/repos/asf/hive/blob/cb6dee1c/ql/src/test/results/clientpositive/read_uint_parquet_vectorized.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/read_uint_parquet_vectorized.q.out b/ql/src/test/results/clientpositive/read_uint_parquet_vectorized.q.out
index b34f8d4..3d5b4f2 100644
--- a/ql/src/test/results/clientpositive/read_uint_parquet_vectorized.q.out
+++ b/ql/src/test/results/clientpositive/read_uint_parquet_vectorized.q.out
@@ -231,6 +231,349 @@ POSTHOOK: query: drop table testtinyintinv
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@testtinyintinv
POSTHOOK: Output: default@testtinyintinv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testfloatinv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testfloatinv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testfloatinv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testfloatinv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testfloatinv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testfloatinv
+PREHOOK: query: select * from testfloatinv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testfloatinv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testfloatinv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testfloatinv
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+32767.0 32767.0 32767.0 32767.0
+65535.0 65535.0 65535.0 65535.0
+2.14748365E9 2.14748365E9 2.14748365E9 2.14748365E9
+NULL NULL NULL 4.2949673E9
+NULL NULL NULL 9.223372E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testfloatinv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testfloatinv
+PREHOOK: Output: default@testfloatinv
+POSTHOOK: query: drop table testfloatinv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testfloatinv
+POSTHOOK: Output: default@testfloatinv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdoubleinv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdoubleinv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdoubleinv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdoubleinv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdoubleinv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdoubleinv
+PREHOOK: query: select * from testdoubleinv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdoubleinv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdoubleinv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdoubleinv
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+32767.0 32767.0 32767.0 32767.0
+65535.0 65535.0 65535.0 65535.0
+2.147483647E9 2.147483647E9 2.147483647E9 2.147483647E9
+NULL NULL NULL 4.294967295E9
+NULL NULL NULL 9.223372036854776E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdoubleinv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdoubleinv
+PREHOOK: Output: default@testdoubleinv
+POSTHOOK: query: drop table testdoubleinv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdoubleinv
+POSTHOOK: Output: default@testdoubleinv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal22_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal22_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal22_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal22_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal22_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal22_2inv
+PREHOOK: query: select * from testdecimal22_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal22_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal22_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal22_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+32767.00 32767.00 32767.00 32767.00
+65535.00 65535.00 65535.00 65535.00
+2147483647.00 2147483647.00 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL 9223372036854775807.00
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal22_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal22_2inv
+PREHOOK: Output: default@testdecimal22_2inv
+POSTHOOK: query: drop table testdecimal22_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal22_2inv
+POSTHOOK: Output: default@testdecimal22_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal13_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal13_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal13_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal13_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal13_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal13_2inv
+PREHOOK: query: select * from testdecimal13_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal13_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal13_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal13_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+32767.00 32767.00 32767.00 32767.00
+65535.00 65535.00 65535.00 65535.00
+2147483647.00 2147483647.00 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal13_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal13_2inv
+PREHOOK: Output: default@testdecimal13_2inv
+POSTHOOK: query: drop table testdecimal13_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal13_2inv
+POSTHOOK: Output: default@testdecimal13_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal8_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal8_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal8_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal8_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal8_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal8_2inv
+PREHOOK: query: select * from testdecimal8_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal8_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal8_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal8_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+32767.00 32767.00 32767.00 32767.00
+65535.00 65535.00 65535.00 65535.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal8_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal8_2inv
+PREHOOK: Output: default@testdecimal8_2inv
+POSTHOOK: query: drop table testdecimal8_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal8_2inv
+POSTHOOK: Output: default@testdecimal8_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal6_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal6_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal6_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal6_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal6_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal6_2inv
+PREHOOK: query: select * from testdecimal6_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal6_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal6_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal6_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal6_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal6_2inv
+PREHOOK: Output: default@testdecimal6_2inv
+POSTHOOK: query: drop table testdecimal6_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal6_2inv
+POSTHOOK: Output: default@testdecimal6_2inv
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal3_2inv
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal3_2inv
+PREHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal3_2inv
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal3_2inv
+POSTHOOK: query: load data local inpath '../../data/files/data_including_invalid_values.parquet' into table testdecimal3_2inv
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal3_2inv
+PREHOOK: query: select * from testdecimal3_2inv
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal3_2inv
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal3_2inv
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal3_2inv
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal3_2inv
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal3_2inv
+PREHOOK: Output: default@testdecimal3_2inv
+POSTHOOK: query: drop table testdecimal3_2inv
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal3_2inv
+POSTHOOK: Output: default@testdecimal3_2inv
PREHOOK: query: create table testbigintvalid
(col_INT32_UINT_8 bigint,
col_INT32_UINT_16 bigint,
@@ -427,3 +770,346 @@ POSTHOOK: query: drop table testtinyintvalid
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@testtinyintvalid
POSTHOOK: Output: default@testtinyintvalid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testfloatvalid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testfloatvalid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testfloatvalid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testfloatvalid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testfloatvalid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testfloatvalid
+PREHOOK: query: select * from testfloatvalid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testfloatvalid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testfloatvalid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testfloatvalid
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+NULL 32767.0 32767.0 32767.0
+NULL 65535.0 65535.0 65535.0
+NULL NULL 2.14748365E9 2.14748365E9
+NULL NULL NULL 4.2949673E9
+NULL NULL NULL 9.223372E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testfloatvalid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testfloatvalid
+PREHOOK: Output: default@testfloatvalid
+POSTHOOK: query: drop table testfloatvalid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testfloatvalid
+POSTHOOK: Output: default@testfloatvalid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdoublevalid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdoublevalid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdoublevalid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdoublevalid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdoublevalid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdoublevalid
+PREHOOK: query: select * from testdoublevalid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdoublevalid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdoublevalid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdoublevalid
+#### A masked pattern was here ####
+0.0 0.0 0.0 0.0
+127.0 127.0 127.0 127.0
+255.0 255.0 255.0 255.0
+NULL 32767.0 32767.0 32767.0
+NULL 65535.0 65535.0 65535.0
+NULL NULL 2.147483647E9 2.147483647E9
+NULL NULL NULL 4.294967295E9
+NULL NULL NULL 9.223372036854776E18
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdoublevalid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdoublevalid
+PREHOOK: Output: default@testdoublevalid
+POSTHOOK: query: drop table testdoublevalid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdoublevalid
+POSTHOOK: Output: default@testdoublevalid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal22_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal22_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal22_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal22_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal22_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal22_2valid
+PREHOOK: query: select * from testdecimal22_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal22_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal22_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal22_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL 32767.00 32767.00 32767.00
+NULL 65535.00 65535.00 65535.00
+NULL NULL 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL 9223372036854775807.00
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal22_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal22_2valid
+PREHOOK: Output: default@testdecimal22_2valid
+POSTHOOK: query: drop table testdecimal22_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal22_2valid
+POSTHOOK: Output: default@testdecimal22_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal13_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal13_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal13_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal13_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal13_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal13_2valid
+PREHOOK: query: select * from testdecimal13_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal13_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal13_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal13_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL 32767.00 32767.00 32767.00
+NULL 65535.00 65535.00 65535.00
+NULL NULL 2147483647.00 2147483647.00
+NULL NULL NULL 4294967295.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal13_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal13_2valid
+PREHOOK: Output: default@testdecimal13_2valid
+POSTHOOK: query: drop table testdecimal13_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal13_2valid
+POSTHOOK: Output: default@testdecimal13_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal8_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal8_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal8_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal8_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal8_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal8_2valid
+PREHOOK: query: select * from testdecimal8_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal8_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal8_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal8_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL 32767.00 32767.00 32767.00
+NULL 65535.00 65535.00 65535.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal8_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal8_2valid
+PREHOOK: Output: default@testdecimal8_2valid
+POSTHOOK: query: drop table testdecimal8_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal8_2valid
+POSTHOOK: Output: default@testdecimal8_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal6_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal6_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal6_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal6_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal6_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal6_2valid
+PREHOOK: query: select * from testdecimal6_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal6_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal6_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal6_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+127.00 127.00 127.00 127.00
+255.00 255.00 255.00 255.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal6_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal6_2valid
+PREHOOK: Output: default@testdecimal6_2valid
+POSTHOOK: query: drop table testdecimal6_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal6_2valid
+POSTHOOK: Output: default@testdecimal6_2valid
+PREHOOK: query: 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
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testdecimal3_2valid
+POSTHOOK: query: 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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testdecimal3_2valid
+PREHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal3_2valid
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@testdecimal3_2valid
+POSTHOOK: query: load data local inpath '../../data/files/data_with_valid_values.parquet' into table testdecimal3_2valid
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@testdecimal3_2valid
+PREHOOK: query: select * from testdecimal3_2valid
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testdecimal3_2valid
+#### A masked pattern was here ####
+POSTHOOK: query: select * from testdecimal3_2valid
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testdecimal3_2valid
+#### A masked pattern was here ####
+0.00 0.00 0.00 0.00
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+NULL NULL NULL NULL
+PREHOOK: query: drop table testdecimal3_2valid
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testdecimal3_2valid
+PREHOOK: Output: default@testdecimal3_2valid
+POSTHOOK: query: drop table testdecimal3_2valid
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testdecimal3_2valid
+POSTHOOK: Output: default@testdecimal3_2valid