http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/druid/druid_timestamptz2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/druid/druid_timestamptz2.q.out b/ql/src/test/results/clientpositive/druid/druid_timestamptz2.q.out new file mode 100644 index 0000000..c71a435 --- /dev/null +++ b/ql/src/test/results/clientpositive/druid/druid_timestamptz2.q.out @@ -0,0 +1,308 @@ +PREHOOK: query: CREATE database druid_test_dst +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:druid_test_dst +POSTHOOK: query: CREATE database druid_test_dst +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:druid_test_dst +PREHOOK: query: use druid_test_dst +PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:druid_test_dst +POSTHOOK: query: use druid_test_dst +POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:druid_test_dst +PREHOOK: query: create table test_base_table(`timecolumn` timestamp, `interval_marker` string, `num_l` double) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:druid_test_dst +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: create table test_base_table(`timecolumn` timestamp, `interval_marker` string, `num_l` double) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:druid_test_dst +POSTHOOK: Output: druid_test_dst@test_base_table +PREHOOK: query: insert into test_base_table values ('2015-03-08 00:00:00', 'i1-start', 4) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: insert into test_base_table values ('2015-03-08 00:00:00', 'i1-start', 4) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: Lineage: test_base_table.interval_marker SCRIPT [] +POSTHOOK: Lineage: test_base_table.num_l SCRIPT [] +POSTHOOK: Lineage: test_base_table.timecolumn SCRIPT [] +PREHOOK: query: insert into test_base_table values ('2015-03-08 23:59:59', 'i1-end', 1) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: insert into test_base_table values ('2015-03-08 23:59:59', 'i1-end', 1) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: Lineage: test_base_table.interval_marker SCRIPT [] +POSTHOOK: Lineage: test_base_table.num_l SCRIPT [] +POSTHOOK: Lineage: test_base_table.timecolumn SCRIPT [] +PREHOOK: query: insert into test_base_table values ('2015-03-09 00:00:00', 'i2-start', 4) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: insert into test_base_table values ('2015-03-09 00:00:00', 'i2-start', 4) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: Lineage: test_base_table.interval_marker SCRIPT [] +POSTHOOK: Lineage: test_base_table.num_l SCRIPT [] +POSTHOOK: Lineage: test_base_table.timecolumn SCRIPT [] +PREHOOK: query: insert into test_base_table values ('2015-03-09 23:59:59', 'i2-end', 1) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: insert into test_base_table values ('2015-03-09 23:59:59', 'i2-end', 1) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: Lineage: test_base_table.interval_marker SCRIPT [] +POSTHOOK: Lineage: test_base_table.num_l SCRIPT [] +POSTHOOK: Lineage: test_base_table.timecolumn SCRIPT [] +PREHOOK: query: insert into test_base_table values ('2015-03-10 00:00:00', 'i3-start', 2) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: insert into test_base_table values ('2015-03-10 00:00:00', 'i3-start', 2) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: Lineage: test_base_table.interval_marker SCRIPT [] +POSTHOOK: Lineage: test_base_table.num_l SCRIPT [] +POSTHOOK: Lineage: test_base_table.timecolumn SCRIPT [] +PREHOOK: query: insert into test_base_table values ('2015-03-10 23:59:59', 'i3-end', 2) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: query: insert into test_base_table values ('2015-03-10 23:59:59', 'i3-end', 2) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@test_base_table +POSTHOOK: Lineage: test_base_table.interval_marker SCRIPT [] +POSTHOOK: Lineage: test_base_table.num_l SCRIPT [] +POSTHOOK: Lineage: test_base_table.timecolumn SCRIPT [] +PREHOOK: query: CREATE TABLE druid_test_table_1 +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +AS +select cast(`timecolumn` as timestamp with local time zone) as `__time`, `interval_marker`, `num_l` +FROM druid_test_dst.test_base_table +PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: druid_test_dst@test_base_table +PREHOOK: Output: database:druid_test_dst +PREHOOK: Output: druid_test_dst@druid_test_table_1 +POSTHOOK: query: CREATE TABLE druid_test_table_1 +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +AS +select cast(`timecolumn` as timestamp with local time zone) as `__time`, `interval_marker`, `num_l` +FROM druid_test_dst.test_base_table +POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: druid_test_dst@test_base_table +POSTHOOK: Output: database:druid_test_dst +POSTHOOK: Output: druid_test_dst@druid_test_table_1 +POSTHOOK: Lineage: druid_test_table_1.__time EXPRESSION [(test_base_table)test_base_table.FieldSchema(name:timecolumn, type:timestamp, comment:null), ] +POSTHOOK: Lineage: druid_test_table_1.interval_marker SIMPLE [(test_base_table)test_base_table.FieldSchema(name:interval_marker, type:string, comment:null), ] +POSTHOOK: Lineage: druid_test_table_1.num_l SIMPLE [(test_base_table)test_base_table.FieldSchema(name:num_l, type:double, comment:null), ] +PREHOOK: query: select * FROM druid_test_table_1 +PREHOOK: type: QUERY +PREHOOK: Input: druid_test_dst@druid_test_table_1 +PREHOOK: Output: hdfs://### HDFS PATH ### +POSTHOOK: query: select * FROM druid_test_table_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: druid_test_dst@druid_test_table_1 +POSTHOOK: Output: hdfs://### HDFS PATH ### +2015-03-08 00:00:00.0 US/Pacific i1-start 4.0 +2015-03-08 23:59:59.0 US/Pacific i1-end 1.0 +2015-03-09 00:00:00.0 US/Pacific i2-start 4.0 +2015-03-09 23:59:59.0 US/Pacific i2-end 1.0 +2015-03-10 00:00:00.0 US/Pacific i3-start 2.0 +2015-03-10 23:59:59.0 US/Pacific i3-end 2.0 +PREHOOK: query: CREATE TABLE druid_test_table_2 (`__time` timestamp with local time zone, `interval_marker` string, `num_l` double) +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:druid_test_dst +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: CREATE TABLE druid_test_table_2 (`__time` timestamp with local time zone, `interval_marker` string, `num_l` double) +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:druid_test_dst +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: insert into druid_test_table_2 values (cast('2015-03-08 00:00:00' as timestamp with local time zone), 'i1-start', 4) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: insert into druid_test_table_2 values (cast('2015-03-08 00:00:00' as timestamp with local time zone), 'i1-start', 4) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: insert into druid_test_table_2 values (cast('2015-03-08 23:59:59' as timestamp with local time zone), 'i1-end', 1) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: insert into druid_test_table_2 values (cast('2015-03-08 23:59:59' as timestamp with local time zone), 'i1-end', 1) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: insert into druid_test_table_2 values (cast('2015-03-09 00:00:00' as timestamp with local time zone), 'i2-start', 4) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: insert into druid_test_table_2 values (cast('2015-03-09 00:00:00' as timestamp with local time zone), 'i2-start', 4) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: insert into druid_test_table_2 values (cast('2015-03-09 23:59:59' as timestamp with local time zone), 'i2-end', 1) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: insert into druid_test_table_2 values (cast('2015-03-09 23:59:59' as timestamp with local time zone), 'i2-end', 1) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: insert into druid_test_table_2 values (cast('2015-03-10 00:00:00' as timestamp with local time zone), 'i3-start', 2) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: insert into druid_test_table_2 values (cast('2015-03-10 00:00:00' as timestamp with local time zone), 'i3-start', 2) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: insert into druid_test_table_2 values (cast('2015-03-10 23:59:59' as timestamp with local time zone), 'i3-end', 2) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_2 +POSTHOOK: query: insert into druid_test_table_2 values (cast('2015-03-10 23:59:59' as timestamp with local time zone), 'i3-end', 2) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_2 +PREHOOK: query: select * FROM druid_test_table_2 +PREHOOK: type: QUERY +PREHOOK: Input: druid_test_dst@druid_test_table_2 +PREHOOK: Output: hdfs://### HDFS PATH ### +POSTHOOK: query: select * FROM druid_test_table_2 +POSTHOOK: type: QUERY +POSTHOOK: Input: druid_test_dst@druid_test_table_2 +POSTHOOK: Output: hdfs://### HDFS PATH ### +2015-03-08 00:00:00.0 US/Pacific i1-start 4.0 +2015-03-08 23:59:59.0 US/Pacific i1-end 1.0 +2015-03-09 00:00:00.0 US/Pacific i2-start 4.0 +2015-03-09 23:59:59.0 US/Pacific i2-end 1.0 +2015-03-10 00:00:00.0 US/Pacific i3-start 2.0 +2015-03-10 23:59:59.0 US/Pacific i3-end 2.0 +PREHOOK: query: CREATE TABLE druid_test_table_utc +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +AS +select cast(`timecolumn` as timestamp with local time zone) as `__time`, `interval_marker`, `num_l` +FROM druid_test_dst.test_base_table +PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: druid_test_dst@test_base_table +PREHOOK: Output: database:druid_test_dst +PREHOOK: Output: druid_test_dst@druid_test_table_utc +POSTHOOK: query: CREATE TABLE druid_test_table_utc +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +AS +select cast(`timecolumn` as timestamp with local time zone) as `__time`, `interval_marker`, `num_l` +FROM druid_test_dst.test_base_table +POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: druid_test_dst@test_base_table +POSTHOOK: Output: database:druid_test_dst +POSTHOOK: Output: druid_test_dst@druid_test_table_utc +POSTHOOK: Lineage: druid_test_table_utc.__time EXPRESSION [(test_base_table)test_base_table.FieldSchema(name:timecolumn, type:timestamp, comment:null), ] +POSTHOOK: Lineage: druid_test_table_utc.interval_marker SIMPLE [(test_base_table)test_base_table.FieldSchema(name:interval_marker, type:string, comment:null), ] +POSTHOOK: Lineage: druid_test_table_utc.num_l SIMPLE [(test_base_table)test_base_table.FieldSchema(name:num_l, type:double, comment:null), ] +PREHOOK: query: select * FROM druid_test_table_utc +PREHOOK: type: QUERY +PREHOOK: Input: druid_test_dst@druid_test_table_utc +PREHOOK: Output: hdfs://### HDFS PATH ### +POSTHOOK: query: select * FROM druid_test_table_utc +POSTHOOK: type: QUERY +POSTHOOK: Input: druid_test_dst@druid_test_table_utc +POSTHOOK: Output: hdfs://### HDFS PATH ### +2015-03-08 00:00:00.0 UTC i1-start 4.0 +2015-03-08 23:59:59.0 UTC i1-end 1.0 +2015-03-09 00:00:00.0 UTC i2-start 4.0 +2015-03-09 23:59:59.0 UTC i2-end 1.0 +2015-03-10 00:00:00.0 UTC i3-start 2.0 +2015-03-10 23:59:59.0 UTC i3-end 2.0 +PREHOOK: query: CREATE TABLE druid_test_table_utc2 (`__time` timestamp with local time zone, `interval_marker` string, `num_l` double) +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:druid_test_dst +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: CREATE TABLE druid_test_table_utc2 (`__time` timestamp with local time zone, `interval_marker` string, `num_l` double) +STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' +TBLPROPERTIES ("druid.segment.granularity" = "DAY") +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:druid_test_dst +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-08 00:00:00' as timestamp with local time zone), 'i1-start', 4) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-08 00:00:00' as timestamp with local time zone), 'i1-start', 4) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-08 23:59:59' as timestamp with local time zone), 'i1-end', 1) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-08 23:59:59' as timestamp with local time zone), 'i1-end', 1) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-09 00:00:00' as timestamp with local time zone), 'i2-start', 4) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-09 00:00:00' as timestamp with local time zone), 'i2-start', 4) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-09 23:59:59' as timestamp with local time zone), 'i2-end', 1) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-09 23:59:59' as timestamp with local time zone), 'i2-end', 1) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-10 00:00:00' as timestamp with local time zone), 'i3-start', 2) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-10 00:00:00' as timestamp with local time zone), 'i3-start', 2) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-10 23:59:59' as timestamp with local time zone), 'i3-end', 2) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: druid_test_dst@druid_test_table_utc2 +POSTHOOK: query: insert into druid_test_table_utc2 values (cast('2015-03-10 23:59:59' as timestamp with local time zone), 'i3-end', 2) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: druid_test_dst@druid_test_table_utc2 +PREHOOK: query: select * FROM druid_test_table_utc2 +PREHOOK: type: QUERY +PREHOOK: Input: druid_test_dst@druid_test_table_utc2 +PREHOOK: Output: hdfs://### HDFS PATH ### +POSTHOOK: query: select * FROM druid_test_table_utc2 +POSTHOOK: type: QUERY +POSTHOOK: Input: druid_test_dst@druid_test_table_utc2 +POSTHOOK: Output: hdfs://### HDFS PATH ### +2015-03-08 00:00:00.0 UTC i1-start 4.0 +2015-03-08 23:59:59.0 UTC i1-end 1.0 +2015-03-09 00:00:00.0 UTC i2-start 4.0 +2015-03-09 23:59:59.0 UTC i2-end 1.0 +2015-03-10 00:00:00.0 UTC i3-start 2.0 +2015-03-10 23:59:59.0 UTC i3-end 2.0
http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/foldts.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/foldts.q.out b/ql/src/test/results/clientpositive/foldts.q.out index 2a82b9a..83a6481 100644 --- a/ql/src/test/results/clientpositive/foldts.q.out +++ b/ql/src/test/results/clientpositive/foldts.q.out @@ -45,7 +45,7 @@ POSTHOOK: query: select ctimestamp1, unix_timestamp(ctimestamp1), to_unix_timest POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -1969-12-31 15:59:46.674 -13 -13 +1969-12-31 15:59:46.674 -28813 -28813 PREHOOK: query: create temporary table src1orc stored as orc as select * from src1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src1 http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/infer_join_preds.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_join_preds.q.out b/ql/src/test/results/clientpositive/infer_join_preds.q.out index d8163aa..0dcbbb4 100644 --- a/ql/src/test/results/clientpositive/infer_join_preds.q.out +++ b/ql/src/test/results/clientpositive/infer_join_preds.q.out @@ -1177,7 +1177,7 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35, _col36, _col37, _col38 Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL Column stats: NONE Filter Operator - predicate: (concat(CASE WHEN (_col1 is null) THEN (1) ELSE (_col1) END, ',', CASE WHEN (_col2 is null) THEN (1) ELSE (_col2) END, ',', CASE WHEN (_col3 is null) THEN (1) ELSE (_col3) END, ',', CASE WHEN (_col4 is null) THEN (1) ELSE (_col4) END, ',', CASE WHEN (_col5 is null) THEN ('') ELSE (_col5) END, ',', CASE WHEN (_col18 is null) THEN (1) ELSE (_col18) END, ',', CASE WHEN (_col6 is null) THEN (1) ELSE (_col6) END, ',', CASE WHEN (length(_col7) is null) THEN ('') ELSE (_col7) END, ',', CASE WHEN (_col8 is null) THEN (TIMESTAMP'2017-12-08 00:00:00.0') ELSE (_col8) END, ',', CASE WHEN (_col9 is null) THEN (1) ELSE (_col9) END, ',', CASE WHEN (_col10 is null) THEN (1) ELSE (_col10) END, ',', CASE WHEN (_col11 is null) THEN (1) ELSE (_col11) END, ',', CASE WHEN (_col12 is null) THEN (1) ELSE (_col12) END, ',', CASE WHEN (length(_col13) is null) THEN ('') ELSE (_col13) END, ',', CASE WHEN (length(_col14) is null) THEN ('') ELSE (_col14) END, ',', CASE WHEN (_col15 is null ) THEN (1) ELSE (_col15) END, ',', CASE WHEN (_col16 is null) THEN (1) ELSE (_col16) END, ',', CASE WHEN (_col17 is null) THEN (1) ELSE (_col17) END) <> concat(CASE WHEN (length(_col20) is null) THEN ('') ELSE (_col20) END, ',', CASE WHEN (_col21 is null) THEN (1) ELSE (_col21) END, ',', CASE WHEN (_col22 is null) THEN (1) ELSE (_col22) END, ',', CASE WHEN (_col23 is null) THEN (1) ELSE (_col23) END, ',', CASE WHEN (_col24 is null) THEN (1) ELSE (_col24) END, ',', CASE WHEN (_col25 is null) THEN ('') ELSE (_col25) END, ',', CASE WHEN (_col38 is null) THEN (1) ELSE (_col38) END, ',', CASE WHEN (_col26 is null) THEN (1) ELSE (_col26) END, ',', CASE WHEN (length(_col27) is null) THEN ('') ELSE (_col27) END, ',', CASE WHEN (_col28 is null) THEN (TIMESTAMP'2017-12-08 00:00:00.0') ELSE (_col28) END, ',', CASE WHEN (_col29 is null) THEN (1) ELSE (_col29) END, ',', CASE WHEN (_col30 is null) THEN (1) ELSE (_col30) END, ',', CASE WHEN (_col31 is null) THEN (1) ELSE (_col31) END, ',', CASE WH EN (_col32 is null) THEN (1) ELSE (_col32) END, ',', CASE WHEN (length(_col33) is null) THEN ('') ELSE (_col33) END, ',', CASE WHEN (length(_col34) is null) THEN ('') ELSE (_col34) END, ',', CASE WHEN (_col35 is null) THEN (1) ELSE (_col35) END, ',', CASE WHEN (_col36 is null) THEN (1) ELSE (_col36) END, ',', CASE WHEN (_col37 is null) THEN (1) ELSE (_col37) END)) (type: boolean) + predicate: (concat(CASE WHEN (_col1 is null) THEN (1) ELSE (_col1) END, ',', CASE WHEN (_col2 is null) THEN (1) ELSE (_col2) END, ',', CASE WHEN (_col3 is null) THEN (1) ELSE (_col3) END, ',', CASE WHEN (_col4 is null) THEN (1) ELSE (_col4) END, ',', CASE WHEN (_col5 is null) THEN ('') ELSE (_col5) END, ',', CASE WHEN (_col18 is null) THEN (1) ELSE (_col18) END, ',', CASE WHEN (_col6 is null) THEN (1) ELSE (_col6) END, ',', CASE WHEN (length(_col7) is null) THEN ('') ELSE (_col7) END, ',', CASE WHEN (_col8 is null) THEN (TIMESTAMP'2017-12-08 00:00:00') ELSE (_col8) END, ',', CASE WHEN (_col9 is null) THEN (1) ELSE (_col9) END, ',', CASE WHEN (_col10 is null) THEN (1) ELSE (_col10) END, ',', CASE WHEN (_col11 is null) THEN (1) ELSE (_col11) END, ',', CASE WHEN (_col12 is null) THEN (1) ELSE (_col12) END, ',', CASE WHEN (length(_col13) is null) THEN ('') ELSE (_col13) END, ',', CASE WHEN (length(_col14) is null) THEN ('') ELSE (_col14) END, ',', CASE WHEN (_col15 is null) THEN (1) ELSE (_col15) END, ',', CASE WHEN (_col16 is null) THEN (1) ELSE (_col16) END, ',', CASE WHEN (_col17 is null) THEN (1) ELSE (_col17) END) <> concat(CASE WHEN (length(_col20) is null) THEN ('') ELSE (_col20) END, ',', CASE WHEN (_col21 is null) THEN (1) ELSE (_col21) END, ',', CASE WHEN (_col22 is null) THEN (1) ELSE (_col22) END, ',', CASE WHEN (_col23 is null) THEN (1) ELSE (_col23) END, ',', CASE WHEN (_col24 is null) THEN (1) ELSE (_col24) END, ',', CASE WHEN (_col25 is null) THEN ('') ELSE (_col25) END, ',', CASE WHEN (_col38 is null) THEN (1) ELSE (_col38) END, ',', CASE WHEN (_col26 is null) THEN (1) ELSE (_col26) END, ',', CASE WHEN (length(_col27) is null) THEN ('') ELSE (_col27) END, ',', CASE WHEN (_col28 is null) THEN (TIMESTAMP'2017-12-08 00:00:00') ELSE (_col28) END, ',', CASE WHEN (_col29 is null) THEN (1) ELSE (_col29) END, ',', CASE WHEN (_col30 is null) THEN (1) ELSE (_col30) END, ',', CASE WHEN (_col31 is null) THEN (1) ELSE (_col31) END, ',', CASE WHEN ( _col32 is null) THEN (1) ELSE (_col32) END, ',', CASE WHEN (length(_col33) is null) THEN ('') ELSE (_col33) END, ',', CASE WHEN (length(_col34) is null) THEN ('') ELSE (_col34) END, ',', CASE WHEN (_col35 is null) THEN (1) ELSE (_col35) END, ',', CASE WHEN (_col36 is null) THEN (1) ELSE (_col36) END, ',', CASE WHEN (_col37 is null) THEN (1) ELSE (_col37) END)) (type: boolean) Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col0 (type: bigint) http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/interval_alt.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/interval_alt.q.out b/ql/src/test/results/clientpositive/interval_alt.q.out index a8f7292..ca645b9 100644 --- a/ql/src/test/results/clientpositive/interval_alt.q.out +++ b/ql/src/test/results/clientpositive/interval_alt.q.out @@ -139,7 +139,7 @@ STAGE PLANS: alias: t_n18 Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: (DATE'2012-01-01' + IntervalDayLiteralProcessor(((- dt) * dt))) (type: timestamp), (DATE'2012-01-01' - IntervalDayLiteralProcessor(((- dt) * dt))) (type: timestamp), TIMESTAMP'2012-01-04 00:00:00.0' (type: timestamp), (DATE'2012-01-01' + IntervalYearMonthLiteralProcessor(concat(dt, '-1'))) (type: date) + expressions: (DATE'2012-01-01' + IntervalDayLiteralProcessor(((- dt) * dt))) (type: timestamp), (DATE'2012-01-01' - IntervalDayLiteralProcessor(((- dt) * dt))) (type: timestamp), TIMESTAMP'2012-01-04 00:00:00' (type: timestamp), (DATE'2012-01-01' + IntervalYearMonthLiteralProcessor(concat(dt, '-1'))) (type: date) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE File Output Operator http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/interval_arithmetic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/interval_arithmetic.q.out b/ql/src/test/results/clientpositive/interval_arithmetic.q.out index 7cb7270..819f1fe 100644 --- a/ql/src/test/results/clientpositive/interval_arithmetic.q.out +++ b/ql/src/test/results/clientpositive/interval_arithmetic.q.out @@ -174,7 +174,7 @@ limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1_n0 #### A masked pattern was here #### -1969-12-31 -10749 23:00:00.000000000 10749 23:00:00.000000000 0 00:00:00.000000000 +1969-12-31 -10750 00:00:00.000000000 10750 00:00:00.000000000 0 00:00:00.000000000 NULL NULL NULL NULL PREHOOK: query: explain select @@ -396,7 +396,7 @@ limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1_n0 #### A masked pattern was here #### -1969-12-31 1969-09-22 13:37:26.876543211 1970-04-09 11:22:33.123456789 1970-04-09 11:22:33.123456789 1969-09-22 13:37:26.876543211 1969-09-22 13:37:26.876543211 1970-04-09 11:22:33.123456789 +1969-12-31 1969-09-22 12:37:26.876543211 1970-04-09 11:22:33.123456789 1970-04-09 11:22:33.123456789 1969-09-22 12:37:26.876543211 1969-09-22 12:37:26.876543211 1970-04-09 11:22:33.123456789 NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain select @@ -558,7 +558,7 @@ limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1_n0 #### A masked pattern was here #### -1969-12-31 15:59:46.674 1969-09-23 05:37:13.550543211 1970-04-10 03:22:19.797456789 1970-04-10 03:22:19.797456789 1969-09-23 05:37:13.550543211 1969-09-23 05:37:13.550543211 1970-04-10 03:22:19.797456789 +1969-12-31 15:59:46.674 1969-09-23 04:37:13.550543211 1970-04-10 03:22:19.797456789 1970-04-10 03:22:19.797456789 1969-09-23 04:37:13.550543211 1969-09-23 04:37:13.550543211 1970-04-10 03:22:19.797456789 NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain select @@ -630,7 +630,7 @@ STAGE PLANS: alias: interval_arithmetic_1_n0 Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - expressions: TIMESTAMP'2016-11-11 03:04:00.0' (type: timestamp) + expressions: TIMESTAMP'2016-11-11 03:04:00' (type: timestamp) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 491520 Basic stats: COMPLETE Column stats: COMPLETE Limit http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out b/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out index be1b4c6..028c3ca 100644 --- a/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out +++ b/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out @@ -665,22 +665,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k_orc_bucketed - Statistics: Num rows: 1237 Data size: 707670 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1234 Data size: 706090 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: ROW__ID (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) outputColumnNames: ROW__ID - Statistics: Num rows: 1237 Data size: 707670 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1234 Data size: 706090 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count() keys: ROW__ID (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 618 Data size: 51912 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 617 Data size: 51828 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) sort order: + Map-reduce partition columns: _col0 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) - Statistics: Num rows: 618 Data size: 51912 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 617 Data size: 51828 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) Execution mode: llap LLAP IO: may be used (ACID table) @@ -692,13 +692,13 @@ STAGE PLANS: keys: KEY._col0 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 618 Data size: 51912 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 617 Data size: 51828 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (_col1 > 1L) (type: boolean) - Statistics: Num rows: 206 Data size: 17304 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 205 Data size: 17220 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 206 Data size: 17304 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 205 Data size: 17220 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out b/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out index 0052f58..083aab3 100644 --- a/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out +++ b/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out @@ -55,7 +55,7 @@ STAGE PLANS: alias: alltypesorc GatherStats: false Select Operator - expressions: TIMESTAMP'2012-01-01 01:02:03.0' (type: timestamp) + expressions: TIMESTAMP'2012-01-01 09:02:03' (type: timestamp) outputColumnNames: _col0 ListSink @@ -228,11 +228,11 @@ POSTHOOK: query: select unix_timestamp(current_timestamp()), POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -1325408523 1 2 3 -1325408523 1 2 3 -1325408523 1 2 3 -1325408523 1 2 3 -1325408523 1 2 3 +1325408523 9 2 3 +1325408523 9 2 3 +1325408523 9 2 3 +1325408523 9 2 3 +1325408523 9 2 3 PREHOOK: query: select to_date(current_timestamp()), year(current_timestamp()), month(current_timestamp()), @@ -315,7 +315,7 @@ POSTHOOK: query: select current_timestamp() - current_timestamp(), POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -0 00:00:00.000000000 0 01:02:03.000000000 -0 01:02:03.000000000 0 00:00:00.000000000 +0 00:00:00.000000000 0 09:02:03.000000000 -0 09:02:03.000000000 0 00:00:00.000000000 PREHOOK: query: select ctimestamp1 - current_date(), ctimestamp1- ctimestamp2, current_date() - current_date(), @@ -338,11 +338,11 @@ where ctimestamp1 is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### --15340 08:00:12.326000000 -0 00:00:21.201000000 0 00:00:00.000000000 15340 07:59:51.125000000 --15340 08:00:03.213000000 -0 00:00:04.759000000 0 00:00:00.000000000 15340 07:59:58.454000000 --15340 08:00:14.813000000 -0 00:00:21.774000000 0 00:00:00.000000000 15340 07:59:53.039000000 --15340 08:00:08.566000000 -0 00:00:21.918000000 0 00:00:00.000000000 15340 07:59:46.648000000 --15340 07:59:44.993000000 -0 00:00:00.141000000 0 00:00:00.000000000 15340 07:59:44.852000000 +-15340 08:00:12.326000000 -0 00:00:22.201000000 0 00:00:00.000000000 15340 07:59:50.125000000 +-15340 08:00:03.213000000 -0 00:00:05.759000000 0 00:00:00.000000000 15340 07:59:57.454000000 +-15340 08:00:14.813000000 -0 00:00:22.774000000 0 00:00:00.000000000 15340 07:59:52.039000000 +-15340 08:00:08.566000000 -0 00:00:22.918000000 0 00:00:00.000000000 15340 07:59:45.648000000 +-15340 07:59:43.993000000 -0 00:00:00.141000000 0 00:00:00.000000000 15340 07:59:43.852000000 PREHOOK: query: select current_date, current_timestamp from src limit 5 PREHOOK: type: QUERY PREHOOK: Input: default@src @@ -351,11 +351,11 @@ POSTHOOK: query: select current_date, current_timestamp from src limit 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -2012-01-01 2012-01-01 01:02:03 -2012-01-01 2012-01-01 01:02:03 -2012-01-01 2012-01-01 01:02:03 -2012-01-01 2012-01-01 01:02:03 -2012-01-01 2012-01-01 01:02:03 +2012-01-01 2012-01-01 09:02:03 +2012-01-01 2012-01-01 09:02:03 +2012-01-01 2012-01-01 09:02:03 +2012-01-01 2012-01-01 09:02:03 +2012-01-01 2012-01-01 09:02:03 PREHOOK: query: select `[kv]+.+` from srcpart order by key PREHOOK: type: QUERY PREHOOK: Input: default@srcpart http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/default_constraint.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/default_constraint.q.out b/ql/src/test/results/clientpositive/llap/default_constraint.q.out index 775cba8..f93eb1f 100644 --- a/ql/src/test/results/clientpositive/llap/default_constraint.q.out +++ b/ql/src/test/results/clientpositive/llap/default_constraint.q.out @@ -440,7 +440,7 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE function name: inline Select Operator - expressions: CAST( col1 AS DATE) (type: date), TIMESTAMP'2016-02-22 12:45:07.0' (type: timestamp), TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 US/Pacific' (type: timestamp with local time zone), CURRENT_DATE() (type: date), CAST( col2 AS TIMESTAMP) (type: timestamp) + expressions: CAST( col1 AS DATE) (type: date), TIMESTAMP'2016-02-22 12:45:07' (type: timestamp), TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 US/Pacific' (type: timestamp with local time zone), CURRENT_DATE() (type: date), CAST( col2 AS TIMESTAMP) (type: timestamp) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 1 Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE File Output Operator http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out index 1c0841c..b9530fa 100644 --- a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out +++ b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out @@ -170,7 +170,7 @@ Table Type: MANAGED_TABLE Table Parameters: bucketing_version 2 numFiles 1 - totalSize 295583 + totalSize 295638 transactional true transactional_properties default #### A masked pattern was here #### @@ -205,9 +205,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: acid_ivot - Statistics: Num rows: 5864 Data size: 2955830 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 5865 Data size: 2956380 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - Statistics: Num rows: 5864 Data size: 2955830 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 5865 Data size: 2956380 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count() mode: hash @@ -376,7 +376,7 @@ Table Type: MANAGED_TABLE Table Parameters: bucketing_version 2 numFiles 1 - totalSize 1663 + totalSize 1652 transactional true transactional_properties default #### A masked pattern was here #### @@ -411,9 +411,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: acid_ivot - Statistics: Num rows: 32 Data size: 16630 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 32 Data size: 16520 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - Statistics: Num rows: 32 Data size: 16630 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 32 Data size: 16520 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count() mode: hash @@ -509,7 +509,7 @@ Table Type: MANAGED_TABLE Table Parameters: bucketing_version 2 numFiles 2 - totalSize 3326 + totalSize 3304 transactional true transactional_properties default #### A masked pattern was here #### @@ -544,9 +544,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: acid_ivot - Statistics: Num rows: 65 Data size: 33260 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 65 Data size: 33040 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - Statistics: Num rows: 65 Data size: 33260 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 65 Data size: 33040 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count() mode: hash @@ -638,7 +638,7 @@ Table Type: MANAGED_TABLE Table Parameters: bucketing_version 2 numFiles 3 - totalSize 298909 + totalSize 298943 transactional true transactional_properties default #### A masked pattern was here #### @@ -673,9 +673,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: acid_ivot - Statistics: Num rows: 5930 Data size: 2989090 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 5931 Data size: 2989430 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - Statistics: Num rows: 5930 Data size: 2989090 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 5931 Data size: 2989430 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count() mode: hash http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out b/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out index 6900cdb..fb90b60 100644 --- a/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out @@ -162,7 +162,7 @@ POSTHOOK: query: select sum(hash(*)) from llap_temp_table POSTHOOK: type: QUERY POSTHOOK: Input: default@llap_temp_table #### A masked pattern was here #### -212787774304 +251958877792 PREHOOK: query: explain select * from orc_llap_n0 where cint > 10 and cint < 5000000 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_analyze.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_analyze.q.out b/ql/src/test/results/clientpositive/llap/orc_analyze.q.out index 14bf186..25426bf 100644 --- a/ql/src/test/results/clientpositive/llap/orc_analyze.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_analyze.q.out @@ -102,7 +102,7 @@ Table Parameters: numFiles 1 numRows 100 rawDataSize 52600 - totalSize 3236 + totalSize 3222 #### A masked pattern was here #### # Storage Information @@ -150,7 +150,7 @@ Table Parameters: numFiles 1 numRows 100 rawDataSize 52600 - totalSize 3236 + totalSize 3222 #### A masked pattern was here #### # Storage Information @@ -237,7 +237,7 @@ Table Parameters: numFiles 1 numRows 100 rawDataSize 52600 - totalSize 3236 + totalSize 3222 #### A masked pattern was here #### # Storage Information @@ -345,7 +345,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 2134 + totalSize 2123 #### A masked pattern was here #### # Storage Information @@ -386,7 +386,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 22050 - totalSize 2147 + totalSize 2134 #### A masked pattern was here #### # Storage Information @@ -439,7 +439,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 2134 + totalSize 2123 #### A masked pattern was here #### # Storage Information @@ -480,7 +480,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 22050 - totalSize 2147 + totalSize 2134 #### A masked pattern was here #### # Storage Information @@ -576,7 +576,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 2134 + totalSize 2123 #### A masked pattern was here #### # Storage Information @@ -617,7 +617,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 22050 - totalSize 2147 + totalSize 2134 #### A masked pattern was here #### # Storage Information @@ -731,7 +731,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 21955 - totalSize 5394 + totalSize 5341 #### A masked pattern was here #### # Storage Information @@ -772,7 +772,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 22043 - totalSize 5388 + totalSize 5339 #### A masked pattern was here #### # Storage Information @@ -825,7 +825,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 21955 - totalSize 5394 + totalSize 5341 #### A masked pattern was here #### # Storage Information @@ -866,7 +866,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 22043 - totalSize 5388 + totalSize 5339 #### A masked pattern was here #### # Storage Information @@ -968,7 +968,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 21955 - totalSize 5394 + totalSize 5341 #### A masked pattern was here #### # Storage Information @@ -1009,7 +1009,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 22043 - totalSize 5388 + totalSize 5339 #### A masked pattern was here #### # Storage Information @@ -1117,7 +1117,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 2134 + totalSize 2123 #### A masked pattern was here #### # Storage Information @@ -1170,7 +1170,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 2134 + totalSize 2123 #### A masked pattern was here #### # Storage Information http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_llap.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_llap.q.out b/ql/src/test/results/clientpositive/llap/orc_llap.q.out index 9235fbc..7f8667e 100644 --- a/ql/src/test/results/clientpositive/llap/orc_llap.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_llap.q.out @@ -379,7 +379,7 @@ POSTHOOK: query: select sum(hash(*)) from (select * from orc_llap where cint > 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_llap #### A masked pattern was here #### --197609091139 +258089178813 PREHOOK: query: explain select sum(hash(*)) from (select cstring2 from orc_llap where cint > 5 and cint < 10) t PREHOOK: type: QUERY @@ -837,7 +837,7 @@ POSTHOOK: query: select sum(hash(*)) from (select * from orc_llap where cint > 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_llap #### A masked pattern was here #### --395218182278 +516178357626 PREHOOK: query: explain select sum(hash(*)) from (select cstring2 from orc_llap where cint > 5 and cint < 10) t PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_merge11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge11.q.out b/ql/src/test/results/clientpositive/llap/orc_merge11.q.out index 8e7840c..5327299 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge11.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge11.q.out @@ -96,7 +96,7 @@ File Statistics: Column 5: count: 50000 hasNull: false bytesOnDisk: 64 min: 1969-12-31 16:00:00.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:00:00.0 max UTC: 1969-12-31 08:04:10.0 Stripes: - Stripe: offset: 3 data: 5761 rows: 50000 tail: 112 index: 433 + Stripe: offset: 3 data: 5761 rows: 50000 tail: 99 index: 433 Stream: column 0 section ROW_INDEX start: 3 length 17 Stream: column 1 section ROW_INDEX start: 20 length 73 Stream: column 2 section ROW_INDEX start: 93 length 79 @@ -155,7 +155,7 @@ Stripes: Entry 3: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,506,294,0,232,304 Entry 4: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,666,54,0,312,64 -File length: 6685 bytes +File length: 6672 bytes Padding length: 0 bytes Padding ratio: 0% ________________________________________________________________________________________________________________________ @@ -187,7 +187,7 @@ File Statistics: Column 5: count: 50000 hasNull: false bytesOnDisk: 64 min: 1969-12-31 16:00:00.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:00:00.0 max UTC: 1969-12-31 08:04:10.0 Stripes: - Stripe: offset: 3 data: 5761 rows: 50000 tail: 112 index: 433 + Stripe: offset: 3 data: 5761 rows: 50000 tail: 99 index: 433 Stream: column 0 section ROW_INDEX start: 3 length 17 Stream: column 1 section ROW_INDEX start: 20 length 73 Stream: column 2 section ROW_INDEX start: 93 length 79 @@ -246,7 +246,7 @@ Stripes: Entry 3: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,506,294,0,232,304 Entry 4: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,666,54,0,312,64 -File length: 6685 bytes +File length: 6672 bytes Padding length: 0 bytes Padding ratio: 0% ________________________________________________________________________________________________________________________ @@ -306,7 +306,7 @@ File Statistics: Column 5: count: 100000 hasNull: false bytesOnDisk: 128 min: 1969-12-31 16:00:00.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:00:00.0 max UTC: 1969-12-31 08:04:10.0 Stripes: - Stripe: offset: 3 data: 5761 rows: 50000 tail: 112 index: 433 + Stripe: offset: 3 data: 5761 rows: 50000 tail: 99 index: 433 Stream: column 0 section ROW_INDEX start: 3 length 17 Stream: column 1 section ROW_INDEX start: 20 length 73 Stream: column 2 section ROW_INDEX start: 93 length 79 @@ -364,22 +364,22 @@ Stripes: Entry 2: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,354,22,0,156,32 Entry 3: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,506,294,0,232,304 Entry 4: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,666,54,0,312,64 - Stripe: offset: 6309 data: 5761 rows: 50000 tail: 112 index: 433 - Stream: column 0 section ROW_INDEX start: 6309 length 17 - Stream: column 1 section ROW_INDEX start: 6326 length 73 - Stream: column 2 section ROW_INDEX start: 6399 length 79 - Stream: column 3 section ROW_INDEX start: 6478 length 85 - Stream: column 4 section ROW_INDEX start: 6563 length 92 - Stream: column 5 section ROW_INDEX start: 6655 length 87 - Stream: column 1 section DATA start: 6742 length 30 - Stream: column 2 section DATA start: 6772 length 24 - Stream: column 2 section LENGTH start: 6796 length 8 - Stream: column 2 section DICTIONARY_DATA start: 6804 length 23 - Stream: column 3 section DATA start: 6827 length 5114 - Stream: column 4 section DATA start: 11941 length 480 - Stream: column 4 section SECONDARY start: 12421 length 18 - Stream: column 5 section DATA start: 12439 length 46 - Stream: column 5 section SECONDARY start: 12485 length 18 + Stripe: offset: 6296 data: 5761 rows: 50000 tail: 99 index: 433 + Stream: column 0 section ROW_INDEX start: 6296 length 17 + Stream: column 1 section ROW_INDEX start: 6313 length 73 + Stream: column 2 section ROW_INDEX start: 6386 length 79 + Stream: column 3 section ROW_INDEX start: 6465 length 85 + Stream: column 4 section ROW_INDEX start: 6550 length 92 + Stream: column 5 section ROW_INDEX start: 6642 length 87 + Stream: column 1 section DATA start: 6729 length 30 + Stream: column 2 section DATA start: 6759 length 24 + Stream: column 2 section LENGTH start: 6783 length 8 + Stream: column 2 section DICTIONARY_DATA start: 6791 length 23 + Stream: column 3 section DATA start: 6814 length 5114 + Stream: column 4 section DATA start: 11928 length 480 + Stream: column 4 section SECONDARY start: 12408 length 18 + Stream: column 5 section DATA start: 12426 length 46 + Stream: column 5 section SECONDARY start: 12472 length 18 Encoding column 0: DIRECT Encoding column 1: DIRECT_V2 Encoding column 2: DICTIONARY_V2[6] @@ -423,7 +423,7 @@ Stripes: Entry 3: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,506,294,0,232,304 Entry 4: count: 10000 hasNull: false min: 1969-12-31 16:04:10.0 max: 1969-12-31 16:04:10.0 min UTC: 1969-12-31 08:04:10.0 max UTC: 1969-12-31 08:04:10.0 positions: 0,666,54,0,312,64 -File length: 13004 bytes +File length: 12978 bytes Padding length: 0 bytes Padding ratio: 0% ________________________________________________________________________________________________________________________ http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_merge5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge5.q.out b/ql/src/test/results/clientpositive/llap/orc_merge5.q.out index d49c72a..dfa5e12 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge5.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge5.q.out @@ -134,7 +134,7 @@ POSTHOOK: query: analyze table orc_merge5b_n0 compute statistics noscan POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_merge5b_n0 POSTHOOK: Output: default@orc_merge5b_n0 -Found 2 items +Found 1 items #### A masked pattern was here #### PREHOOK: query: select * from orc_merge5b_n0 PREHOOK: type: QUERY @@ -335,7 +335,7 @@ POSTHOOK: query: analyze table orc_merge5b_n0 compute statistics noscan POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_merge5b_n0 POSTHOOK: Output: default@orc_merge5b_n0 -Found 2 items +Found 1 items #### A masked pattern was here #### PREHOOK: query: select * from orc_merge5b_n0 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_merge6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge6.q.out b/ql/src/test/results/clientpositive/llap/orc_merge6.q.out index 1359111..c86c35b 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge6.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge6.q.out @@ -170,9 +170,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_merge5a_n1 POSTHOOK: Output: default@orc_merge5a_n1 POSTHOOK: Output: default@orc_merge5a_n1@year=2001/hour=24 -Found 2 items +Found 1 items #### A masked pattern was here #### -Found 2 items +Found 1 items #### A masked pattern was here #### PREHOOK: query: show partitions orc_merge5a_n1 PREHOOK: type: SHOWPARTITIONS @@ -466,9 +466,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_merge5a_n1 POSTHOOK: Output: default@orc_merge5a_n1 POSTHOOK: Output: default@orc_merge5a_n1@year=2001/hour=24 -Found 2 items +Found 1 items #### A masked pattern was here #### -Found 2 items +Found 1 items #### A masked pattern was here #### PREHOOK: query: show partitions orc_merge5a_n1 PREHOOK: type: SHOWPARTITIONS http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_merge7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge7.q.out b/ql/src/test/results/clientpositive/llap/orc_merge7.q.out index 273a5be..0b30145 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge7.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge7.q.out @@ -203,7 +203,7 @@ POSTHOOK: Output: default@orc_merge5a_n0 POSTHOOK: Output: default@orc_merge5a_n0@st=0.8 Found 1 items #### A masked pattern was here #### -Found 2 items +Found 1 items #### A masked pattern was here #### PREHOOK: query: show partitions orc_merge5a_n0 PREHOOK: type: SHOWPARTITIONS @@ -572,7 +572,7 @@ POSTHOOK: Output: default@orc_merge5a_n0 POSTHOOK: Output: default@orc_merge5a_n0@st=0.8 Found 1 items #### A masked pattern was here #### -Found 2 items +Found 1 items #### A masked pattern was here #### PREHOOK: query: show partitions orc_merge5a_n0 PREHOOK: type: SHOWPARTITIONS http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out b/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out index 84cd53d..f86fe77 100644 --- a/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out @@ -26,7 +26,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -35,7 +35,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da= date '1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -44,7 +44,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da= date '1970-02 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02-20' as date) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -53,7 +53,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02-20' as date) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -62,7 +62,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02-20' as varchar(20)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -71,7 +71,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02-20' as varchar(20)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -80,7 +80,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da=cast('1970-02- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da!='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -89,7 +89,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da!='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da!='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -98,7 +98,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da!='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-27' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -107,7 +107,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-27' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-27' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -116,7 +116,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-27' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-29' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -125,7 +125,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-29' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-29' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -134,7 +134,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-29' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<'1970-02-15' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -161,7 +161,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -170,7 +170,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-27' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -179,7 +179,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-27' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-27' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -188,7 +188,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da<='1970-02-27' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -197,7 +197,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -206,7 +206,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -215,7 +215,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -224,7 +224,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -251,7 +251,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970-02-19' and '1970-02-22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -260,7 +260,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970-02-19' and '1970-02-28' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -269,7 +269,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970-02-19' and '1970-02-28' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 @@ -278,7 +278,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970- POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n3 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n3 where da between '1970-02-18' and '1970-02-19' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n3 http://git-wip-us.apache.org/repos/asf/hive/blob/c95136a0/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out b/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out index 15f52ec..4b535d4 100644 --- a/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out @@ -26,7 +26,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=0.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -35,7 +35,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d='0.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -44,7 +44,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d='0.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d='0.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -53,7 +53,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d='0.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=cast('0.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -62,7 +62,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=cast('0.22' as POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=cast('0.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -71,7 +71,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d=cast('0.22' as POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=0.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -80,7 +80,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=0.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -89,7 +89,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!='0.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -98,7 +98,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!='0.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!='0.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -107,7 +107,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!='0.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=cast('0.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -116,7 +116,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=cast('0.22' as POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=cast('0.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -125,7 +125,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d!=cast('0.22' as POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<11.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -134,7 +134,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<11.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<11.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -143,7 +143,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<11.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<'11.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -152,7 +152,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<'11.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<'11.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -161,7 +161,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<'11.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<cast('11.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -170,7 +170,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<cast('11.22' as POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<cast('11.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -179,7 +179,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<cast('11.22' as POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<1 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -188,7 +188,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<1 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<1 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -197,7 +197,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<1 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -206,7 +206,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -215,7 +215,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<='11.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -224,7 +224,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<='11.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<='11.22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -233,7 +233,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<='11.22' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -242,7 +242,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' a POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -251,7 +251,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' a POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' as decimal) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -260,7 +260,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' a POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' as decimal) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -269,7 +269,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=cast('11.22' a POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22BD PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -278,7 +278,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22BD POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22BD PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -287,7 +287,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=11.22BD POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=12 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -296,7 +296,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=12 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=12 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -305,7 +305,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d<=12 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '1.0') PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -314,7 +314,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '1. POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '1.0') PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -323,7 +323,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '1. POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '11.22') PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -332,7 +332,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '11 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '11.22') PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -341,7 +341,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.22', '11 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', '1.0') PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -368,7 +368,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -377,7 +377,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22, cast('11.22' as float)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -386,7 +386,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22, cast('11.22' as float)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -395,7 +395,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d in ('0.9', 0.22 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -404,7 +404,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -413,7 +413,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1000 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -422,7 +422,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1000 PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -431,7 +431,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -81475875500 +85510533500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and '2.0' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -440,7 +440,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and ' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and '2.0' PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -449,7 +449,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and ' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and cast(3 as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -458,7 +458,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and cast(3 as float) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -467,7 +467,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 0 and c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### --252951929000 +-250934600000 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 1 and cast(30 as char(10)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -476,7 +476,7 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 1 and c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500 PREHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 1 and cast(30 as char(10)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypesorc_n5 @@ -485,4 +485,4 @@ POSTHOOK: query: select sum(hash(*)) from newtypesorc_n5 where d between 1 and c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypesorc_n5 #### A masked pattern was here #### -334427804500 +336445133500
