Repository: hive Updated Branches: refs/heads/branch-1.0 5a9fddb23 -> db56e8e3d
http://git-wip-us.apache.org/repos/asf/hive/blob/db56e8e3/ql/src/test/results/clientpositive/tez/mergejoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/mergejoin.q.out b/ql/src/test/results/clientpositive/tez/mergejoin.q.out new file mode 100644 index 0000000..1f4f67c --- /dev/null +++ b/ql/src/test/results/clientpositive/tez/mergejoin.q.out @@ -0,0 +1,3184 @@ +PREHOOK: query: -- SORT_QUERY_RESULTS + +explain +select * from src a join src1 b on a.key = b.key +PREHOOK: type: QUERY +POSTHOOK: query: -- SORT_QUERY_RESULTS + +explain +select * from src a join src1 b on a.key = b.key +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + filterExpr: key is not null (type: boolean) + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: string) + sort order: + + Map-reduce partition columns: key (type: string) + Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + value expressions: value (type: string) + Map 3 + Map Operator Tree: + TableScan + alias: a + filterExpr: key is not null (type: boolean) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: string) + sort order: + + Map-reduce partition columns: key (type: string) + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + value expressions: value (type: string) + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 {KEY.reducesinkkey0} {VALUE._col0} + 1 {KEY.reducesinkkey0} {VALUE._col0} + outputColumnNames: _col0, _col1, _col5, _col6 + Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from src a join src1 b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### +POSTHOOK: query: select * from src a join src1 b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### +128 val_128 128 +128 val_128 128 +128 val_128 128 +146 val_146 146 val_146 +146 val_146 146 val_146 +150 val_150 150 val_150 +213 val_213 213 val_213 +213 val_213 213 val_213 +224 val_224 224 +224 val_224 224 +238 val_238 238 val_238 +238 val_238 238 val_238 +255 val_255 255 val_255 +255 val_255 255 val_255 +273 val_273 273 val_273 +273 val_273 273 val_273 +273 val_273 273 val_273 +278 val_278 278 val_278 +278 val_278 278 val_278 +311 val_311 311 val_311 +311 val_311 311 val_311 +311 val_311 311 val_311 +369 val_369 369 +369 val_369 369 +369 val_369 369 +401 val_401 401 val_401 +401 val_401 401 val_401 +401 val_401 401 val_401 +401 val_401 401 val_401 +401 val_401 401 val_401 +406 val_406 406 val_406 +406 val_406 406 val_406 +406 val_406 406 val_406 +406 val_406 406 val_406 +66 val_66 66 val_66 +98 val_98 98 val_98 +98 val_98 98 val_98 +PREHOOK: query: CREATE TABLE srcbucket_mapjoin(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 +POSTHOOK: query: CREATE TABLE srcbucket_mapjoin(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 +PREHOOK: query: CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS ORCFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tab_part +POSTHOOK: query: CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS ORCFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tab_part +PREHOOK: query: CREATE TABLE srcbucket_mapjoin_part (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 +POSTHOOK: query: CREATE TABLE srcbucket_mapjoin_part (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 +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin +POSTHOOK: Output: default@srcbucket_mapjoin@ds=2008-04-08 +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin@ds=2008-04-08 +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin@ds=2008-04-08 +PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin_part +POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin_part +POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08 +PREHOOK: query: insert overwrite table tab_part partition (ds='2008-04-08') +select key,value from srcbucket_mapjoin_part +PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part +PREHOOK: Input: default@srcbucket_mapjoin_part@ds=2008-04-08 +PREHOOK: Output: default@tab_part@ds=2008-04-08 +POSTHOOK: query: insert overwrite table tab_part partition (ds='2008-04-08') +select key,value from srcbucket_mapjoin_part +POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part +POSTHOOK: Input: default@srcbucket_mapjoin_part@ds=2008-04-08 +POSTHOOK: Output: default@tab_part@ds=2008-04-08 +POSTHOOK: Lineage: tab_part PARTITION(ds=2008-04-08).key SIMPLE [(srcbucket_mapjoin_part)srcbucket_mapjoin_part.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: tab_part PARTITION(ds=2008-04-08).value SIMPLE [(srcbucket_mapjoin_part)srcbucket_mapjoin_part.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS ORCFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tab +POSTHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS ORCFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tab +PREHOOK: query: insert overwrite table tab partition (ds='2008-04-08') +select key,value from srcbucket_mapjoin +PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin +PREHOOK: Input: default@srcbucket_mapjoin@ds=2008-04-08 +PREHOOK: Output: default@tab@ds=2008-04-08 +POSTHOOK: query: insert overwrite table tab partition (ds='2008-04-08') +select key,value from srcbucket_mapjoin +POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin +POSTHOOK: Input: default@srcbucket_mapjoin@ds=2008-04-08 +POSTHOOK: Output: default@tab@ds=2008-04-08 +POSTHOOK: Lineage: tab PARTITION(ds=2008-04-08).key SIMPLE [(srcbucket_mapjoin)srcbucket_mapjoin.FieldSchema(name:key, type:int, comment:null), ] +POSTHOOK: Lineage: tab PARTITION(ds=2008-04-08).value SIMPLE [(srcbucket_mapjoin)srcbucket_mapjoin.FieldSchema(name:value, type:string, comment:null), ] +PREHOOK: query: explain +select count(*) +from tab a join tab_part b on a.key = b.key +PREHOOK: type: QUERY +POSTHOOK: query: explain +select count(*) +from tab a join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) + Reducer 3 <- Reducer 2 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + filterExpr: key is not null (type: boolean) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 4 + Map Operator Tree: + TableScan + alias: a + filterExpr: key is not null (type: boolean) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 + 1 + Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Select Operator + Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) + Reducer 3 + Reduce Operator Tree: + Group By Operator + aggregations: count(VALUE._col0) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from tab a join tab_part b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select * from tab a join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +105 val_105 2008-04-08 105 val_105 2008-04-08 +11 val_11 2008-04-08 11 val_11 2008-04-08 +114 val_114 2008-04-08 114 val_114 2008-04-08 +116 val_116 2008-04-08 116 val_116 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +136 val_136 2008-04-08 136 val_136 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +143 val_143 2008-04-08 143 val_143 2008-04-08 +145 val_145 2008-04-08 145 val_145 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +150 val_150 2008-04-08 150 val_150 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +156 val_156 2008-04-08 156 val_156 2008-04-08 +158 val_158 2008-04-08 158 val_158 2008-04-08 +163 val_163 2008-04-08 163 val_163 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +17 val_17 2008-04-08 17 val_17 2008-04-08 +170 val_170 2008-04-08 170 val_170 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +178 val_178 2008-04-08 178 val_178 2008-04-08 +181 val_181 2008-04-08 181 val_181 2008-04-08 +183 val_183 2008-04-08 183 val_183 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +189 val_189 2008-04-08 189 val_189 2008-04-08 +19 val_19 2008-04-08 19 val_19 2008-04-08 +190 val_190 2008-04-08 190 val_190 2008-04-08 +192 val_192 2008-04-08 192 val_192 2008-04-08 +194 val_194 2008-04-08 194 val_194 2008-04-08 +196 val_196 2008-04-08 196 val_196 2008-04-08 +2 val_2 2008-04-08 2 val_2 2008-04-08 +20 val_20 2008-04-08 20 val_20 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +202 val_202 2008-04-08 202 val_202 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +222 val_222 2008-04-08 222 val_222 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +226 val_226 2008-04-08 226 val_226 2008-04-08 +228 val_228 2008-04-08 228 val_228 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +235 val_235 2008-04-08 235 val_235 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +244 val_244 2008-04-08 244 val_244 2008-04-08 +248 val_248 2008-04-08 248 val_248 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +257 val_257 2008-04-08 257 val_257 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +260 val_260 2008-04-08 260 val_260 2008-04-08 +262 val_262 2008-04-08 262 val_262 2008-04-08 +266 val_266 2008-04-08 266 val_266 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +275 val_275 2008-04-08 275 val_275 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +28 val_28 2008-04-08 28 val_28 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +284 val_284 2008-04-08 284 val_284 2008-04-08 +286 val_286 2008-04-08 286 val_286 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +291 val_291 2008-04-08 291 val_291 2008-04-08 +305 val_305 2008-04-08 305 val_305 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +310 val_310 2008-04-08 310 val_310 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +323 val_323 2008-04-08 323 val_323 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +33 val_33 2008-04-08 33 val_33 2008-04-08 +332 val_332 2008-04-08 332 val_332 2008-04-08 +336 val_336 2008-04-08 336 val_336 2008-04-08 +338 val_338 2008-04-08 338 val_338 2008-04-08 +341 val_341 2008-04-08 341 val_341 2008-04-08 +345 val_345 2008-04-08 345 val_345 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +356 val_356 2008-04-08 356 val_356 2008-04-08 +365 val_365 2008-04-08 365 val_365 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +374 val_374 2008-04-08 374 val_374 2008-04-08 +378 val_378 2008-04-08 378 val_378 2008-04-08 +389 val_389 2008-04-08 389 val_389 2008-04-08 +392 val_392 2008-04-08 392 val_392 2008-04-08 +394 val_394 2008-04-08 394 val_394 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +4 val_4 2008-04-08 4 val_4 2008-04-08 +400 val_400 2008-04-08 400 val_400 2008-04-08 +402 val_402 2008-04-08 402 val_402 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +411 val_411 2008-04-08 411 val_411 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +419 val_419 2008-04-08 419 val_419 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +435 val_435 2008-04-08 435 val_435 2008-04-08 +437 val_437 2008-04-08 437 val_437 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +44 val_44 2008-04-08 44 val_44 2008-04-08 +444 val_444 2008-04-08 444 val_444 2008-04-08 +446 val_446 2008-04-08 446 val_446 2008-04-08 +448 val_448 2008-04-08 448 val_448 2008-04-08 +453 val_453 2008-04-08 453 val_453 2008-04-08 +455 val_455 2008-04-08 455 val_455 2008-04-08 +457 val_457 2008-04-08 457 val_457 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +460 val_460 2008-04-08 460 val_460 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +475 val_475 2008-04-08 475 val_475 2008-04-08 +477 val_477 2008-04-08 477 val_477 2008-04-08 +479 val_479 2008-04-08 479 val_479 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +482 val_482 2008-04-08 482 val_482 2008-04-08 +484 val_484 2008-04-08 484 val_484 2008-04-08 +491 val_491 2008-04-08 491 val_491 2008-04-08 +493 val_493 2008-04-08 493 val_493 2008-04-08 +495 val_495 2008-04-08 495 val_495 2008-04-08 +497 val_497 2008-04-08 497 val_497 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +53 val_53 2008-04-08 53 val_53 2008-04-08 +57 val_57 2008-04-08 57 val_57 2008-04-08 +64 val_64 2008-04-08 64 val_64 2008-04-08 +66 val_66 2008-04-08 66 val_66 2008-04-08 +77 val_77 2008-04-08 77 val_77 2008-04-08 +8 val_8 2008-04-08 8 val_8 2008-04-08 +80 val_80 2008-04-08 80 val_80 2008-04-08 +82 val_82 2008-04-08 82 val_82 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +86 val_86 2008-04-08 86 val_86 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +PREHOOK: query: select * from tab a join tab_part b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select * from tab a join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +0 val_0 2008-04-08 0 val_0 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +103 val_103 2008-04-08 103 val_103 2008-04-08 +105 val_105 2008-04-08 105 val_105 2008-04-08 +11 val_11 2008-04-08 11 val_11 2008-04-08 +114 val_114 2008-04-08 114 val_114 2008-04-08 +116 val_116 2008-04-08 116 val_116 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +118 val_118 2008-04-08 118 val_118 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +125 val_125 2008-04-08 125 val_125 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +129 val_129 2008-04-08 129 val_129 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +134 val_134 2008-04-08 134 val_134 2008-04-08 +136 val_136 2008-04-08 136 val_136 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +138 val_138 2008-04-08 138 val_138 2008-04-08 +143 val_143 2008-04-08 143 val_143 2008-04-08 +145 val_145 2008-04-08 145 val_145 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +149 val_149 2008-04-08 149 val_149 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +15 val_15 2008-04-08 15 val_15 2008-04-08 +150 val_150 2008-04-08 150 val_150 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +152 val_152 2008-04-08 152 val_152 2008-04-08 +156 val_156 2008-04-08 156 val_156 2008-04-08 +158 val_158 2008-04-08 158 val_158 2008-04-08 +163 val_163 2008-04-08 163 val_163 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +165 val_165 2008-04-08 165 val_165 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +167 val_167 2008-04-08 167 val_167 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +169 val_169 2008-04-08 169 val_169 2008-04-08 +17 val_17 2008-04-08 17 val_17 2008-04-08 +170 val_170 2008-04-08 170 val_170 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +172 val_172 2008-04-08 172 val_172 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +174 val_174 2008-04-08 174 val_174 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +176 val_176 2008-04-08 176 val_176 2008-04-08 +178 val_178 2008-04-08 178 val_178 2008-04-08 +181 val_181 2008-04-08 181 val_181 2008-04-08 +183 val_183 2008-04-08 183 val_183 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +187 val_187 2008-04-08 187 val_187 2008-04-08 +189 val_189 2008-04-08 189 val_189 2008-04-08 +19 val_19 2008-04-08 19 val_19 2008-04-08 +190 val_190 2008-04-08 190 val_190 2008-04-08 +192 val_192 2008-04-08 192 val_192 2008-04-08 +194 val_194 2008-04-08 194 val_194 2008-04-08 +196 val_196 2008-04-08 196 val_196 2008-04-08 +2 val_2 2008-04-08 2 val_2 2008-04-08 +20 val_20 2008-04-08 20 val_20 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +200 val_200 2008-04-08 200 val_200 2008-04-08 +202 val_202 2008-04-08 202 val_202 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +208 val_208 2008-04-08 208 val_208 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +213 val_213 2008-04-08 213 val_213 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +217 val_217 2008-04-08 217 val_217 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +219 val_219 2008-04-08 219 val_219 2008-04-08 +222 val_222 2008-04-08 222 val_222 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +224 val_224 2008-04-08 224 val_224 2008-04-08 +226 val_226 2008-04-08 226 val_226 2008-04-08 +228 val_228 2008-04-08 228 val_228 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +233 val_233 2008-04-08 233 val_233 2008-04-08 +235 val_235 2008-04-08 235 val_235 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +237 val_237 2008-04-08 237 val_237 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +239 val_239 2008-04-08 239 val_239 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +24 val_24 2008-04-08 24 val_24 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +242 val_242 2008-04-08 242 val_242 2008-04-08 +244 val_244 2008-04-08 244 val_244 2008-04-08 +248 val_248 2008-04-08 248 val_248 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +255 val_255 2008-04-08 255 val_255 2008-04-08 +257 val_257 2008-04-08 257 val_257 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +26 val_26 2008-04-08 26 val_26 2008-04-08 +260 val_260 2008-04-08 260 val_260 2008-04-08 +262 val_262 2008-04-08 262 val_262 2008-04-08 +266 val_266 2008-04-08 266 val_266 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +273 val_273 2008-04-08 273 val_273 2008-04-08 +275 val_275 2008-04-08 275 val_275 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +277 val_277 2008-04-08 277 val_277 2008-04-08 +28 val_28 2008-04-08 28 val_28 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +280 val_280 2008-04-08 280 val_280 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +282 val_282 2008-04-08 282 val_282 2008-04-08 +284 val_284 2008-04-08 284 val_284 2008-04-08 +286 val_286 2008-04-08 286 val_286 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +288 val_288 2008-04-08 288 val_288 2008-04-08 +291 val_291 2008-04-08 291 val_291 2008-04-08 +305 val_305 2008-04-08 305 val_305 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +307 val_307 2008-04-08 307 val_307 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +309 val_309 2008-04-08 309 val_309 2008-04-08 +310 val_310 2008-04-08 310 val_310 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +316 val_316 2008-04-08 316 val_316 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +318 val_318 2008-04-08 318 val_318 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +321 val_321 2008-04-08 321 val_321 2008-04-08 +323 val_323 2008-04-08 323 val_323 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +325 val_325 2008-04-08 325 val_325 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +327 val_327 2008-04-08 327 val_327 2008-04-08 +33 val_33 2008-04-08 33 val_33 2008-04-08 +332 val_332 2008-04-08 332 val_332 2008-04-08 +336 val_336 2008-04-08 336 val_336 2008-04-08 +338 val_338 2008-04-08 338 val_338 2008-04-08 +341 val_341 2008-04-08 341 val_341 2008-04-08 +345 val_345 2008-04-08 345 val_345 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +35 val_35 2008-04-08 35 val_35 2008-04-08 +356 val_356 2008-04-08 356 val_356 2008-04-08 +365 val_365 2008-04-08 365 val_365 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +367 val_367 2008-04-08 367 val_367 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +369 val_369 2008-04-08 369 val_369 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +37 val_37 2008-04-08 37 val_37 2008-04-08 +374 val_374 2008-04-08 374 val_374 2008-04-08 +378 val_378 2008-04-08 378 val_378 2008-04-08 +389 val_389 2008-04-08 389 val_389 2008-04-08 +392 val_392 2008-04-08 392 val_392 2008-04-08 +394 val_394 2008-04-08 394 val_394 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +396 val_396 2008-04-08 396 val_396 2008-04-08 +4 val_4 2008-04-08 4 val_4 2008-04-08 +400 val_400 2008-04-08 400 val_400 2008-04-08 +402 val_402 2008-04-08 402 val_402 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +404 val_404 2008-04-08 404 val_404 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +406 val_406 2008-04-08 406 val_406 2008-04-08 +411 val_411 2008-04-08 411 val_411 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +413 val_413 2008-04-08 413 val_413 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +417 val_417 2008-04-08 417 val_417 2008-04-08 +419 val_419 2008-04-08 419 val_419 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +42 val_42 2008-04-08 42 val_42 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +424 val_424 2008-04-08 424 val_424 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +431 val_431 2008-04-08 431 val_431 2008-04-08 +435 val_435 2008-04-08 435 val_435 2008-04-08 +437 val_437 2008-04-08 437 val_437 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +439 val_439 2008-04-08 439 val_439 2008-04-08 +44 val_44 2008-04-08 44 val_44 2008-04-08 +444 val_444 2008-04-08 444 val_444 2008-04-08 +446 val_446 2008-04-08 446 val_446 2008-04-08 +448 val_448 2008-04-08 448 val_448 2008-04-08 +453 val_453 2008-04-08 453 val_453 2008-04-08 +455 val_455 2008-04-08 455 val_455 2008-04-08 +457 val_457 2008-04-08 457 val_457 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +459 val_459 2008-04-08 459 val_459 2008-04-08 +460 val_460 2008-04-08 460 val_460 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +462 val_462 2008-04-08 462 val_462 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +466 val_466 2008-04-08 466 val_466 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +468 val_468 2008-04-08 468 val_468 2008-04-08 +475 val_475 2008-04-08 475 val_475 2008-04-08 +477 val_477 2008-04-08 477 val_477 2008-04-08 +479 val_479 2008-04-08 479 val_479 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +480 val_480 2008-04-08 480 val_480 2008-04-08 +482 val_482 2008-04-08 482 val_482 2008-04-08 +484 val_484 2008-04-08 484 val_484 2008-04-08 +491 val_491 2008-04-08 491 val_491 2008-04-08 +493 val_493 2008-04-08 493 val_493 2008-04-08 +495 val_495 2008-04-08 495 val_495 2008-04-08 +497 val_497 2008-04-08 497 val_497 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +51 val_51 2008-04-08 51 val_51 2008-04-08 +53 val_53 2008-04-08 53 val_53 2008-04-08 +57 val_57 2008-04-08 57 val_57 2008-04-08 +64 val_64 2008-04-08 64 val_64 2008-04-08 +66 val_66 2008-04-08 66 val_66 2008-04-08 +77 val_77 2008-04-08 77 val_77 2008-04-08 +8 val_8 2008-04-08 8 val_8 2008-04-08 +80 val_80 2008-04-08 80 val_80 2008-04-08 +82 val_82 2008-04-08 82 val_82 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +84 val_84 2008-04-08 84 val_84 2008-04-08 +86 val_86 2008-04-08 86 val_86 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +95 val_95 2008-04-08 95 val_95 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +97 val_97 2008-04-08 97 val_97 2008-04-08 +PREHOOK: query: explain +select count(*) +from tab a left outer join tab_part b on a.key = b.key +PREHOOK: type: QUERY +POSTHOOK: query: explain +select count(*) +from tab a left outer join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) + Reducer 3 <- Reducer 2 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 4 + Map Operator Tree: + TableScan + alias: a + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Left Outer Join0 to 1 + condition expressions: + 0 + 1 + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Select Operator + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) + Reducer 3 + Reduce Operator Tree: + Group By Operator + aggregations: count(VALUE._col0) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select count(*) +from tab a left outer join tab_part b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select count(*) +from tab a left outer join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +480 +PREHOOK: query: explain +select count (*) +from tab a right outer join tab_part b on a.key = b.key +PREHOOK: type: QUERY +POSTHOOK: query: explain +select count (*) +from tab a right outer join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) + Reducer 3 <- Reducer 2 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 4 + Map Operator Tree: + TableScan + alias: a + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Right Outer Join0 to 1 + condition expressions: + 0 + 1 + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Select Operator + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) + Reducer 3 + Reduce Operator Tree: + Group By Operator + aggregations: count(VALUE._col0) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select count (*) +from tab a right outer join tab_part b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select count (*) +from tab a right outer join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +738 +PREHOOK: query: explain +select count(*) +from tab a full outer join tab_part b on a.key = b.key +PREHOOK: type: QUERY +POSTHOOK: query: explain +select count(*) +from tab a full outer join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) + Reducer 3 <- Reducer 2 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 4 + Map Operator Tree: + TableScan + alias: a + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Outer Join 0 to 1 + condition expressions: + 0 + 1 + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Select Operator + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) + Reducer 3 + Reduce Operator Tree: + Group By Operator + aggregations: count(VALUE._col0) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select count(*) +from tab a full outer join tab_part b on a.key = b.key +PREHOOK: type: QUERY +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select count(*) +from tab a full outer join tab_part b on a.key = b.key +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +738 +PREHOOK: query: explain select count(*) from tab a join tab_part b on a.key = b.key join src1 c on a.value = c.value +PREHOOK: type: QUERY +POSTHOOK: query: explain select count(*) from tab a join tab_part b on a.key = b.key join src1 c on a.value = c.value +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 6 (SIMPLE_EDGE) + Reducer 3 <- Map 5 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) + Reducer 4 <- Reducer 3 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + filterExpr: key is not null (type: boolean) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 5 + Map Operator Tree: + TableScan + alias: c + filterExpr: value is not null (type: boolean) + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: value is not null (type: boolean) + Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: value (type: string) + sort order: + + Map-reduce partition columns: value (type: string) + Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Map 6 + Map Operator Tree: + TableScan + alias: a + filterExpr: (key is not null and value is not null) (type: boolean) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (key is not null and value is not null) (type: boolean) + Statistics: Num rows: 61 Data size: 5734 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 61 Data size: 5734 Basic stats: COMPLETE Column stats: NONE + value expressions: value (type: string) + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 {VALUE._col0} + 1 + outputColumnNames: _col1 + Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col1 (type: string) + sort order: + + Map-reduce partition columns: _col1 (type: string) + Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Reducer 3 + Reduce Operator Tree: + Merge Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 + 1 + Statistics: Num rows: 302 Data size: 28435 Basic stats: COMPLETE Column stats: NONE + Select Operator + Statistics: Num rows: 302 Data size: 28435 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) + Reducer 4 + Reduce Operator Tree: + Group By Operator + aggregations: count(VALUE._col0) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select count(*) from tab a join tab_part b on a.key = b.key join src1 c on a.value = c.value +PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select count(*) from tab a join tab_part b on a.key = b.key join src1 c on a.value = c.value +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +40 +PREHOOK: query: explain select count(*) from tab a join tab_part b on a.value = b.value +PREHOOK: type: QUERY +POSTHOOK: query: explain select count(*) from tab a join tab_part b on a.value = b.value +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) + Reducer 3 <- Reducer 2 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: b + filterExpr: value is not null (type: boolean) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: value is not null (type: boolean) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: value (type: string) + sort order: + + Map-reduce partition columns: value (type: string) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 4 + Map Operator Tree: + TableScan + alias: a + filterExpr: value is not null (type: boolean) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: value is not null (type: boolean) + Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: value (type: string) + sort order: + + Map-reduce partition columns: value (type: string) + Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Merge Join Operator + condition map: + Inner Join 0 to 1 + condition expressions: + 0 + 1 + Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Select Operator + Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) + Reducer 3 + Reduce Operator Tree: + Group By Operator + aggregations: count(VALUE._col0) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select count(*) from tab a join tab_part b on a.value = b.value +PREHOOK: type: QUERY +PREHOOK: Input: default@tab +PREHOOK: Input: default@tab@ds=2008-04-08 +PREHOOK: Input: default@tab_part +PREHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select count(*) from tab a join tab_part b on a.value = b.value +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab +POSTHOOK: Input: default@tab@ds=2008-04-08 +POSTHOOK: Input: default@tab_part +POSTHOOK: Input: default@tab_part@ds=2008-04-08 +#### A masked pattern was here #### +480 +PREHOOK: query: explain +select count(*) from (select s1.key as key, s1.value as value from tab s1 join tab s3 on s1.key=s3.key +UNION ALL +select s2.key as key, s2.value as value from tab s2 +) a join tab_part b on (a.key = b.key) +PREHOOK: type: QUERY +POSTHOOK: query: explain +select count(*) from (select s1.key as key, s1.value as value from tab s1 join tab s3 on s1.key=s3.key +UNION ALL +select s2.key as key, s2.value as value from tab s2 +) a join tab_part b on (a.key = b.key) +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Map 8 <- Union 3 (CONTAINS) + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 7 (SIMPLE_EDGE), Union 3 (CONTAINS) + Reducer 4 <- Map 6 (SIMPLE_EDGE), Union 3 (SIMPLE_EDGE) + Reducer 5 <- Reducer 4 (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: 22748 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Map 6 + Map Operator Tree: + TableScan + alias: b + filterExpr: key is not null (type: boolean) + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: key (type: int) + sort order: + + Map-reduce partition columns: key (type: int) + <TRUNCATED>
