| PREHOOK: query: CREATE TABLE srcbucket_mapjoin_n7(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@srcbucket_mapjoin_n7 |
| POSTHOOK: query: CREATE TABLE srcbucket_mapjoin_n7(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@srcbucket_mapjoin_n7 |
| PREHOOK: query: CREATE TABLE tab_part_n5 (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@tab_part_n5 |
| POSTHOOK: query: CREATE TABLE tab_part_n5 (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@tab_part_n5 |
| PREHOOK: query: CREATE TABLE srcbucket_mapjoin_part_n8 (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@srcbucket_mapjoin_part_n8 |
| POSTHOOK: query: CREATE TABLE srcbucket_mapjoin_part_n8 (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@srcbucket_mapjoin_part_n8 |
| PREHOOK: query: load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_n7 partition(ds='2008-04-08') |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@srcbucket_mapjoin_n7 |
| POSTHOOK: query: load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_n7 partition(ds='2008-04-08') |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@srcbucket_mapjoin_n7 |
| POSTHOOK: Output: default@srcbucket_mapjoin_n7@ds=2008-04-08 |
| PREHOOK: query: load data local inpath '../../data/files/bmj1/000001_0' INTO TABLE srcbucket_mapjoin_n7 partition(ds='2008-04-08') |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@srcbucket_mapjoin_n7@ds=2008-04-08 |
| POSTHOOK: query: load data local inpath '../../data/files/bmj1/000001_0' INTO TABLE srcbucket_mapjoin_n7 partition(ds='2008-04-08') |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@srcbucket_mapjoin_n7@ds=2008-04-08 |
| PREHOOK: query: load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@srcbucket_mapjoin_part_n8 |
| POSTHOOK: query: load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@srcbucket_mapjoin_part_n8 |
| POSTHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| PREHOOK: query: load data local inpath '../../data/files/bmj/000001_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| POSTHOOK: query: load data local inpath '../../data/files/bmj/000001_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| PREHOOK: query: load data local inpath '../../data/files/bmj/000002_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| POSTHOOK: query: load data local inpath '../../data/files/bmj/000002_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| PREHOOK: query: load data local inpath '../../data/files/bmj/000003_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| POSTHOOK: query: load data local inpath '../../data/files/bmj/000003_0' INTO TABLE srcbucket_mapjoin_part_n8 partition(ds='2008-04-08') |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| PREHOOK: query: insert overwrite table tab_part_n5 partition (ds='2008-04-08') |
| select key,value from srcbucket_mapjoin_part_n8 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcbucket_mapjoin_part_n8 |
| PREHOOK: Input: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| PREHOOK: Output: default@tab_part_n5@ds=2008-04-08 |
| POSTHOOK: query: insert overwrite table tab_part_n5 partition (ds='2008-04-08') |
| select key,value from srcbucket_mapjoin_part_n8 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcbucket_mapjoin_part_n8 |
| POSTHOOK: Input: default@srcbucket_mapjoin_part_n8@ds=2008-04-08 |
| POSTHOOK: Output: default@tab_part_n5@ds=2008-04-08 |
| POSTHOOK: Lineage: tab_part_n5 PARTITION(ds=2008-04-08).key SIMPLE [(srcbucket_mapjoin_part_n8)srcbucket_mapjoin_part_n8.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: tab_part_n5 PARTITION(ds=2008-04-08).value SIMPLE [(srcbucket_mapjoin_part_n8)srcbucket_mapjoin_part_n8.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: CREATE TABLE tab_n4(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@tab_n4 |
| POSTHOOK: query: CREATE TABLE tab_n4(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@tab_n4 |
| PREHOOK: query: insert overwrite table tab_n4 partition (ds='2008-04-08') |
| select key,value from srcbucket_mapjoin_n7 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcbucket_mapjoin_n7 |
| PREHOOK: Input: default@srcbucket_mapjoin_n7@ds=2008-04-08 |
| PREHOOK: Output: default@tab_n4@ds=2008-04-08 |
| POSTHOOK: query: insert overwrite table tab_n4 partition (ds='2008-04-08') |
| select key,value from srcbucket_mapjoin_n7 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcbucket_mapjoin_n7 |
| POSTHOOK: Input: default@srcbucket_mapjoin_n7@ds=2008-04-08 |
| POSTHOOK: Output: default@tab_n4@ds=2008-04-08 |
| POSTHOOK: Lineage: tab_n4 PARTITION(ds=2008-04-08).key SIMPLE [(srcbucket_mapjoin_n7)srcbucket_mapjoin_n7.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: tab_n4 PARTITION(ds=2008-04-08).value SIMPLE [(srcbucket_mapjoin_n7)srcbucket_mapjoin_n7.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: CREATE TABLE empty_n0(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@empty_n0 |
| POSTHOOK: query: CREATE TABLE empty_n0(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@empty_n0 |
| PREHOOK: query: explain |
| select count(*) from tab_n4 s1 join empty_n0 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select count(*) from tab_n4 s1 join empty_n0 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s3 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Dummy Store |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| Statistics: Num rows: 266 Data size: 1064 Basic stats: PARTIAL Column stats: NONE |
| Group By Operator |
| aggregations: count() |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| value expressions: _col0 (type: bigint) |
| Execution mode: llap |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select count(*) from tab_n4 s1 join empty_n0 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from tab_n4 s1 join empty_n0 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| 0 |
| PREHOOK: query: explain |
| select * from tab_n4 s1 left outer join empty_n0 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select * from tab_n4 s1 left outer join empty_n0 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s3 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 268 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 268 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int), value (type: string), ds (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 1 Data size: 268 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| Statistics: Num rows: 242 Data size: 67518 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int), value (type: string), ds (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 242 Data size: 67518 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| Statistics: Num rows: 243 Data size: 68333 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 243 Data size: 68333 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| Execution mode: llap |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select * from tab_n4 s1 left outer join empty_n0 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from tab_n4 s1 left outer join empty_n0 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| 0 val_0 2008-04-08 NULL NULL NULL |
| 0 val_0 2008-04-08 NULL NULL NULL |
| 0 val_0 2008-04-08 NULL NULL NULL |
| 103 val_103 2008-04-08 NULL NULL NULL |
| 103 val_103 2008-04-08 NULL NULL NULL |
| 105 val_105 2008-04-08 NULL NULL NULL |
| 11 val_11 2008-04-08 NULL NULL NULL |
| 114 val_114 2008-04-08 NULL NULL NULL |
| 116 val_116 2008-04-08 NULL NULL NULL |
| 118 val_118 2008-04-08 NULL NULL NULL |
| 118 val_118 2008-04-08 NULL NULL NULL |
| 125 val_125 2008-04-08 NULL NULL NULL |
| 125 val_125 2008-04-08 NULL NULL NULL |
| 129 val_129 2008-04-08 NULL NULL NULL |
| 129 val_129 2008-04-08 NULL NULL NULL |
| 134 val_134 2008-04-08 NULL NULL NULL |
| 134 val_134 2008-04-08 NULL NULL NULL |
| 136 val_136 2008-04-08 NULL NULL NULL |
| 138 val_138 2008-04-08 NULL NULL NULL |
| 138 val_138 2008-04-08 NULL NULL NULL |
| 138 val_138 2008-04-08 NULL NULL NULL |
| 138 val_138 2008-04-08 NULL NULL NULL |
| 143 val_143 2008-04-08 NULL NULL NULL |
| 145 val_145 2008-04-08 NULL NULL NULL |
| 149 val_149 2008-04-08 NULL NULL NULL |
| 149 val_149 2008-04-08 NULL NULL NULL |
| 15 val_15 2008-04-08 NULL NULL NULL |
| 15 val_15 2008-04-08 NULL NULL NULL |
| 150 val_150 2008-04-08 NULL NULL NULL |
| 152 val_152 2008-04-08 NULL NULL NULL |
| 152 val_152 2008-04-08 NULL NULL NULL |
| 156 val_156 2008-04-08 NULL NULL NULL |
| 158 val_158 2008-04-08 NULL NULL NULL |
| 163 val_163 2008-04-08 NULL NULL NULL |
| 165 val_165 2008-04-08 NULL NULL NULL |
| 165 val_165 2008-04-08 NULL NULL NULL |
| 167 val_167 2008-04-08 NULL NULL NULL |
| 167 val_167 2008-04-08 NULL NULL NULL |
| 167 val_167 2008-04-08 NULL NULL NULL |
| 169 val_169 2008-04-08 NULL NULL NULL |
| 169 val_169 2008-04-08 NULL NULL NULL |
| 169 val_169 2008-04-08 NULL NULL NULL |
| 169 val_169 2008-04-08 NULL NULL NULL |
| 17 val_17 2008-04-08 NULL NULL NULL |
| 170 val_170 2008-04-08 NULL NULL NULL |
| 172 val_172 2008-04-08 NULL NULL NULL |
| 172 val_172 2008-04-08 NULL NULL NULL |
| 174 val_174 2008-04-08 NULL NULL NULL |
| 174 val_174 2008-04-08 NULL NULL NULL |
| 176 val_176 2008-04-08 NULL NULL NULL |
| 176 val_176 2008-04-08 NULL NULL NULL |
| 178 val_178 2008-04-08 NULL NULL NULL |
| 181 val_181 2008-04-08 NULL NULL NULL |
| 183 val_183 2008-04-08 NULL NULL NULL |
| 187 val_187 2008-04-08 NULL NULL NULL |
| 187 val_187 2008-04-08 NULL NULL NULL |
| 187 val_187 2008-04-08 NULL NULL NULL |
| 189 val_189 2008-04-08 NULL NULL NULL |
| 19 val_19 2008-04-08 NULL NULL NULL |
| 190 val_190 2008-04-08 NULL NULL NULL |
| 192 val_192 2008-04-08 NULL NULL NULL |
| 194 val_194 2008-04-08 NULL NULL NULL |
| 196 val_196 2008-04-08 NULL NULL NULL |
| 2 val_2 2008-04-08 NULL NULL NULL |
| 20 val_20 2008-04-08 NULL NULL NULL |
| 200 val_200 2008-04-08 NULL NULL NULL |
| 200 val_200 2008-04-08 NULL NULL NULL |
| 202 val_202 2008-04-08 NULL NULL NULL |
| 208 val_208 2008-04-08 NULL NULL NULL |
| 208 val_208 2008-04-08 NULL NULL NULL |
| 208 val_208 2008-04-08 NULL NULL NULL |
| 213 val_213 2008-04-08 NULL NULL NULL |
| 213 val_213 2008-04-08 NULL NULL NULL |
| 217 val_217 2008-04-08 NULL NULL NULL |
| 217 val_217 2008-04-08 NULL NULL NULL |
| 219 val_219 2008-04-08 NULL NULL NULL |
| 219 val_219 2008-04-08 NULL NULL NULL |
| 222 val_222 2008-04-08 NULL NULL NULL |
| 224 val_224 2008-04-08 NULL NULL NULL |
| 224 val_224 2008-04-08 NULL NULL NULL |
| 226 val_226 2008-04-08 NULL NULL NULL |
| 228 val_228 2008-04-08 NULL NULL NULL |
| 233 val_233 2008-04-08 NULL NULL NULL |
| 233 val_233 2008-04-08 NULL NULL NULL |
| 235 val_235 2008-04-08 NULL NULL NULL |
| 237 val_237 2008-04-08 NULL NULL NULL |
| 237 val_237 2008-04-08 NULL NULL NULL |
| 239 val_239 2008-04-08 NULL NULL NULL |
| 239 val_239 2008-04-08 NULL NULL NULL |
| 24 val_24 2008-04-08 NULL NULL NULL |
| 24 val_24 2008-04-08 NULL NULL NULL |
| 242 val_242 2008-04-08 NULL NULL NULL |
| 242 val_242 2008-04-08 NULL NULL NULL |
| 244 val_244 2008-04-08 NULL NULL NULL |
| 248 val_248 2008-04-08 NULL NULL NULL |
| 255 val_255 2008-04-08 NULL NULL NULL |
| 255 val_255 2008-04-08 NULL NULL NULL |
| 257 val_257 2008-04-08 NULL NULL NULL |
| 26 val_26 2008-04-08 NULL NULL NULL |
| 26 val_26 2008-04-08 NULL NULL NULL |
| 260 val_260 2008-04-08 NULL NULL NULL |
| 262 val_262 2008-04-08 NULL NULL NULL |
| 266 val_266 2008-04-08 NULL NULL NULL |
| 273 val_273 2008-04-08 NULL NULL NULL |
| 273 val_273 2008-04-08 NULL NULL NULL |
| 273 val_273 2008-04-08 NULL NULL NULL |
| 275 val_275 2008-04-08 NULL NULL NULL |
| 277 val_277 2008-04-08 NULL NULL NULL |
| 277 val_277 2008-04-08 NULL NULL NULL |
| 277 val_277 2008-04-08 NULL NULL NULL |
| 277 val_277 2008-04-08 NULL NULL NULL |
| 28 val_28 2008-04-08 NULL NULL NULL |
| 280 val_280 2008-04-08 NULL NULL NULL |
| 280 val_280 2008-04-08 NULL NULL NULL |
| 282 val_282 2008-04-08 NULL NULL NULL |
| 282 val_282 2008-04-08 NULL NULL NULL |
| 284 val_284 2008-04-08 NULL NULL NULL |
| 286 val_286 2008-04-08 NULL NULL NULL |
| 288 val_288 2008-04-08 NULL NULL NULL |
| 288 val_288 2008-04-08 NULL NULL NULL |
| 291 val_291 2008-04-08 NULL NULL NULL |
| 305 val_305 2008-04-08 NULL NULL NULL |
| 307 val_307 2008-04-08 NULL NULL NULL |
| 307 val_307 2008-04-08 NULL NULL NULL |
| 309 val_309 2008-04-08 NULL NULL NULL |
| 309 val_309 2008-04-08 NULL NULL NULL |
| 310 val_310 2008-04-08 NULL NULL NULL |
| 316 val_316 2008-04-08 NULL NULL NULL |
| 316 val_316 2008-04-08 NULL NULL NULL |
| 316 val_316 2008-04-08 NULL NULL NULL |
| 318 val_318 2008-04-08 NULL NULL NULL |
| 318 val_318 2008-04-08 NULL NULL NULL |
| 318 val_318 2008-04-08 NULL NULL NULL |
| 321 val_321 2008-04-08 NULL NULL NULL |
| 321 val_321 2008-04-08 NULL NULL NULL |
| 323 val_323 2008-04-08 NULL NULL NULL |
| 325 val_325 2008-04-08 NULL NULL NULL |
| 325 val_325 2008-04-08 NULL NULL NULL |
| 327 val_327 2008-04-08 NULL NULL NULL |
| 327 val_327 2008-04-08 NULL NULL NULL |
| 327 val_327 2008-04-08 NULL NULL NULL |
| 33 val_33 2008-04-08 NULL NULL NULL |
| 332 val_332 2008-04-08 NULL NULL NULL |
| 336 val_336 2008-04-08 NULL NULL NULL |
| 338 val_338 2008-04-08 NULL NULL NULL |
| 341 val_341 2008-04-08 NULL NULL NULL |
| 345 val_345 2008-04-08 NULL NULL NULL |
| 35 val_35 2008-04-08 NULL NULL NULL |
| 35 val_35 2008-04-08 NULL NULL NULL |
| 35 val_35 2008-04-08 NULL NULL NULL |
| 356 val_356 2008-04-08 NULL NULL NULL |
| 365 val_365 2008-04-08 NULL NULL NULL |
| 367 val_367 2008-04-08 NULL NULL NULL |
| 367 val_367 2008-04-08 NULL NULL NULL |
| 369 val_369 2008-04-08 NULL NULL NULL |
| 369 val_369 2008-04-08 NULL NULL NULL |
| 369 val_369 2008-04-08 NULL NULL NULL |
| 37 val_37 2008-04-08 NULL NULL NULL |
| 37 val_37 2008-04-08 NULL NULL NULL |
| 374 val_374 2008-04-08 NULL NULL NULL |
| 378 val_378 2008-04-08 NULL NULL NULL |
| 389 val_389 2008-04-08 NULL NULL NULL |
| 392 val_392 2008-04-08 NULL NULL NULL |
| 394 val_394 2008-04-08 NULL NULL NULL |
| 396 val_396 2008-04-08 NULL NULL NULL |
| 396 val_396 2008-04-08 NULL NULL NULL |
| 396 val_396 2008-04-08 NULL NULL NULL |
| 4 val_4 2008-04-08 NULL NULL NULL |
| 400 val_400 2008-04-08 NULL NULL NULL |
| 402 val_402 2008-04-08 NULL NULL NULL |
| 404 val_404 2008-04-08 NULL NULL NULL |
| 404 val_404 2008-04-08 NULL NULL NULL |
| 406 val_406 2008-04-08 NULL NULL NULL |
| 406 val_406 2008-04-08 NULL NULL NULL |
| 406 val_406 2008-04-08 NULL NULL NULL |
| 406 val_406 2008-04-08 NULL NULL NULL |
| 411 val_411 2008-04-08 NULL NULL NULL |
| 413 val_413 2008-04-08 NULL NULL NULL |
| 413 val_413 2008-04-08 NULL NULL NULL |
| 417 val_417 2008-04-08 NULL NULL NULL |
| 417 val_417 2008-04-08 NULL NULL NULL |
| 417 val_417 2008-04-08 NULL NULL NULL |
| 419 val_419 2008-04-08 NULL NULL NULL |
| 42 val_42 2008-04-08 NULL NULL NULL |
| 42 val_42 2008-04-08 NULL NULL NULL |
| 424 val_424 2008-04-08 NULL NULL NULL |
| 424 val_424 2008-04-08 NULL NULL NULL |
| 431 val_431 2008-04-08 NULL NULL NULL |
| 431 val_431 2008-04-08 NULL NULL NULL |
| 431 val_431 2008-04-08 NULL NULL NULL |
| 435 val_435 2008-04-08 NULL NULL NULL |
| 437 val_437 2008-04-08 NULL NULL NULL |
| 439 val_439 2008-04-08 NULL NULL NULL |
| 439 val_439 2008-04-08 NULL NULL NULL |
| 44 val_44 2008-04-08 NULL NULL NULL |
| 444 val_444 2008-04-08 NULL NULL NULL |
| 446 val_446 2008-04-08 NULL NULL NULL |
| 448 val_448 2008-04-08 NULL NULL NULL |
| 453 val_453 2008-04-08 NULL NULL NULL |
| 455 val_455 2008-04-08 NULL NULL NULL |
| 457 val_457 2008-04-08 NULL NULL NULL |
| 459 val_459 2008-04-08 NULL NULL NULL |
| 459 val_459 2008-04-08 NULL NULL NULL |
| 460 val_460 2008-04-08 NULL NULL NULL |
| 462 val_462 2008-04-08 NULL NULL NULL |
| 462 val_462 2008-04-08 NULL NULL NULL |
| 466 val_466 2008-04-08 NULL NULL NULL |
| 466 val_466 2008-04-08 NULL NULL NULL |
| 466 val_466 2008-04-08 NULL NULL NULL |
| 468 val_468 2008-04-08 NULL NULL NULL |
| 468 val_468 2008-04-08 NULL NULL NULL |
| 468 val_468 2008-04-08 NULL NULL NULL |
| 468 val_468 2008-04-08 NULL NULL NULL |
| 475 val_475 2008-04-08 NULL NULL NULL |
| 477 val_477 2008-04-08 NULL NULL NULL |
| 479 val_479 2008-04-08 NULL NULL NULL |
| 480 val_480 2008-04-08 NULL NULL NULL |
| 480 val_480 2008-04-08 NULL NULL NULL |
| 480 val_480 2008-04-08 NULL NULL NULL |
| 482 val_482 2008-04-08 NULL NULL NULL |
| 484 val_484 2008-04-08 NULL NULL NULL |
| 491 val_491 2008-04-08 NULL NULL NULL |
| 493 val_493 2008-04-08 NULL NULL NULL |
| 495 val_495 2008-04-08 NULL NULL NULL |
| 497 val_497 2008-04-08 NULL NULL NULL |
| 51 val_51 2008-04-08 NULL NULL NULL |
| 51 val_51 2008-04-08 NULL NULL NULL |
| 53 val_53 2008-04-08 NULL NULL NULL |
| 57 val_57 2008-04-08 NULL NULL NULL |
| 64 val_64 2008-04-08 NULL NULL NULL |
| 66 val_66 2008-04-08 NULL NULL NULL |
| 77 val_77 2008-04-08 NULL NULL NULL |
| 8 val_8 2008-04-08 NULL NULL NULL |
| 80 val_80 2008-04-08 NULL NULL NULL |
| 82 val_82 2008-04-08 NULL NULL NULL |
| 84 val_84 2008-04-08 NULL NULL NULL |
| 84 val_84 2008-04-08 NULL NULL NULL |
| 86 val_86 2008-04-08 NULL NULL NULL |
| 95 val_95 2008-04-08 NULL NULL NULL |
| 95 val_95 2008-04-08 NULL NULL NULL |
| 97 val_97 2008-04-08 NULL NULL NULL |
| 97 val_97 2008-04-08 NULL NULL NULL |
| PREHOOK: query: explain |
| select count(*) from tab_n4 s1 left outer join tab_n4 s2 on s1.key=s2.key join empty_n0 s3 on s1.key = s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select count(*) from tab_n4 s1 left outer join tab_n4 s2 on s1.key=s2.key join empty_n0 s3 on s1.key = s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s2 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 382 Data size: 1528 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 382 Data size: 1528 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: llap |
| Map 5 |
| Map Operator Tree: |
| TableScan |
| alias: s3 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: unknown |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| Statistics: Num rows: 420 Data size: 1680 Basic stats: PARTIAL Column stats: NONE |
| Group By Operator |
| aggregations: count() |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| value expressions: _col0 (type: bigint) |
| Reducer 3 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select count(*) from tab_n4 s1 left outer join tab_n4 s2 on s1.key=s2.key join empty_n0 s3 on s1.key = s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from tab_n4 s1 left outer join tab_n4 s2 on s1.key=s2.key join empty_n0 s3 on s1.key = s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| 0 |
| PREHOOK: query: explain |
| select count(*) from tab_n4 s1 left outer join empty_n0 s2 on s1.key=s2.key join tab_n4 s3 on s1.key = s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select count(*) from tab_n4 s1 left outer join empty_n0 s2 on s1.key=s2.key join tab_n4 s3 on s1.key = s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s2 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Dummy Store |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 266 Data size: 1064 Basic stats: PARTIAL Column stats: NONE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 266 Data size: 1064 Basic stats: PARTIAL Column stats: NONE |
| Execution mode: llap |
| Map 5 |
| Map Operator Tree: |
| TableScan |
| alias: s3 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| Statistics: Num rows: 292 Data size: 1170 Basic stats: PARTIAL Column stats: NONE |
| Group By Operator |
| aggregations: count() |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| value expressions: _col0 (type: bigint) |
| Reducer 3 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select count(*) from tab_n4 s1 left outer join empty_n0 s2 on s1.key=s2.key join tab_n4 s3 on s1.key = s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from tab_n4 s1 left outer join empty_n0 s2 on s1.key=s2.key join tab_n4 s3 on s1.key = s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| 480 |
| PREHOOK: query: explain |
| select count(*) from empty_n0 s1 join empty_n0 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select count(*) from empty_n0 s1 join empty_n0 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s3 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Dummy Store |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
| Group By Operator |
| aggregations: count() |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| value expressions: _col0 (type: bigint) |
| Execution mode: llap |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select count(*) from empty_n0 s1 join empty_n0 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from empty_n0 s1 join empty_n0 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| #### A masked pattern was here #### |
| 0 |
| PREHOOK: query: explain |
| select count(*) from empty_n0 s1 join tab_n4 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select count(*) from empty_n0 s1 join tab_n4 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s3 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| filterExpr: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Filter Operator |
| predicate: key is not null (type: boolean) |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| Statistics: Num rows: 266 Data size: 1064 Basic stats: PARTIAL Column stats: NONE |
| Group By Operator |
| aggregations: count() |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| value expressions: _col0 (type: bigint) |
| Execution mode: llap |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select count(*) from empty_n0 s1 join tab_n4 s3 on s1.key=s3.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@empty_n0 |
| PREHOOK: Input: default@tab_n4 |
| PREHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from empty_n0 s1 join tab_n4 s3 on s1.key=s3.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@empty_n0 |
| POSTHOOK: Input: default@tab_n4 |
| POSTHOOK: Input: default@tab_n4@ds=2008-04-08 |
| #### A masked pattern was here #### |
| 0 |