Repository: hive Updated Branches: refs/heads/master 2e8324e43 -> 7cfe3743f
http://git-wip-us.apache.org/repos/asf/hive/blob/7cfe3743/ql/src/test/results/clientpositive/vector_struct_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_struct_in.q.out b/ql/src/test/results/clientpositive/vector_struct_in.q.out new file mode 100644 index 0000000..c78b428 --- /dev/null +++ b/ql/src/test/results/clientpositive/vector_struct_in.q.out @@ -0,0 +1,825 @@ +PREHOOK: query: -- SORT_QUERY_RESULTS + +-- 2 Strings +create table test_1 (`id` string, `lineid` string) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_1 +POSTHOOK: query: -- SORT_QUERY_RESULTS + +-- 2 Strings +create table test_1 (`id` string, `lineid` string) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_1 +PREHOOK: query: insert into table test_1 values ('one','1'), ('seven','1') +PREHOOK: type: QUERY +PREHOOK: Input: default@values__tmp__table__1 +PREHOOK: Output: default@test_1 +POSTHOOK: query: insert into table test_1 values ('one','1'), ('seven','1') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@values__tmp__table__1 +POSTHOOK: Output: default@test_1 +POSTHOOK: Lineage: test_1.id SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: test_1.lineid SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +PREHOOK: query: explain +select * from test_1 where struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) +PREHOOK: type: QUERY +POSTHOOK: query: explain +select * from test_1 where struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_1 + Statistics: Num rows: 2 Data size: 346 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (struct(id,lineid)) IN (const struct('two','3'), const struct('three','1'), const struct('one','1'), const struct('five','2'), const struct('six','1'), const struct('eight','1'), const struct('seven','1'), const struct('nine','1'), const struct('ten','1')) (type: boolean) + Statistics: Num rows: 1 Data size: 173 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: id (type: string), lineid (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 1 Data size: 173 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 173 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from test_1 where struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) +PREHOOK: type: QUERY +PREHOOK: Input: default@test_1 +#### A masked pattern was here #### +POSTHOOK: query: select * from test_1 where struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1 +#### A masked pattern was here #### +one 1 +seven 1 +PREHOOK: query: explain +select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) as b from test_1 +PREHOOK: type: QUERY +POSTHOOK: query: explain +select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) as b from test_1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_1 + Statistics: Num rows: 2 Data size: 346 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: id (type: string), lineid (type: string), (struct(id,lineid)) IN (const struct('two','3'), const struct('three','1'), const struct('one','1'), const struct('five','2'), const struct('six','1'), const struct('eight','1'), const struct('seven','1'), const struct('nine','1'), const struct('ten','1')) (type: boolean) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 2 Data size: 346 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 2 Data size: 346 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) as b from test_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@test_1 +#### A masked pattern was here #### +POSTHOOK: query: select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two','3'), +struct('three','1'), +struct('one','1'), +struct('five','2'), +struct('six','1'), +struct('eight','1'), +struct('seven','1'), +struct('nine','1'), +struct('ten','1') +) as b from test_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_1 +#### A masked pattern was here #### +one 1 true +seven 1 true +PREHOOK: query: -- 2 Integers +create table test_2 (`id` int, `lineid` int) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_2 +POSTHOOK: query: -- 2 Integers +create table test_2 (`id` int, `lineid` int) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_2 +PREHOOK: query: insert into table test_2 values (1,1), (7,1) +PREHOOK: type: QUERY +PREHOOK: Input: default@values__tmp__table__2 +PREHOOK: Output: default@test_2 +POSTHOOK: query: insert into table test_2 values (1,1), (7,1) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@values__tmp__table__2 +POSTHOOK: Output: default@test_2 +POSTHOOK: Lineage: test_2.id EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: test_2.lineid EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +PREHOOK: query: explain +select * from test_2 where struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) +PREHOOK: type: QUERY +POSTHOOK: query: explain +select * from test_2 where struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_2 + Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (struct(id,lineid)) IN (const struct(2,3), const struct(3,1), const struct(1,1), const struct(5,2), const struct(6,1), const struct(8,1), const struct(7,1), const struct(9,1), const struct(10,1)) (type: boolean) + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: id (type: int), lineid (type: int) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from test_2 where struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) +PREHOOK: type: QUERY +PREHOOK: Input: default@test_2 +#### A masked pattern was here #### +POSTHOOK: query: select * from test_2 where struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_2 +#### A masked pattern was here #### +1 1 +7 1 +PREHOOK: query: explain +select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) as b from test_2 +PREHOOK: type: QUERY +POSTHOOK: query: explain +select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) as b from test_2 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_2 + Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: id (type: int), lineid (type: int), (struct(id,lineid)) IN (const struct(2,3), const struct(3,1), const struct(1,1), const struct(5,2), const struct(6,1), const struct(8,1), const struct(7,1), const struct(9,1), const struct(10,1)) (type: boolean) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) as b from test_2 +PREHOOK: type: QUERY +PREHOOK: Input: default@test_2 +#### A masked pattern was here #### +POSTHOOK: query: select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct(2,3), +struct(3,1), +struct(1,1), +struct(5,2), +struct(6,1), +struct(8,1), +struct(7,1), +struct(9,1), +struct(10,1) +) as b from test_2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_2 +#### A masked pattern was here #### +1 1 true +7 1 true +PREHOOK: query: -- 1 String and 1 Integer +create table test_3 (`id` string, `lineid` int) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_3 +POSTHOOK: query: -- 1 String and 1 Integer +create table test_3 (`id` string, `lineid` int) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_3 +PREHOOK: query: insert into table test_3 values ('one',1), ('seven',1) +PREHOOK: type: QUERY +PREHOOK: Input: default@values__tmp__table__3 +PREHOOK: Output: default@test_3 +POSTHOOK: query: insert into table test_3 values ('one',1), ('seven',1) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@values__tmp__table__3 +POSTHOOK: Output: default@test_3 +POSTHOOK: Lineage: test_3.id SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: test_3.lineid EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +PREHOOK: query: explain +select * from test_3 where struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) +PREHOOK: type: QUERY +POSTHOOK: query: explain +select * from test_3 where struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_3 + Statistics: Num rows: 2 Data size: 184 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (struct(id,lineid)) IN (const struct('two',3), const struct('three',1), const struct('one',1), const struct('five',2), const struct('six',1), const struct('eight',1), const struct('seven',1), const struct('nine',1), const struct('ten',1)) (type: boolean) + Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: id (type: string), lineid (type: int) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from test_3 where struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) +PREHOOK: type: QUERY +PREHOOK: Input: default@test_3 +#### A masked pattern was here #### +POSTHOOK: query: select * from test_3 where struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_3 +#### A masked pattern was here #### +one 1 +seven 1 +PREHOOK: query: explain +select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) as b from test_3 +PREHOOK: type: QUERY +POSTHOOK: query: explain +select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) as b from test_3 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_3 + Statistics: Num rows: 2 Data size: 184 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: id (type: string), lineid (type: int), (struct(id,lineid)) IN (const struct('two',3), const struct('three',1), const struct('one',1), const struct('five',2), const struct('six',1), const struct('eight',1), const struct('seven',1), const struct('nine',1), const struct('ten',1)) (type: boolean) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 2 Data size: 184 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 2 Data size: 184 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) as b from test_3 +PREHOOK: type: QUERY +PREHOOK: Input: default@test_3 +#### A masked pattern was here #### +POSTHOOK: query: select `id`, `lineid`, struct(`id`, `lineid`) +IN ( +struct('two',3), +struct('three',1), +struct('one',1), +struct('five',2), +struct('six',1), +struct('eight',1), +struct('seven',1), +struct('nine',1), +struct('ten',1) +) as b from test_3 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_3 +#### A masked pattern was here #### +one 1 true +seven 1 true +PREHOOK: query: -- 1 Integer and 1 String and 1 Double +create table test_4 (`my_bigint` bigint, `my_string` string, `my_double` double) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_4 +POSTHOOK: query: -- 1 Integer and 1 String and 1 Double +create table test_4 (`my_bigint` bigint, `my_string` string, `my_double` double) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_4 +PREHOOK: query: insert into table test_4 values (1, "b", 1.5), (1, "a", 0.5), (2, "b", 1.5) +PREHOOK: type: QUERY +PREHOOK: Input: default@values__tmp__table__4 +PREHOOK: Output: default@test_4 +POSTHOOK: query: insert into table test_4 values (1, "b", 1.5), (1, "a", 0.5), (2, "b", 1.5) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@values__tmp__table__4 +POSTHOOK: Output: default@test_4 +POSTHOOK: Lineage: test_4.my_bigint EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: test_4.my_double EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: test_4.my_string SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +PREHOOK: query: explain +select * from test_4 where struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) +PREHOOK: type: QUERY +POSTHOOK: query: explain +select * from test_4 where struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_4 + Statistics: Num rows: 3 Data size: 303 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (struct(my_bigint,my_string,my_double)) IN (const struct(1,'a',1.5), const struct(1,'b',-0.5), const struct(3,'b',1.5), const struct(1,'d',1.5), const struct(1,'c',1.5), const struct(1,'b',2.5), const struct(1,'b',0.5), const struct(5,'b',1.5), const struct(1,'a',0.5), const struct(3,'b',1.5)) (type: boolean) + Statistics: Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: my_bigint (type: bigint), my_string (type: string), my_double (type: double) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from test_4 where struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) +PREHOOK: type: QUERY +PREHOOK: Input: default@test_4 +#### A masked pattern was here #### +POSTHOOK: query: select * from test_4 where struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_4 +#### A masked pattern was here #### +1 a 0.5 +PREHOOK: query: explain +select `my_bigint`, `my_string`, `my_double`, struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) as b from test_4 +PREHOOK: type: QUERY +POSTHOOK: query: explain +select `my_bigint`, `my_string`, `my_double`, struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) as b from test_4 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: test_4 + Statistics: Num rows: 3 Data size: 303 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: my_bigint (type: bigint), my_string (type: string), my_double (type: double), (struct(my_bigint,my_string,my_double)) IN (const struct(1,'a',1.5), const struct(1,'b',-0.5), const struct(3,'b',1.5), const struct(1,'d',1.5), const struct(1,'c',1.5), const struct(1,'b',2.5), const struct(1,'b',0.5), const struct(5,'b',1.5), const struct(1,'a',0.5), const struct(3,'b',1.5)) (type: boolean) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 3 Data size: 303 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 3 Data size: 303 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select `my_bigint`, `my_string`, `my_double`, struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) as b from test_4 +PREHOOK: type: QUERY +PREHOOK: Input: default@test_4 +#### A masked pattern was here #### +POSTHOOK: query: select `my_bigint`, `my_string`, `my_double`, struct(`my_bigint`, `my_string`, `my_double`) +IN ( +struct(1L, "a", 1.5), +struct(1L, "b", -0.5), +struct(3L, "b", 1.5), +struct(1L, "d", 1.5), +struct(1L, "c", 1.5), +struct(1L, "b", 2.5), +struct(1L, "b", 0.5), +struct(5L, "b", 1.5), +struct(1L, "a", 0.5), +struct(3L, "b", 1.5) +) as b from test_4 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_4 +#### A masked pattern was here #### +1 a 0.5 true +1 b 1.5 false +2 b 1.5 false
