hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject [1/3] hive git commit: HIVE-10323: Tez merge join operator does not honor hive.join.emit.interval (Vikram Dixit K via Gunther Hagleitner)
Date Fri, 24 Apr 2015 20:53:29 GMT
Repository: hive
Updated Branches:
  refs/heads/master 3a42c2061 -> 59578d039


http://git-wip-us.apache.org/repos/asf/hive/blob/59578d03/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..48cd2a1
--- /dev/null
+++ b/ql/src/test/results/clientpositive/tez/mergejoin.q.out
@@ -0,0 +1,2528 @@
+PREHOOK: query: explain
+select * from src a join src1 b on a.key = b.key
+PREHOOK: type: QUERY
+POSTHOOK: query: 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)
+        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)
+        Reducer 2 
+            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
+        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
+        Reducer 2 
+            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 
+            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
+            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
+2	val_2	2008-04-08	2	val_2	2008-04-08
+4	val_4	2008-04-08	4	val_4	2008-04-08
+8	val_8	2008-04-08	8	val_8	2008-04-08
+11	val_11	2008-04-08	11	val_11	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
+17	val_17	2008-04-08	17	val_17	2008-04-08
+19	val_19	2008-04-08	19	val_19	2008-04-08
+20	val_20	2008-04-08	20	val_20	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
+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
+28	val_28	2008-04-08	28	val_28	2008-04-08
+33	val_33	2008-04-08	33	val_33	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
+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
+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
+44	val_44	2008-04-08	44	val_44	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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+2	val_2	2008-04-08	2	val_2	2008-04-08
+4	val_4	2008-04-08	4	val_4	2008-04-08
+8	val_8	2008-04-08	8	val_8	2008-04-08
+11	val_11	2008-04-08	11	val_11	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
+17	val_17	2008-04-08	17	val_17	2008-04-08
+19	val_19	2008-04-08	19	val_19	2008-04-08
+20	val_20	2008-04-08	20	val_20	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
+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
+28	val_28	2008-04-08	28	val_28	2008-04-08
+33	val_33	2008-04-08	33	val_33	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
+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
+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
+44	val_44	2008-04-08	44	val_44	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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+        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
+        Reducer 2 
+            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 
+            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
+            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: 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
+        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
+        Reducer 2 
+            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 
+            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
+            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: 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
+        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
+        Reducer 2 
+            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 
+            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
+            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 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
+        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
+        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
+        Reducer 2 
+            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 
+            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 
+            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
+            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: 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
+        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
+        Reducer 2 
+            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 
+            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
+            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 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
+        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
+        Map 7 
+            Map Operator Tree:
+                TableScan
+                  alias: s2
+                  filterExpr: key is not null (type: boolean)
+                  Filter Operator
+                    predicate: key is not null (type: boolean)
+                    Select Operator
+                      expressions: key (type: int)
+                      outputColumnNames: _col0
+                      Reduce Output Operator
+                        key expressions: _col0 (type: int)
+                        sort order: +
+                        Map-reduce partition columns: _col0 (type: int)
+            Execution mode: vectorized
+        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: 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
+        Reducer 2 
+            Reduce Operator Tree:
+              Merge Join Operator
+                condition map:
+                     Inner Join 0 to 1
+                keys:
+                  0 key (type: int)
+                  1 key (type: int)
+                outputColumnNames: _col0
+                Reduce Output Operator
+                  key expressions: _col0 (type: int)
+                  sort order: +
+                  Map-reduce partition columns: _col0 (type: 

<TRUNCATED>

Mime
View raw message