hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject [06/51] [partial] hive git commit: HIVE-14553: Remove tez golden files after HIVE-14502 (Prasanth Jayachandran reviewed by Siddharth Seth)
Date Wed, 24 Aug 2016 20:57:00 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/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
deleted file mode 100644
index 08639be..0000000
--- a/ql/src/test/results/clientpositive/tez/mergejoin.q.out
+++ /dev/null
@@ -1,4324 +0,0 @@
-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
-#### A masked pattern was here ####
-      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: 89000 Basic stats: COMPLETE Column stats: COMPLETE
-                  Filter Operator
-                    predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
-                    Select Operator
-                      expressions: key (type: string), value (type: string)
-                      outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
-                      Reduce Output Operator
-                        key expressions: _col0 (type: string)
-                        sort order: +
-                        Map-reduce partition columns: _col0 (type: string)
-                        Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
-                        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: 4375 Basic stats: COMPLETE Column stats: COMPLETE
-                  Filter Operator
-                    predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
-                    Select Operator
-                      expressions: key (type: string), value (type: string)
-                      outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
-                      Reduce Output Operator
-                        key expressions: _col0 (type: string)
-                        sort order: +
-                        Map-reduce partition columns: _col0 (type: string)
-                        Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
-                        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: 60 Data size: 21180 Basic stats: COMPLETE Column stats: COMPLETE
-                File Output Operator
-                  compressed: false
-                  Statistics: Num rows: 60 Data size: 21180 Basic stats: COMPLETE Column stats: COMPLETE
-                  table:
-                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  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
-#### A masked pattern was here ####
-      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: 24684 Basic stats: COMPLETE Column stats: NONE
-                  Filter Operator
-                    predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: key (type: int)
-                      outputColumnNames: _col0
-                      Statistics: Num rows: 242 Data size: 24684 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: 242 Data size: 24684 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: 51000 Basic stats: COMPLETE Column stats: NONE
-                  Filter Operator
-                    predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 500 Data size: 51000 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: key (type: int)
-                      outputColumnNames: _col0
-                      Statistics: Num rows: 500 Data size: 51000 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: 500 Data size: 51000 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 _col0 (type: int)
-                  1 _col0 (type: int)
-                Statistics: Num rows: 550 Data size: 56100 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
-            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.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select * 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
-#### A masked pattern was here ####
-      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: 24684 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: key (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 242 Data size: 24684 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: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: b
-                  Statistics: Num rows: 500 Data size: 51000 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: key (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 500 Data size: 51000 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: 500 Data size: 51000 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 _col0 (type: int)
-                  1 _col0 (type: int)
-                Statistics: Num rows: 550 Data size: 56100 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
-            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.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select count(*)
-from tab 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
-#### A masked pattern was here ####
-      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: 24684 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: key (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 242 Data size: 24684 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: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: b
-                  Statistics: Num rows: 500 Data size: 51000 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: key (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 500 Data size: 51000 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: 500 Data size: 51000 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 _col0 (type: int)
-                  1 _col0 (type: int)
-                Statistics: Num rows: 550 Data size: 56100 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
-            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.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select count (*)
-from tab 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
-#### A masked pattern was here ####
-      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: 24684 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: key (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 242 Data size: 24684 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: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: b
-                  Statistics: Num rows: 500 Data size: 51000 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: key (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 500 Data size: 51000 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: 500 Data size: 51000 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 _col0 (type: int)
-                  1 _col0 (type: int)
-                Statistics: Num rows: 550 Data size: 56100 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
-            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.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select count(*)
-from tab 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
-#### A masked pattern was here ####
-      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: 24684 Basic stats: COMPLETE Column stats: NONE
-                  Filter Operator
-                    predicate: (key is not null and value is not null) (type: boolean)
-                    Statistics: Num rows: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: key (type: int), value (type: string)
-                      outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 242 Data size: 24684 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: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-                        value expressions: _col1 (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: 51000 Basic stats: COMPLETE Column stats: NONE
-                  Filter Operator
-                    predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 500 Data size: 51000 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: key (type: int)
-                      outputColumnNames: _col0
-                      Statistics: Num rows: 500 Data size: 51000 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: 500 Data size: 51000 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: 2225 Basic stats: COMPLETE Column stats: COMPLETE
-                  Filter Operator
-                    predicate: value is not null (type: boolean)
-                    Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
-                    Select Operator
-                      expressions: value (type: string)
-                      outputColumnNames: _col0
-                      Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
-                      Reduce Output Operator
-                        key expressions: _col0 (type: string)
-                        sort order: +
-                        Map-reduce partition columns: _col0 (type: string)
-                        Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
-        Reducer 2 
-            Reduce Operator Tree:
-              Merge Join Operator
-                condition map:
-                     Inner Join 0 to 1
-                keys:
-                  0 _col0 (type: int)
-                  1 _col0 (type: int)
-                outputColumnNames: _col1
-                Statistics: Num rows: 550 Data size: 56100 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: 550 Data size: 56100 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 _col0 (type: string)
-                Statistics: Num rows: 605 Data size: 61710 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
-            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.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select count(*) from tab 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
-#### A masked pattern was here ####
-      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: 24684 Basic stats: COMPLETE Column stats: NONE
-                  Filter Operator
-                    predicate: value is not null (type: boolean)
-                    Statistics: Num rows: 242 Data size: 24684 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: value (type: string)
-                      outputColumnNames: _col1
-                      Statistics: Num rows: 242 Data size: 24684 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: 242 Data size: 24684 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: 51000 Basic stats: COMPLETE Column stats: NONE
-                  Filter Operator
-                    predicate: value is not null (type: boolean)
-                    Statistics: Num rows: 500 Data size: 51000 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: value (type: string)
-                      outputColumnNames: _col1
-                      Statistics: Num rows: 500 Data size: 51000 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: 500 Data size: 51000 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 _col1 (type: string)
-                  1 _col1 (type: string)
-                Statistics: Num rows: 550 Data size: 56100 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
-            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.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select count(*) from tab 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
-#### A masked pattern was here ####
-      Edges:
-        Map 7 <- Union 3 (CONTAINS)
-        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map

<TRUNCATED>

Mime
View raw message