You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2015/09/15 22:42:17 UTC
[11/51] [partial] hive git commit: HIVE-11776: LLAP: Generate golden
files for all MiniLlapCluster tests (Prasanth Jayachandran)
http://git-wip-us.apache.org/repos/asf/hive/blob/ace87818/ql/src/test/results/clientpositive/llap/mergejoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mergejoin.q.out b/ql/src/test/results/clientpositive/llap/mergejoin.q.out
new file mode 100644
index 0000000..e69f79d
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/mergejoin.q.out
@@ -0,0 +1,3150 @@
+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: 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
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Execution mode: llap
+ Map 3
+ 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
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Execution mode: llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (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: 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, llap
+ Map 4
+ 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, llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
+ 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
+ Execution mode: vectorized, uber
+ 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
+ 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
+
+ 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: 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, llap
+ Map 4
+ 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, llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
+ 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
+ Execution mode: vectorized, uber
+ 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
+ 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
+
+ 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: 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, llap
+ Map 4
+ 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, llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Right Outer Join0 to 1
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
+ 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
+ Execution mode: vectorized, uber
+ 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
+ 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
+
+ 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: 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, llap
+ Map 4
+ 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, llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Outer Join 0 to 1
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
+ 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
+ Execution mode: vectorized, uber
+ 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
+ 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
+
+ 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 5 (SIMPLE_EDGE)
+ Reducer 3 <- Map 6 (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: 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, llap
+ Map 5
+ 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, llap
+ Map 6
+ 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
+ Execution mode: llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
+ 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
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 _col1 (type: string)
+ 1 value (type: string)
+ 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
+ Execution mode: vectorized, uber
+ 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
+ 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
+
+ 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: 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, llap
+ Map 4
+ 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, llap
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Merge Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 value (type: string)
+ 1 value (type: string)
+ 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
+ Execution mode: vectorized, uber
+ 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
+ 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
+
+ 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 7 <- Union 3 (CONTAINS)
+ Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 6 (SIMPLE_EDGE), Union 3 (CONTAINS)
+ Reducer 4 <- Map 8 (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: s1
+ 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, llap
+ Map 6
+ 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, llap
+ Map 7
+ Map Operator Tree:
+ TableScan
+ alias: s2
+ 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
+ Select Operator
+ expressions: key (type: int)
+ outputColumnNames: _col0
+ Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: int)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: int)
+ Statistics: Num rows: 254 Data size: 23885 Basic stats: COMPLETE Column stats: NONE
+ Execution mode: vectorized, llap
+ Map 8
+ 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: ke
<TRUNCATED>