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>
