Repository: hive Updated Branches: refs/heads/master 77360d6cf -> b34b30039
HIVE-18311: Enable smb_mapjoin_8.q for cli driver (Janaki Lahorani, reviewed by Sahil Takiar) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/b34b3003 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/b34b3003 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/b34b3003 Branch: refs/heads/master Commit: b34b300399f3b684ec8b28b78de839b2116546c3 Parents: 77360d6 Author: Janaki Lahorani <jan...@cloudera.com> Authored: Thu Jan 4 10:34:35 2018 -0800 Committer: Sahil Takiar <stak...@cloudera.com> Committed: Thu Jan 4 10:34:54 2018 -0800 ---------------------------------------------------------------------- .../test/resources/testconfiguration.properties | 1 - .../results/clientpositive/smb_mapjoin_8.q.out | 464 +++++++++++++++++++ 2 files changed, 464 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/b34b3003/itests/src/test/resources/testconfiguration.properties ---------------------------------------------------------------------- diff --git a/itests/src/test/resources/testconfiguration.properties b/itests/src/test/resources/testconfiguration.properties index 9121ca8..98e390c 100644 --- a/itests/src/test/resources/testconfiguration.properties +++ b/itests/src/test/resources/testconfiguration.properties @@ -34,7 +34,6 @@ disabled.query.files=ql_rewrite_gbtoidx.q,\ orc_llap.q,\ ql_rewrite_gbtoidx_cbo_2.q,\ rcfile_merge1.q,\ - smb_mapjoin_8.q,\ stats_filemetadata.q,\ mm_exim.q http://git-wip-us.apache.org/repos/asf/hive/blob/b34b3003/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out new file mode 100644 index 0000000..20cfc0d --- /dev/null +++ b/ql/src/test/results/clientpositive/smb_mapjoin_8.q.out @@ -0,0 +1,464 @@ +PREHOOK: query: create table smb_bucket_input (key int, value string) stored as rcfile +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@smb_bucket_input +POSTHOOK: query: create table smb_bucket_input (key int, value string) stored as rcfile +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@smb_bucket_input +PREHOOK: query: load data local inpath '../../data/files/smb_bucket_input.rc' into table smb_bucket_input +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@smb_bucket_input +POSTHOOK: query: load data local inpath '../../data/files/smb_bucket_input.rc' into table smb_bucket_input +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@smb_bucket_input +PREHOOK: query: CREATE TABLE smb_bucket4_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: CREATE TABLE smb_bucket4_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@smb_bucket4_1 +PREHOOK: query: CREATE TABLE smb_bucket4_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: CREATE TABLE smb_bucket4_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@smb_bucket4_2 +PREHOOK: query: CREATE TABLE smb_bucket4_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@smb_bucket4_3 +POSTHOOK: query: CREATE TABLE smb_bucket4_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@smb_bucket4_3 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4 or key=2000 or key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4 or key=2000 or key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=484 or key=3000 or key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=484 or key=3000 or key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +2000 val_169 NULL NULL +4 val_356 NULL NULL +4000 val_125 NULL NULL +NULL NULL 3000 val_169 +NULL NULL 484 val_169 +NULL NULL 5000 val_125 +PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +2000 val_169 NULL NULL +4 val_356 NULL NULL +4000 val_125 NULL NULL +NULL NULL 3000 val_169 +NULL NULL 484 val_169 +NULL NULL 5000 val_125 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=2000 or key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=2000 or key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=3000 or key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=3000 or key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +2000 val_169 NULL NULL +4000 val_125 NULL NULL +NULL NULL 3000 val_169 +NULL NULL 5000 val_125 +PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +2000 val_169 NULL NULL +4000 val_125 NULL NULL +NULL NULL 3000 val_169 +NULL NULL 5000 val_125 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +4000 val_125 NULL NULL +NULL NULL 5000 val_125 +PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +4000 val_125 NULL NULL +NULL NULL 5000 val_125 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +1000 val_1000 1000 val_1000 +4000 val_125 NULL NULL +NULL NULL 5000 val_125 +PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +#### A masked pattern was here #### +1000 val_1000 1000 val_1000 +4000 val_125 NULL NULL +NULL NULL 5000 val_125 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=1000 or key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_3 +POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=1000 or key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_3 +POSTHOOK: Lineage: smb_bucket4_3.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_3.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +PREHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +POSTHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +1000 val_1000 1000 val_1000 1000 val_1000 +4000 val_125 NULL NULL NULL NULL +NULL NULL 5000 val_125 NULL NULL +NULL NULL NULL NULL 5000 val_125 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=1000 or key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_3 +POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=1000 or key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_3 +POSTHOOK: Lineage: smb_bucket4_3.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: smb_bucket4_3.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +PREHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +POSTHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +1000 val_1000 1000 val_1000 1000 val_1000 +4000 val_125 NULL NULL 4000 val_125 +NULL NULL 5000 val_125 NULL NULL +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_3 +POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_3 +POSTHOOK: Lineage: smb_bucket4_3.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_3.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +PREHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +POSTHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +4000 val_125 NULL NULL 4000 val_125 +NULL NULL 5000 val_125 NULL NULL +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=00000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=00000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_3 +POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_3 +POSTHOOK: Lineage: smb_bucket4_3.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_3.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +PREHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +POSTHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +NULL NULL 4000 val_125 NULL NULL +NULL NULL NULL NULL 5000 val_125 +PREHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_1 +POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_1 +POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=4000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_2 +POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=4000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_2 +POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=5000 +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_input +PREHOOK: Output: default@smb_bucket4_3 +POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=5000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_input +POSTHOOK: Output: default@smb_bucket4_3 +POSTHOOK: Lineage: smb_bucket4_3.key SIMPLE [] +POSTHOOK: Lineage: smb_bucket4_3.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1 +PREHOOK: Input: default@smb_bucket4_2 +PREHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key +full outer join smb_bucket4_3 c on a.key=c.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1 +POSTHOOK: Input: default@smb_bucket4_2 +POSTHOOK: Input: default@smb_bucket4_3 +#### A masked pattern was here #### +1000 val_1000 NULL NULL NULL NULL +NULL NULL 4000 val_125 NULL NULL +NULL NULL NULL NULL 5000 val_125