| 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_n1(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_n1 |
| POSTHOOK: query: CREATE TABLE smb_bucket4_1_n1(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_n1 |
| PREHOOK: query: CREATE TABLE smb_bucket4_2_n1(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_n1 |
| POSTHOOK: query: CREATE TABLE smb_bucket4_2_n1(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_n1 |
| 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_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### 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_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### 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_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### 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_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### 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_n1 select * from smb_bucket_input where key=4000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 select * from smb_bucket_input where key=4000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=5000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=5000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| 4000 val_125 NULL NULL |
| NULL NULL 5000 val_125 |
| PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| 4000 val_125 NULL NULL |
| NULL NULL 5000 val_125 |
| PREHOOK: query: insert overwrite table smb_bucket4_1_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### 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_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket4_1_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 b on a.key = b.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket4_1_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| #### 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_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.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_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| PREHOOK: Input: default@smb_bucket4_3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| 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_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.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_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| PREHOOK: Input: default@smb_bucket4_3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| 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_n1 select * from smb_bucket_input where key=4000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 select * from smb_bucket_input where key=4000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=5000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=5000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.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_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| PREHOOK: Input: default@smb_bucket4_3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| 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_n1 select * from smb_bucket_input where key=00000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 select * from smb_bucket_input where key=00000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=4000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=4000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.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_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| PREHOOK: Input: default@smb_bucket4_3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| 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_n1 select * from smb_bucket_input where key=1000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_1_n1 select * from smb_bucket_input where key=1000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_1_n1 |
| POSTHOOK: Lineage: smb_bucket4_1_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_1_n1.value SIMPLE [(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=4000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@smb_bucket_input |
| PREHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: query: insert overwrite table smb_bucket4_2_n1 select * from smb_bucket_input where key=4000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@smb_bucket_input |
| POSTHOOK: Output: default@smb_bucket4_2_n1 |
| POSTHOOK: Lineage: smb_bucket4_2_n1.key SIMPLE [] |
| POSTHOOK: Lineage: smb_bucket4_2_n1.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_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| PREHOOK: Input: default@smb_bucket4_2_n1 |
| PREHOOK: Input: default@smb_bucket4_3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n1 a full outer join smb_bucket4_2_n1 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_n1 |
| POSTHOOK: Input: default@smb_bucket4_2_n1 |
| 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 |