http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/llap/mergejoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mergejoin.q.out b/ql/src/test/results/clientpositive/llap/mergejoin.q.out index e69f79d..77bb875 100644 --- a/ql/src/test/results/clientpositive/llap/mergejoin.q.out +++ b/ql/src/test/results/clientpositive/llap/mergejoin.q.out @@ -27,16 +27,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string) Execution mode: llap Map 3 @@ -47,16 +47,16 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string) Execution mode: llap Reducer 2 @@ -69,10 +69,10 @@ STAGE PLANS: 0 _col0 (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -269,12 +269,16 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 4 Map Operator Tree: @@ -284,12 +288,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -298,9 +306,9 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 key (type: int) - 1 key (type: int) - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + 0 _col0 (type: int) + 1 _col0 (type: int) + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -1345,22 +1353,31 @@ STAGE PLANS: TableScan alias: a Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 4 Map Operator Tree: TableScan alias: b + filterExpr: (key) IN (RS[4]) (type: boolean) Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -1369,8 +1386,8 @@ STAGE PLANS: condition map: Left Outer Join0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() @@ -1444,23 +1461,32 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a + filterExpr: (key) IN (RS[5]) (type: boolean) Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 4 Map Operator Tree: TableScan alias: b Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -1469,8 +1495,8 @@ STAGE PLANS: condition map: Right Outer Join0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() @@ -1545,22 +1571,30 @@ STAGE PLANS: TableScan alias: a Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 4 Map Operator Tree: TableScan alias: b Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -1569,8 +1603,8 @@ STAGE PLANS: condition map: Outer Join 0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() @@ -1645,13 +1679,17 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) - Statistics: Num rows: 61 Data size: 5734 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 61 Data size: 5734 Basic stats: COMPLETE Column stats: NONE - value expressions: value (type: string) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: string) Execution mode: vectorized, llap Map 5 Map Operator Tree: @@ -1661,12 +1699,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 6 Map Operator Tree: @@ -1676,12 +1718,16 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: value (type: string) - sort order: + - Map-reduce partition columns: value (type: string) - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string) + outputColumnNames: _col0 + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: string) + sort order: + + Map-reduce partition columns: _col0 (type: string) + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Execution mode: llap Reducer 2 Execution mode: llap @@ -1690,15 +1736,15 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) outputColumnNames: _col1 - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col1 (type: string) sort order: + Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Reducer 3 Execution mode: llap Reduce Operator Tree: @@ -1707,8 +1753,8 @@ STAGE PLANS: Inner Join 0 to 1 keys: 0 _col1 (type: string) - 1 value (type: string) - Statistics: Num rows: 302 Data size: 28435 Basic stats: COMPLETE Column stats: NONE + 1 _col0 (type: string) + Statistics: Num rows: 605 Data size: 56870 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -1781,12 +1827,16 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: value (type: string) - sort order: + - Map-reduce partition columns: value (type: string) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string) + outputColumnNames: _col1 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 4 Map Operator Tree: @@ -1796,12 +1846,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: value (type: string) - sort order: + - Map-reduce partition columns: value (type: string) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string) + outputColumnNames: _col1 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -1810,9 +1864,9 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 value (type: string) - 1 value (type: string) - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + 0 _col1 (type: string) + 1 _col1 (type: string) + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -1893,46 +1947,54 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 6 Map Operator Tree: TableScan - alias: s3 + alias: s1 filterExpr: key is not null (type: boolean) Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 7 Map Operator Tree: TableScan - alias: s2 + alias: s1 filterExpr: key is not null (type: boolean) Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 254 Data size: 23885 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 508 Data size: 47770 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 8 Map Operator Tree: @@ -1942,12 +2004,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -1956,15 +2022,15 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 133 Data size: 12511 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 266 Data size: 25022 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 254 Data size: 23885 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 508 Data size: 47770 Basic stats: COMPLETE Column stats: NONE Reducer 4 Execution mode: llap Reduce Operator Tree: @@ -1973,8 +2039,8 @@ STAGE PLANS: Inner Join 0 to 1 keys: 0 _col0 (type: int) - 1 key (type: int) - Statistics: Num rows: 279 Data size: 26273 Basic stats: COMPLETE Column stats: NONE + 1 _col0 (type: int) + Statistics: Num rows: 558 Data size: 52547 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -2032,12 +2098,16 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: value (type: string) - sort order: + - Map-reduce partition columns: value (type: string) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string) + outputColumnNames: _col1 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 4 Map Operator Tree: @@ -2047,12 +2117,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: value (type: string) - sort order: + - Map-reduce partition columns: value (type: string) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string) + outputColumnNames: _col1 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -2061,9 +2135,9 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 value (type: string) - 1 value (type: string) - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + 0 _col1 (type: string) + 1 _col1 (type: string) + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -2135,13 +2209,17 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) - Statistics: Num rows: 61 Data size: 5734 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 61 Data size: 5734 Basic stats: COMPLETE Column stats: NONE - value expressions: value (type: string) + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: string) Execution mode: vectorized, llap Map 5 Map Operator Tree: @@ -2151,12 +2229,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 6 Map Operator Tree: @@ -2166,12 +2248,16 @@ STAGE PLANS: Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: value (type: string) - sort order: + - Map-reduce partition columns: value (type: string) - Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string) + outputColumnNames: _col0 + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: string) + sort order: + + Map-reduce partition columns: _col0 (type: string) + Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Execution mode: llap Reducer 2 Execution mode: llap @@ -2180,15 +2266,15 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) outputColumnNames: _col1 - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col1 (type: string) sort order: + Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE Reducer 3 Execution mode: llap Reduce Operator Tree: @@ -2197,8 +2283,8 @@ STAGE PLANS: Inner Join 0 to 1 keys: 0 _col1 (type: string) - 1 value (type: string) - Statistics: Num rows: 302 Data size: 28435 Basic stats: COMPLETE Column stats: NONE + 1 _col0 (type: string) + Statistics: Num rows: 605 Data size: 56870 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -2281,46 +2367,54 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 6 Map Operator Tree: TableScan - alias: s3 + alias: s1 filterExpr: key is not null (type: boolean) Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 242 Data size: 22748 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: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 7 Map Operator Tree: TableScan - alias: s2 + alias: s1 filterExpr: key is not null (type: boolean) Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 254 Data size: 23885 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 508 Data size: 47770 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 8 Map Operator Tree: @@ -2330,12 +2424,16 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: key (type: int) - sort order: + - Map-reduce partition columns: key (type: int) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 47000 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: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: llap @@ -2344,15 +2442,15 @@ STAGE PLANS: condition map: Inner Join 0 to 1 keys: - 0 key (type: int) - 1 key (type: int) + 0 _col0 (type: int) + 1 _col0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 133 Data size: 12511 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 266 Data size: 25022 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 254 Data size: 23885 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 508 Data size: 47770 Basic stats: COMPLETE Column stats: NONE Reducer 4 Execution mode: llap Reduce Operator Tree: @@ -2361,8 +2459,8 @@ STAGE PLANS: Inner Join 0 to 1 keys: 0 _col0 (type: int) - 1 key (type: int) - Statistics: Num rows: 279 Data size: 26273 Basic stats: COMPLETE Column stats: NONE + 1 _col0 (type: int) + Statistics: Num rows: 558 Data size: 52547 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -2436,15 +2534,15 @@ STAGE PLANS: Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int), _col1 (type: string) sort order: ++ - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Map 5 Map Operator Tree: @@ -2454,15 +2552,15 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int), _col1 (type: string) sort order: ++ - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized, llap Reducer 2 Execution mode: vectorized, llap @@ -2470,12 +2568,12 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 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: 121 Data size: 11374 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 242 Data size: 22748 Basic stats: COMPLETE Column stats: NONE Reducer 3 Execution mode: llap Reduce Operator Tree: @@ -2485,22 +2583,16 @@ STAGE PLANS: keys: 0 _col0 (type: int) 1 _col0 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 275 Data size: 25850 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (_col0 = _col1) (type: boolean) - Statistics: Num rows: 137 Data size: 12878 Basic stats: COMPLETE Column stats: NONE - Select Operator - Statistics: Num rows: 137 Data size: 12878 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) + Statistics: Num rows: 550 Data size: 51700 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: count() + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: bigint) Reducer 4 Execution mode: vectorized, uber Reduce Operator Tree: @@ -2522,12 +2614,12 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 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: 250 Data size: 23500 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 47000 Basic stats: COMPLETE Column stats: NONE Stage: Stage-0 Fetch Operator @@ -2617,10 +2709,1098 @@ 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 #### +PREHOOK: query: select * from +(select * from tab where tab.key = 0)a +full outer join +(select * from tab_part where tab_part.key = 98)b on a.key = b.key join tab_part c on b.key = c.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 +(select * from tab where tab.key = 0)a +full outer join +(select * from tab_part where tab_part.key = 98)b on a.key = b.key join tab_part c on b.key = c.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 #### NULL NULL NULL 98 val_98 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL 98 val_98 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL 98 val_98 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL 98 val_98 2008-04-08 98 val_98 2008-04-08 +Warning: Shuffle Join MERGEJOIN[20][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product +PREHOOK: query: select * from +(select * from tab where tab.key = 0)a +join +(select * from tab_part where tab_part.key = 98)b full outer join tab_part c on a.key = b.key and b.key = c.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 +(select * from tab where tab.key = 0)a +join +(select * from tab_part where tab_part.key = 98)b full outer join tab_part c on a.key = b.key and b.key = c.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 98 val_98 2008-04-08 NULL NULL NULL +0 val_0 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL +0 val_0 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL +0 val_0 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL +0 val_0 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL +0 val_0 2008-04-08 98 val_98 2008-04-08 NULL NULL NULL +NULL NULL NULL NULL NULL NULL 0 val_0 2008-04-08 +NULL NULL NULL NULL NULL NULL 0 val_0 2008-04-08 +NULL NULL NULL NULL NULL NULL 0 val_0 2008-04-08 +NULL NULL NULL NULL NULL NULL 10 val_10 2008-04-08 +NULL NULL NULL NULL NULL NULL 100 val_100 2008-04-08 +NULL NULL NULL NULL NULL NULL 100 val_100 2008-04-08 +NULL NULL NULL NULL NULL NULL 103 val_103 2008-04-08 +NULL NULL NULL NULL NULL NULL 103 val_103 2008-04-08 +NULL NULL NULL NULL NULL NULL 104 val_104 2008-04-08 +NULL NULL NULL NULL NULL NULL 104 val_104 2008-04-08 +NULL NULL NULL NULL NULL NULL 105 val_105 2008-04-08 +NULL NULL NULL NULL NULL NULL 11 val_11 2008-04-08 +NULL NULL NULL NULL NULL NULL 111 val_111 2008-04-08 +NULL NULL NULL NULL NULL NULL 113 val_113 2008-04-08 +NULL NULL NULL NULL NULL NULL 113 val_113 2008-04-08 +NULL NULL NULL NULL NULL NULL 114 val_114 2008-04-08 +NULL NULL NULL NULL NULL NULL 116 val_116 2008-04-08 +NULL NULL NULL NULL NULL NULL 118 val_118 2008-04-08 +NULL NULL NULL NULL NULL NULL 118 val_118 2008-04-08 +NULL NULL NULL NULL NULL NULL 119 val_119 2008-04-08 +NULL NULL NULL NULL NULL NULL 119 val_119 2008-04-08 +NULL NULL NULL NULL NULL NULL 119 val_119 2008-04-08 +NULL NULL NULL NULL NULL NULL 12 val_12 2008-04-08 +NULL NULL NULL NULL NULL NULL 12 val_12 2008-04-08 +NULL NULL NULL NULL NULL NULL 120 val_120 2008-04-08 +NULL NULL NULL NULL NULL NULL 120 val_120 2008-04-08 +NULL NULL NULL NULL NULL NULL 125 val_125 2008-04-08 +NULL NULL NULL NULL NULL NULL 125 val_125 2008-04-08 +NULL NULL NULL NULL NULL NULL 126 val_126 2008-04-08 +NULL NULL NULL NULL NULL NULL 128 val_128 2008-04-08 +NULL NULL NULL NULL NULL NULL 128 val_128 2008-04-08 +NULL NULL NULL NULL NULL NULL 128 val_128 2008-04-08 +NULL NULL NULL NULL NULL NULL 129 val_129 2008-04-08 +NULL NULL NULL NULL NULL NULL 129 val_129 2008-04-08 +NULL NULL NULL NULL NULL NULL 131 val_131 2008-04-08 +NULL NULL NULL NULL NULL NULL 133 val_133 2008-04-08 +NULL NULL NULL NULL NULL NULL 134 val_134 2008-04-08 +NULL NULL NULL NULL NULL NULL 134 val_134 2008-04-08 +NULL NULL NULL NULL NULL NULL 136 val_136 2008-04-08 +NULL NULL NULL NULL NULL NULL 137 val_137 2008-04-08 +NULL NULL NULL NULL NULL NULL 137 val_137 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 143 val_143 2008-04-08 +NULL NULL NULL NULL NULL NULL 145 val_145 2008-04-08 +NULL NULL NULL NULL NULL NULL 146 val_146 2008-04-08 +NULL NULL NULL NULL NULL NULL 146 val_146 2008-04-08 +NULL NULL NULL NULL NULL NULL 149 val_149 2008-04-08 +NULL NULL NULL NULL NULL NULL 149 val_149 2008-04-08 +NULL NULL NULL NULL NULL NULL 15 val_15 2008-04-08 +NULL NULL NULL NULL NULL NULL 15 val_15 2008-04-08 +NULL NULL NULL NULL NULL NULL 150 val_150 2008-04-08 +NULL NULL NULL NULL NULL NULL 152 val_152 2008-04-08 +NULL NULL NULL NULL NULL NULL 152 val_152 2008-04-08 +NULL NULL NULL NULL NULL NULL 153 val_153 2008-04-08 +NULL NULL NULL NULL NULL NULL 155 val_155 2008-04-08 +NULL NULL NULL NULL NULL NULL 156 val_156 2008-04-08 +NULL NULL NULL NULL NULL NULL 157 val_157 2008-04-08 +NULL NULL NULL NULL NULL NULL 158 val_158 2008-04-08 +NULL NULL NULL NULL NULL NULL 160 val_160 2008-04-08 +NULL NULL NULL NULL NULL NULL 162 val_162 2008-04-08 +NULL NULL NULL NULL NULL NULL 163 val_163 2008-04-08 +NULL NULL NULL NULL NULL NULL 164 val_164 2008-04-08 +NULL NULL NULL NULL NULL NULL 164 val_164 2008-04-08 +NULL NULL NULL NULL NULL NULL 165 val_165 2008-04-08 +NULL NULL NULL NULL NULL NULL 165 val_165 2008-04-08 +NULL NULL NULL NULL NULL NULL 166 val_166 2008-04-08 +NULL NULL NULL NULL NULL NULL 167 val_167 2008-04-08 +NULL NULL NULL NULL NULL NULL 167 val_167 2008-04-08 +NULL NULL NULL NULL NULL NULL 167 val_167 2008-04-08 +NULL NULL NULL NULL NULL NULL 168 val_168 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 17 val_17 2008-04-08 +NULL NULL NULL NULL NULL NULL 170 val_170 2008-04-08 +NULL NULL NULL NULL NULL NULL 172 val_172 2008-04-08 +NULL NULL NULL NULL NULL NULL 172 val_172 2008-04-08 +NULL NULL NULL NULL NULL NULL 174 val_174 2008-04-08 +NULL NULL NULL NULL NULL NULL 174 val_174 2008-04-08 +NULL NULL NULL NULL NULL NULL 175 val_175 2008-04-08 +NULL NULL NULL NULL NULL NULL 175 val_175 2008-04-08 +NULL NULL NULL NULL NULL NULL 176 val_176 2008-04-08 +NULL NULL NULL NULL NULL NULL 176 val_176 2008-04-08 +NULL NULL NULL NULL NULL NULL 177 val_177 2008-04-08 +NULL NULL NULL NULL NULL NULL 178 val_178 2008-04-08 +NULL NULL NULL NULL NULL NULL 179 val_179 2008-04-08 +NULL NULL NULL NULL NULL NULL 179 val_179 2008-04-08 +NULL NULL NULL NULL NULL NULL 18 val_18 2008-04-08 +NULL NULL NULL NULL NULL NULL 18 val_18 2008-04-08 +NULL NULL NULL NULL NULL NULL 180 val_180 2008-04-08 +NULL NULL NULL NULL NULL NULL 181 val_181 2008-04-08 +NULL NULL NULL NULL NULL NULL 183 val_183 2008-04-08 +NULL NULL NULL NULL NULL NULL 186 val_186 2008-04-08 +NULL NULL NULL NULL NULL NULL 187 val_187 2008-04-08 +NULL NULL NULL NULL NULL NULL 187 val_187 2008-04-08 +NULL NULL NULL NULL NULL NULL 187 val_187 2008-04-08 +NULL NULL NULL NULL NULL NULL 189 val_189 2008-04-08 +NULL NULL NULL NULL NULL NULL 19 val_19 2008-04-08 +NULL NULL NULL NULL NULL NULL 190 val_190 2008-04-08 +NULL NULL NULL NULL NULL NULL 191 val_191 2008-04-08 +NULL NULL NULL NULL NULL NULL 191 val_191 2008-04-08 +NULL NULL NULL NULL NULL NULL 192 val_192 2008-04-08 +NULL NULL NULL NULL NULL NULL 193 val_193 2008-04-08 +NULL NULL NULL NULL NULL NULL 193 val_193 2008-04-08 +NULL NULL NULL NULL NULL NULL 193 val_193 2008-04-08 +NULL NULL NULL NULL NULL NULL 194 val_194 2008-04-08 +NULL NULL NULL NULL NULL NULL 195 val_195 2008-04-08 +NULL NULL NULL NULL NULL NULL 195 val_195 2008-04-08 +NULL NULL NULL NULL NULL NULL 196 val_196 2008-04-08 +NULL NULL NULL NULL NULL NULL 197 val_197 2008-04-08 +NULL NULL NULL NULL NULL NULL 197 val_197 2008-04-08 +NULL NULL NULL NULL NULL NULL 199 val_199 2008-04-08 +NULL NULL NULL NULL NULL NULL 199 val_199 2008-04-08 +NULL NULL NULL NULL NULL NULL 199 val_199 2008-04-08 +NULL NULL NULL NULL NULL NULL 2 val_2 2008-04-08 +NULL NULL NULL NULL NULL NULL 20 val_20 2008-04-08 +NULL NULL NULL NULL NULL NULL 200 val_200 2008-04-08 +NULL NULL NULL NULL NULL NULL 200 val_200 2008-04-08 +NULL NULL NULL NULL NULL NULL 201 val_201 2008-04-08 +NULL NULL NULL NULL NULL NULL 202 val_202 2008-04-08 +NULL NULL NULL NULL NULL NULL 203 val_203 2008-04-08 +NULL NULL NULL NULL NULL NULL 203 val_203 2008-04-08 +NULL NULL NULL NULL NULL NULL 205 val_205 2008-04-08 +NULL NULL NULL NULL NULL NULL 205 val_205 2008-04-08 +NULL NULL NULL NULL NULL NULL 207 val_207 2008-04-08 +NULL NULL NULL NULL NULL NULL 207 val_207 2008-04-08 +NULL NULL NULL NULL NULL NULL 208 val_208 2008-04-08 +NULL NULL NULL NULL NULL NULL 208 val_208 2008-04-08 +NULL NULL NULL NULL NULL NULL 208 val_208 2008-04-08 +NULL NULL NULL NULL NULL NULL 209 val_209 2008-04-08 +NULL NULL NULL NULL NULL NULL 209 val_209 2008-04-08 +NULL NULL NULL NULL NULL NULL 213 val_213 2008-04-08 +NULL NULL NULL NULL NULL NULL 213 val_213 2008-04-08 +NULL NULL NULL NULL NULL NULL 214 val_214 2008-04-08 +NULL NULL NULL NULL NULL NULL 216 val_216 2008-04-08 +NULL NULL NULL NULL NULL NULL 216 val_216 2008-04-08 +NULL NULL NULL NULL NULL NULL 217 val_217 2008-04-08 +NULL NULL NULL NULL NULL NULL 217 val_217 2008-04-08 +NULL NULL NULL NULL NULL NULL 218 val_218 2008-04-08 +NULL NULL NULL NULL NULL NULL 219 val_219 2008-04-08 +NULL NULL NULL NULL NULL NULL 219 val_219 2008-04-08 +NULL NULL NULL NULL NULL NULL 221 val_221 2008-04-08 +NULL NULL NULL NULL NULL NULL 221 val_221 2008-04-08 +NULL NULL NULL NULL NULL NULL 222 val_222 2008-04-08 +NULL NULL NULL NULL NULL NULL 223 val_223 2008-04-08 +NULL NULL NULL NULL NULL NULL 223 val_223 2008-04-08 +NULL NULL NULL NULL NULL NULL 224 val_224 2008-04-08 +NULL NULL NULL NULL NULL NULL 224 val_224 2008-04-08 +NULL NULL NULL NULL NULL NULL 226 val_226 2008-04-08 +NULL NULL NULL NULL NULL NULL 228 val_228 2008-04-08 +NULL NULL NULL NULL NULL NULL 229 val_229 2008-04-08 +NULL NULL NULL NULL NULL NULL 229 val_229 2008-04-08 +NULL NULL NULL NULL NULL NULL 230 val_230 2008-04-08 +NULL NULL NULL NULL NULL NULL 230 val_230 2008-04-08 +NULL NULL NULL NULL NULL NULL 230 val_230 2008-04-08 +NULL NULL NULL NULL NULL NULL 230 val_230 2008-04-08 +NULL NULL NULL NULL NULL NULL 230 val_230 2008-04-08 +NULL NULL NULL NULL NULL NULL 233 val_233 2008-04-08 +NULL NULL NULL NULL NULL NULL 233 val_233 2008-04-08 +NULL NULL NULL NULL NULL NULL 235 val_235 2008-04-08 +NULL NULL NULL NULL NULL NULL 237 val_237 2008-04-08 +NULL NULL NULL NULL NULL NULL 237 val_237 2008-04-08 +NULL NULL NULL NULL NULL NULL 238 val_238 2008-04-08 +NULL NULL NULL NULL NULL NULL 238 val_238 2008-04-08 +NULL NULL NULL NULL NULL NULL 239 val_239 2008-04-08 +NULL NULL NULL NULL NULL NULL 239 val_239 2008-04-08 +NULL NULL NULL NULL NULL NULL 24 val_24 2008-04-08 +NULL NULL NULL NULL NULL NULL 24 val_24 2008-04-08 +NULL NULL NULL NULL NULL NULL 241 val_241 2008-04-08 +NULL NULL NULL NULL NULL NULL 242 val_242 2008-04-08 +NULL NULL NULL NULL NULL NULL 242 val_242 2008-04-08 +NULL NULL NULL NULL NULL NULL 244 val_244 2008-04-08 +NULL NULL NULL NULL NULL NULL 247 val_247 2008-04-08 +NULL NULL NULL NULL NULL NULL 248 val_248 2008-04-08 +NULL NULL NULL NULL NULL NULL 249 val_249 2008-04-08 +NULL NULL NULL NULL NULL NULL 252 val_252 2008-04-08 +NULL NULL NULL NULL NULL NULL 255 val_255 2008-04-08 +NULL NULL NULL NULL NULL NULL 255 val_255 2008-04-08 +NULL NULL NULL NULL NULL NULL 256 val_256 2008-04-08 +NULL NULL NULL NULL NULL NULL 256 val_256 2008-04-08 +NULL NULL NULL NULL NULL NULL 257 val_257 2008-04-08 +NULL NULL NULL NULL NULL NULL 258 val_258 2008-04-08 +NULL NULL NULL NULL NULL NULL 26 val_26 2008-04-08 +NULL NULL NULL NULL NULL NULL 26 val_26 2008-04-08 +NULL NULL NULL NULL NULL NULL 260 val_260 2008-04-08 +NULL NULL NULL NULL NULL NULL 262 val_262 2008-04-08 +NULL NULL NULL NULL NULL NULL 263 val_263 2008-04-08 +NULL NULL NULL NULL NULL NULL 265 val_265 2008-04-08 +NULL NULL NULL NULL NULL NULL 265 val_265 2008-04-08 +NULL NULL NULL NULL NULL NULL 266 val_266 2008-04-08 +NULL NULL NULL NULL NULL NULL 27 val_27 2008-04-08 +NULL NULL NULL NULL NULL NULL 272 val_272 2008-04-08 +NULL NULL NULL NULL NULL NULL 272 val_272 2008-04-08 +NULL NULL NULL NULL NULL NULL 273 val_273 2008-04-08 +NULL NULL NULL NULL NULL NULL 273 val_273 2008-04-08 +NULL NULL NULL NULL NULL NULL 273 val_273 2008-04-08 +NULL NULL NULL NULL NULL NULL 274 val_274 2008-04-08 +NULL NULL NULL NULL NULL NULL 275 val_275 2008-04-08 +NULL NULL NULL NULL NULL NULL 277 val_277 2008-04-08 +NULL NULL NULL NULL NULL NULL 277 val_277 2008-04-08 +NULL NULL NULL NULL NULL NULL 277 val_277 2008-04-08 +NULL NULL NULL NULL NULL NULL 277 val_277 2008-04-08 +NULL NULL NULL NULL NULL NULL 278 val_278 2008-04-08 +NULL NULL NULL NULL NULL NULL 278 val_278 2008-04-08 +NULL NULL NULL NULL NULL NULL 28 val_28 2008-04-08 +NULL NULL NULL NULL NULL NULL 280 val_280 2008-04-08 +NULL NULL NULL NULL NULL NULL 280 val_280 2008-04-08 +NULL NULL NULL NULL NULL NULL 281 val_281 2008-04-08 +NULL NULL NULL NULL NULL NULL 281 val_281 2008-04-08 +NULL NULL NULL NULL NULL NULL 282 val_282 2008-04-08 +NULL NULL NULL NULL NULL NULL 282 val_282 2008-04-08 +NULL NULL NULL NULL NULL NULL 283 val_283 2008-04-08 +NULL NULL NULL NULL NULL NULL 284 val_284 2008-04-08 +NULL NULL NULL NULL NULL NULL 285 val_285 2008-04-08 +NULL NULL NULL NULL NULL NULL 286 val_286 2008-04-08 +NULL NULL NULL NULL NULL NULL 287 val_287 2008-04-08 +NULL NULL NULL NULL NULL NULL 288 val_288 2008-04-08 +NULL NULL NULL NULL NULL NULL 288 val_288 2008-04-08 +NULL NULL NULL NULL NULL NULL 289 val_289 2008-04-08 +NULL NULL NULL NULL NULL NULL 291 val_291 2008-04-08 +NULL NULL NULL NULL NULL NULL 292 val_292 2008-04-08 +NULL NULL NULL NULL NULL NULL 296 val_296 2008-04-08 +NULL NULL NULL NULL NULL NULL 298 val_298 2008-04-08 +NULL NULL NULL NULL NULL NULL 298 val_298 2008-04-08 +NULL NULL NULL NULL NULL NULL 298 val_298 2008-04-08 +NULL NULL NULL NULL NULL NULL 30 val_30 2008-04-08 +NULL NULL NULL NULL NULL NULL 302 val_302 2008-04-08 +NULL NULL NULL NULL NULL NULL 305 val_305 2008-04-08 +NULL NULL NULL NULL NULL NULL 306 val_306 2008-04-08 +NULL NULL NULL NULL NULL NULL 307 val_307 2008-04-08 +NULL NULL NULL NULL NULL NULL 307 val_307 2008-04-08 +NULL NULL NULL NULL NULL NULL 308 val_308 2008-04-08 +NULL NULL NULL NULL NULL NULL 309 val_309 2008-04-08 +NULL NULL NULL NULL NULL NULL 309 val_309 2008-04-08 +NULL NULL NULL NULL NULL NULL 310 val_310 2008-04-08 +NULL NULL NULL NULL NULL NULL 311 val_311 2008-04-08 +NULL NULL NULL NULL NULL NULL 311 val_311 2008-04-08 +NULL NULL NULL NULL NULL NULL 311 val_311 2008-04-08 +NULL NULL NULL NULL NULL NULL 315 val_315 2008-04-08 +NULL NULL NULL NULL NULL NULL 316 val_316 2008-04-08 +NULL NULL NULL NULL NULL NULL 316 val_316 2008-04-08 +NULL NULL NULL NULL NULL NULL 316 val_316 2008-04-08 +NULL NULL NULL NULL NULL NULL 317 val_317 2008-04-08 +NULL NULL NULL NULL NULL NULL 317 val_317 2008-04-08 +NULL NULL NULL NULL NULL NULL 318 val_318 2008-04-08 +NULL NULL NULL NULL NULL NULL 318 val_318 2008-04-08 +NULL NULL NULL NULL NULL NULL 318 val_318 2008-04-08 +NULL NULL NULL NULL NULL NULL 321 val_321 2008-04-08 +NULL NULL NULL NULL NULL NULL 321 val_321 2008-04-08 +NULL NULL NULL NULL NULL NULL 322 val_322 2008-04-08 +NULL NULL NULL NULL NULL NULL 322 val_322 2008-04-08 +NULL NULL NULL NULL NULL NULL 323 val_323 2008-04-08 +NULL NULL NULL NULL NULL NULL 325 val_325 2008-04-08 +NULL NULL NULL NULL NULL NULL 325 val_325 2008-04-08 +NULL NULL NULL NULL NULL NULL 327 val_327 2008-04-08 +NULL NULL NULL NULL NULL NULL 327 val_327 2008-04-08 +NULL NULL NULL NULL NULL NULL 327 val_327 2008-04-08 +NULL NULL NULL NULL NULL NULL 33 val_33 2008-04-08 +NULL NULL NULL NULL NULL NULL 331 val_331 2008-04-08 +NULL NULL NULL NULL NULL NULL 331 val_331 2008-04-08 +NULL NULL NULL NULL NULL NULL 332 val_332 2008-04-08 +NULL NULL NULL NULL NULL NULL 333 val_333 2008-04-08 +NULL NULL NULL NULL NULL NULL 333 val_333 2008-04-08 +NULL NULL NULL NULL NULL NULL 335 val_335 2008-04-08 +NULL NULL NULL NULL NULL NULL 336 val_336 2008-04-08 +NULL NULL NULL NULL NULL NULL 338 val_338 2008-04-08 +NULL NULL NULL NULL NULL NULL 339 val_339 2008-04-08 +NULL NULL NULL NULL NULL NULL 34 val_34 2008-04-08 +NULL NULL NULL NULL NULL NULL 341 val_341 2008-04-08 +NULL NULL NULL NULL NULL NULL 342 val_342 2008-04-08 +NULL NULL NULL NULL NULL NULL 342 val_342 2008-04-08 +NULL NULL NULL NULL NULL NULL 344 val_344 2008-04-08 +NULL NULL NULL NULL NULL NULL 344 val_344 2008-04-08 +NULL NULL NULL NULL NULL NULL 345 val_345 2008-04-08 +NULL NULL NULL NULL NULL NULL 348 val_348 2008-04-08 +NULL NULL NULL NULL NULL NULL 348 val_348 2008-04-08 +NULL NULL NULL NULL NULL NULL 348 val_348 2008-04-08 +NULL NULL NULL NULL NULL NULL 348 val_348 2008-04-08 +NULL NULL NULL NULL NULL NULL 348 val_348 2008-04-08 +NULL NULL NULL NULL NULL NULL 35 val_35 2008-04-08 +NULL NULL NULL NULL NULL NULL 35 val_35 2008-04-08 +NULL NULL NULL NULL NULL NULL 35 val_35 2008-04-08 +NULL NULL NULL NULL NULL NULL 351 val_351 2008-04-08 +NULL NULL NULL NULL NULL NULL 353 val_353 2008-04-08 +NULL NULL NULL NULL NULL NULL 353 val_353 2008-04-08 +NULL NULL NULL NULL NULL NULL 356 val_356 2008-04-08 +NULL NULL NULL NULL NULL NULL 360 val_360 2008-04-08 +NULL NULL NULL NULL NULL NULL 362 val_362 2008-04-08 +NULL NULL NULL NULL NULL NULL 364 val_364 2008-04-08 +NULL NULL NULL NULL NULL NULL 365 val_365 2008-04-08 +NULL NULL NULL NULL NULL NULL 366 val_366 2008-04-08 +NULL NULL NULL NULL NULL NULL 367 val_367 2008-04-08 +NULL NULL NULL NULL NULL NULL 367 val_367 2008-04-08 +NULL NULL NULL NULL NULL NULL 368 val_368 2008-04-08 +NULL NULL NULL NULL NULL NULL 369 val_369 2008-04-08 +NULL NULL NULL NULL NULL NULL 369 val_369 2008-04-08 +NULL NULL NULL NULL NULL NULL 369 val_369 2008-04-08 +NULL NULL NULL NULL NULL NULL 37 val_37 2008-04-08 +NULL NULL NULL NULL NULL NULL 37 val_37 2008-04-08 +NULL NULL NULL NULL NULL NULL 373 val_373 2008-04-08 +NULL NULL NULL NULL NULL NULL 374 val_374 2008-04-08 +NULL NULL NULL NULL NULL NULL 375 val_375 2008-04-08 +NULL NULL NULL NULL NULL NULL 377 val_377 2008-04-08 +NULL NULL NULL NULL NULL NULL 378 val_378 2008-04-08 +NULL NULL NULL NULL NULL NULL 379 val_379 2008-04-08 +NULL NULL NULL NULL NULL NULL 382 val_382 2008-04-08 +NULL NULL NULL NULL NULL NULL 382 val_382 2008-04-08 +NULL NULL NULL NULL NULL NULL 384 val_384 2008-04-08 +NULL NULL NULL NULL NULL NULL 384 val_384 2008-04-08 +NULL NULL NULL NULL NULL NULL 384 val_384 2008-04-08 +NULL NULL NULL NULL NULL NULL 386 val_386 2008-04-08 +NULL NULL NULL NULL NULL NULL 389 val_389 2008-04-08 +NULL NULL NULL NULL NULL NULL 392 val_392 2008-04-08 +NULL NULL NULL NULL NULL NULL 393 val_393 2008-04-08 +NULL NULL NULL NULL NULL NULL 394 val_394 2008-04-08 +NULL NULL NULL NULL NULL NULL 395 val_395 2008-04-08 +NULL NULL NULL NULL NULL NULL 395 val_395 2008-04-08 +NULL NULL NULL NULL NULL NULL 396 val_396 2008-04-08 +NULL NULL NULL NULL NULL NULL 396 val_396 2008-04-08 +NULL NULL NULL NULL NULL NULL 396 val_396 2008-04-08 +NULL NULL NULL NULL NULL NULL 397 val_397 2008-04-08 +NULL NULL NULL NULL NULL NULL 397 val_397 2008-04-08 +NULL NULL NULL NULL NULL NULL 399 val_399 2008-04-08 +NULL NULL NULL NULL NULL NULL 399 val_399 2008-04-08 +NULL NULL NULL NULL NULL NULL 4 val_4 2008-04-08 +NULL NULL NULL NULL NULL NULL 400 val_400 2008-04-08 +NULL NULL NULL NULL NULL NULL 401 val_401 2008-04-08 +NULL NULL NULL NULL NULL NULL 401 val_401 2008-04-08 +NULL NULL NULL NULL NULL NULL 401 val_401 2008-04-08 +NULL NULL NULL NULL NULL NULL 401 val_401 2008-04-08 +NULL NULL NULL NULL NULL NULL 401 val_401 2008-04-08 +NULL NULL NULL NULL NULL NULL 402 val_402 2008-04-08 +NULL NULL NULL NULL NULL NULL 403 val_403 2008-04-08 +NULL NULL NULL NULL NULL NULL 403 val_403 2008-04-08 +NULL NULL NULL NULL NULL NULL 403 val_403 2008-04-08 +NULL NULL NULL NULL NULL NULL 404 val_404 2008-04-08 +NULL NULL NULL NULL NULL NULL 404 val_404 2008-04-08 +NULL NULL NULL NULL NULL NULL 406 val_406 2008-04-08 +NULL NULL NULL NULL NULL NULL 406 val_406 2008-04-08 +NULL NULL NULL NULL NULL NULL 406 val_406 2008-04-08 +NULL NULL NULL NULL NULL NULL 406 val_406 2008-04-08 +NULL NULL NULL NULL NULL NULL 407 val_407 2008-04-08 +NULL NULL NULL NULL NULL NULL 409 val_409 2008-04-08 +NULL NULL NULL NULL NULL NULL 409 val_409 2008-04-08 +NULL NULL NULL NULL NULL NULL 409 val_409 2008-04-08 +NULL NULL NULL NULL NULL NULL 41 val_41 2008-04-08 +NULL NULL NULL NULL NULL NULL 411 val_411 2008-04-08 +NULL NULL NULL NULL NULL NULL 413 val_413 2008-04-08 +NULL NULL NULL NULL NULL NULL 413 val_413 2008-04-08 +NULL NULL NULL NULL NULL NULL 414 val_414 2008-04-08 +NULL NULL NULL NULL NULL NULL 414 val_414 2008-04-08 +NULL NULL NULL NULL NULL NULL 417 val_417 2008-04-08 +NULL NULL NULL NULL NULL NULL 417 val_417 2008-04-08 +NULL NULL NULL NULL NULL NULL 417 val_417 2008-04-08 +NULL NULL NULL NULL NULL NULL 418 val_418 2008-04-08 +NULL NULL NULL NULL NULL NULL 419 val_419 2008-04-08 +NULL NULL NULL NULL NULL NULL 42 val_42 2008-04-08 +NULL NULL NULL NULL NULL NULL 42 val_42 2008-04-08 +NULL NULL NULL NULL NULL NULL 421 val_421 2008-04-08 +NULL NULL NULL NULL NULL NULL 424 val_424 2008-04-08 +NULL NULL NULL NULL NULL NULL 424 val_424 2008-04-08 +NULL NULL NULL NULL NULL NULL 427 val_427 2008-04-08 +NULL NULL NULL NULL NULL NULL 429 val_429 2008-04-08 +NULL NULL NULL NULL NULL NULL 429 val_429 2008-04-08 +NULL NULL NULL NULL NULL NULL 43 val_43 2008-04-08 +NULL NULL NULL NULL NULL NULL 430 val_430 2008-04-08 +NULL NULL NULL NULL NULL NULL 430 val_430 2008-04-08 +NULL NULL NULL NULL NULL NULL 430 val_430 2008-04-08 +NULL NULL NULL NULL NULL NULL 431 val_431 2008-04-08 +NULL NULL NULL NULL NULL NULL 431 val_431 2008-04-08 +NULL NULL NULL NULL NULL NULL 431 val_431 2008-04-08 +NULL NULL NULL NULL NULL NULL 432 val_432 2008-04-08 +NULL NULL NULL NULL NULL NULL 435 val_435 2008-04-08 +NULL NULL NULL NULL NULL NULL 436 val_436 2008-04-08 +NULL NULL NULL NULL NULL NULL 437 val_437 2008-04-08 +NULL NULL NULL NULL NULL NULL 438 val_438 2008-04-08 +NULL NULL NULL NULL NULL NULL 438 val_438 2008-04-08 +NULL NULL NULL NULL NULL NULL 438 val_438 2008-04-08 +NULL NULL NULL NULL NULL NULL 439 val_439 2008-04-08 +NULL NULL NULL NULL NULL NULL 439 val_439 2008-04-08 +NULL NULL NULL NULL NULL NULL 44 val_44 2008-04-08 +NULL NULL NULL NULL NULL NULL 443 val_443 2008-04-08 +NULL NULL NULL NULL NULL NULL 444 val_444 2008-04-08 +NULL NULL NULL NULL NULL NULL 446 val_446 2008-04-08 +NULL NULL NULL NULL NULL NULL 448 val_448 2008-04-08 +NULL NULL NULL NULL NULL NULL 449 val_449 2008-04-08 +NULL NULL NULL NULL NULL NULL 452 val_452 2008-04-08 +NULL NULL NULL NULL NULL NULL 453 val_453 2008-04-08 +NULL NULL NULL NULL NULL NULL 454 val_454 2008-04-08 +NULL NULL NULL NULL NULL NULL 454 val_454 2008-04-08 +NULL NULL NULL NULL NULL NULL 454 val_454 2008-04-08 +NULL NULL NULL NULL NULL NULL 455 val_455 2008-04-08 +NULL NULL NULL NULL NULL NULL 457 val_457 2008-04-08 +NULL NULL NULL NULL NULL NULL 458 val_458 2008-04-08 +NULL NULL NULL NULL NULL NULL 458 val_458 2008-04-08 +NULL NULL NULL NULL NULL NULL 459 val_459 2008-04-08 +NULL NULL NULL NULL NULL NULL 459 val_459 2008-04-08 +NULL NULL NULL NULL NULL NULL 460 val_460 2008-04-08 +NULL NULL NULL NULL NULL NULL 462 val_462 2008-04-08 +NULL NULL NULL NULL NULL NULL 462 val_462 2008-04-08 +NULL NULL NULL NULL NULL NULL 463 val_463 2008-04-08 +NULL NULL NULL NULL NULL NULL 463 val_463 2008-04-08 +NULL NULL NULL NULL NULL NULL 466 val_466 2008-04-08 +NULL NULL NULL NULL NULL NULL 466 val_466 2008-04-08 +NULL NULL NULL NULL NULL NULL 466 val_466 2008-04-08 +NULL NULL NULL NULL NULL NULL 467 val_467 2008-04-08 +NULL NULL NULL NULL NULL NULL 468 val_468 2008-04-08 +NULL NULL NULL NULL NULL NULL 468 val_468 2008-04-08 +NULL NULL NULL NULL NULL NULL 468 val_468 2008-04-08 +NULL NULL NULL NULL NULL NULL 468 val_468 2008-04-08 +NULL NULL NULL NULL NULL NULL 469 val_469 2008-04-08 +NULL NULL NULL NULL NULL NULL 469 val_469 2008-04-08 +NULL NULL NULL NULL NULL NULL 469 val_469 2008-04-08 +NULL NULL NULL NULL NULL NULL 469 val_469 2008-04-08 +NULL NULL NULL NULL NULL NULL 469 val_469 2008-04-08 +NULL NULL NULL NULL NULL NULL 47 val_47 2008-04-08 +NULL NULL NULL NULL NULL NULL 470 val_470 2008-04-08 +NULL NULL NULL NULL NULL NULL 472 val_472 2008-04-08 +NULL NULL NULL NULL NULL NULL 475 val_475 2008-04-08 +NULL NULL NULL NULL NULL NULL 477 val_477 2008-04-08 +NULL NULL NULL NULL NULL NULL 478 val_478 2008-04-08 +NULL NULL NULL NULL NULL NULL 478 val_478 2008-04-08 +NULL NULL NULL NULL NULL NULL 479 val_479 2008-04-08 +NULL NULL NULL NULL NULL NULL 480 val_480 2008-04-08 +NULL NULL NULL NULL NULL NULL 480 val_480 2008-04-08 +NULL NULL NULL NULL NULL NULL 480 val_480 2008-04-08 +NULL NULL NULL NULL NULL NULL 481 val_481 2008-04-08 +NULL NULL NULL NULL NULL NULL 482 val_482 2008-04-08 +NULL NULL NULL NULL NULL NULL 483 val_483 2008-04-08 +NULL NULL NULL NULL NULL NULL 484 val_484 2008-04-08 +NULL NULL NULL NULL NULL NULL 485 val_485 2008-04-08 +NULL NULL NULL NULL NULL NULL 487 val_487 2008-04-08 +NULL NULL NULL NULL NULL NULL 489 val_489 2008-04-08 +NULL NULL NULL NULL NULL NULL 489 val_489 2008-04-08 +NULL NULL NULL NULL NULL NULL 489 val_489 2008-04-08 +NULL NULL NULL NULL NULL NULL 489 val_489 2008-04-08 +NULL NULL NULL NULL NULL NULL 490 val_490 2008-04-08 +NULL NULL NULL NULL NULL NULL 491 val_491 2008-04-08 +NULL NULL NULL NULL NULL NULL 492 val_492 2008-04-08 +NULL NULL NULL NULL NULL NULL 492 val_492 2008-04-08 +NULL NULL NULL NULL NULL NULL 493 val_493 2008-04-08 +NULL NULL NULL NULL NULL NULL 494 val_494 2008-04-08 +NULL NULL NULL NULL NULL NULL 495 val_495 2008-04-08 +NULL NULL NULL NULL NULL NULL 496 val_496 2008-04-08 +NULL NULL NULL NULL NULL NULL 497 val_497 2008-04-08 +NULL NULL NULL NULL NULL NULL 498 val_498 2008-04-08 +NULL NULL NULL NULL NULL NULL 498 val_498 2008-04-08 +NULL NULL NULL NULL NULL NULL 498 val_498 2008-04-08 +NULL NULL NULL NULL NULL NULL 5 val_5 2008-04-08 +NULL NULL NULL NULL NULL NULL 5 val_5 2008-04-08 +NULL NULL NULL NULL NULL NULL 5 val_5 2008-04-08 +NULL NULL NULL NULL NULL NULL 51 val_51 2008-04-08 +NULL NULL NULL NULL NULL NULL 51 val_51 2008-04-08 +NULL NULL NULL NULL NULL NULL 53 val_53 2008-04-08 +NULL NULL NULL NULL NULL NULL 54 val_54 2008-04-08 +NULL NULL NULL NULL NULL NULL 57 val_57 2008-04-08 +NULL NULL NULL NULL NULL NULL 58 val_58 2008-04-08 +NULL NULL NULL NULL NULL NULL 58 val_58 2008-04-08 +NULL NULL NULL NULL NULL NULL 64 val_64 2008-04-08 +NULL NULL NULL NULL NULL NULL 65 val_65 2008-04-08 +NULL NULL NULL NULL NULL NULL 66 val_66 2008-04-08 +NULL NULL NULL NULL NULL NULL 67 val_67 2008-04-08 +NULL NULL NULL NULL NULL NULL 67 val_67 2008-04-08 +NULL NULL NULL NULL NULL NULL 69 val_69 2008-04-08 +NULL NULL NULL NULL NULL NULL 70 val_70 2008-04-08 +NULL NULL NULL NULL NULL NULL 70 val_70 2008-04-08 +NULL NULL NULL NULL NULL NULL 70 val_70 2008-04-08 +NULL NULL NULL NULL NULL NULL 72 val_72 2008-04-08 +NULL NULL NULL NULL NULL NULL 72 val_72 2008-04-08 +NULL NULL NULL NULL NULL NULL 74 val_74 2008-04-08 +NULL NULL NULL NULL NULL NULL 76 val_76 2008-04-08 +NULL NULL NULL NULL NULL NULL 76 val_76 2008-04-08 +NULL NULL NULL NULL NULL NULL 77 val_77 2008-04-08 +NULL NULL NULL NULL NULL NULL 78 val_78 2008-04-08 +NULL NULL NULL NULL NULL NULL 8 val_8 2008-04-08 +NULL NULL NULL NULL NULL NULL 80 val_80 2008-04-08 +NULL NULL NULL NULL NULL NULL 82 val_82 2008-04-08 +NULL NULL NULL NULL NULL NULL 83 val_83 2008-04-08 +NULL NULL NULL NULL NULL NULL 83 val_83 2008-04-08 +NULL NULL NULL NULL NULL NULL 84 val_84 2008-04-08 +NULL NULL NULL NULL NULL NULL 84 val_84 2008-04-08 +NULL NULL NULL NULL NULL NULL 85 val_85 2008-04-08 +NULL NULL NULL NULL NULL NULL 86 val_86 2008-04-08 +NULL NULL NULL NULL NULL NULL 87 val_87 2008-04-08 +NULL NULL NULL NULL NULL NULL 9 val_9 2008-04-08 +NULL NULL NULL NULL NULL NULL 90 val_90 2008-04-08 +NULL NULL NULL NULL NULL NULL 90 val_90 2008-04-08 +NULL NULL NULL NULL NULL NULL 90 val_90 2008-04-08 +NULL NULL NULL NULL NULL NULL 92 val_92 2008-04-08 +NULL NULL NULL NULL NULL NULL 95 val_95 2008-04-08 +NULL NULL NULL NULL NULL NULL 95 val_95 2008-04-08 +NULL NULL NULL NULL NULL NULL 96 val_96 2008-04-08 +NULL NULL NULL NULL NULL NULL 97 val_97 2008-04-08 +NULL NULL NULL NULL NULL NULL 97 val_97 2008-04-08 +NULL NULL NULL NULL NULL NULL 98 val_98 2008-04-08 +NULL NULL NULL NULL NULL NULL 98 val_98 2008-04-08 +PREHOOK: query: select * from +(select * from tab where tab.key = 0)a +join +(select * from tab_part where tab_part.key = 98)b on a.key = b.key full outer join tab_part c on b.key = c.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 +(select * from tab where tab.key = 0)a +join +(select * from tab_part where tab_part.key = 98)b on a.key = b.key full outer join tab_part c on b.key = c.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 #### +NULL NULL NULL NULL NULL NULL 0 val_0 2008-04-08 +NULL NULL NULL NULL NULL NULL 0 val_0 2008-04-08 +NULL NULL NULL NULL NULL NULL 0 val_0 2008-04-08 +NULL NULL NULL NULL NULL NULL 10 val_10 2008-04-08 +NULL NULL NULL NULL NULL NULL 100 val_100 2008-04-08 +NULL NULL NULL NULL NULL NULL 100 val_100 2008-04-08 +NULL NULL NULL NULL NULL NULL 103 val_103 2008-04-08 +NULL NULL NULL NULL NULL NULL 103 val_103 2008-04-08 +NULL NULL NULL NULL NULL NULL 104 val_104 2008-04-08 +NULL NULL NULL NULL NULL NULL 104 val_104 2008-04-08 +NULL NULL NULL NULL NULL NULL 105 val_105 2008-04-08 +NULL NULL NULL NULL NULL NULL 11 val_11 2008-04-08 +NULL NULL NULL NULL NULL NULL 111 val_111 2008-04-08 +NULL NULL NULL NULL NULL NULL 113 val_113 2008-04-08 +NULL NULL NULL NULL NULL NULL 113 val_113 2008-04-08 +NULL NULL NULL NULL NULL NULL 114 val_114 2008-04-08 +NULL NULL NULL NULL NULL NULL 116 val_116 2008-04-08 +NULL NULL NULL NULL NULL NULL 118 val_118 2008-04-08 +NULL NULL NULL NULL NULL NULL 118 val_118 2008-04-08 +NULL NULL NULL NULL NULL NULL 119 val_119 2008-04-08 +NULL NULL NULL NULL NULL NULL 119 val_119 2008-04-08 +NULL NULL NULL NULL NULL NULL 119 val_119 2008-04-08 +NULL NULL NULL NULL NULL NULL 12 val_12 2008-04-08 +NULL NULL NULL NULL NULL NULL 12 val_12 2008-04-08 +NULL NULL NULL NULL NULL NULL 120 val_120 2008-04-08 +NULL NULL NULL NULL NULL NULL 120 val_120 2008-04-08 +NULL NULL NULL NULL NULL NULL 125 val_125 2008-04-08 +NULL NULL NULL NULL NULL NULL 125 val_125 2008-04-08 +NULL NULL NULL NULL NULL NULL 126 val_126 2008-04-08 +NULL NULL NULL NULL NULL NULL 128 val_128 2008-04-08 +NULL NULL NULL NULL NULL NULL 128 val_128 2008-04-08 +NULL NULL NULL NULL NULL NULL 128 val_128 2008-04-08 +NULL NULL NULL NULL NULL NULL 129 val_129 2008-04-08 +NULL NULL NULL NULL NULL NULL 129 val_129 2008-04-08 +NULL NULL NULL NULL NULL NULL 131 val_131 2008-04-08 +NULL NULL NULL NULL NULL NULL 133 val_133 2008-04-08 +NULL NULL NULL NULL NULL NULL 134 val_134 2008-04-08 +NULL NULL NULL NULL NULL NULL 134 val_134 2008-04-08 +NULL NULL NULL NULL NULL NULL 136 val_136 2008-04-08 +NULL NULL NULL NULL NULL NULL 137 val_137 2008-04-08 +NULL NULL NULL NULL NULL NULL 137 val_137 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 138 val_138 2008-04-08 +NULL NULL NULL NULL NULL NULL 143 val_143 2008-04-08 +NULL NULL NULL NULL NULL NULL 145 val_145 2008-04-08 +NULL NULL NULL NULL NULL NULL 146 val_146 2008-04-08 +NULL NULL NULL NULL NULL NULL 146 val_146 2008-04-08 +NULL NULL NULL NULL NULL NULL 149 val_149 2008-04-08 +NULL NULL NULL NULL NULL NULL 149 val_149 2008-04-08 +NULL NULL NULL NULL NULL NULL 15 val_15 2008-04-08 +NULL NULL NULL NULL NULL NULL 15 val_15 2008-04-08 +NULL NULL NULL NULL NULL NULL 150 val_150 2008-04-08 +NULL NULL NULL NULL NULL NULL 152 val_152 2008-04-08 +NULL NULL NULL NULL NULL NULL 152 val_152 2008-04-08 +NULL NULL NULL NULL NULL NULL 153 val_153 2008-04-08 +NULL NULL NULL NULL NULL NULL 155 val_155 2008-04-08 +NULL NULL NULL NULL NULL NULL 156 val_156 2008-04-08 +NULL NULL NULL NULL NULL NULL 157 val_157 2008-04-08 +NULL NULL NULL NULL NULL NULL 158 val_158 2008-04-08 +NULL NULL NULL NULL NULL NULL 160 val_160 2008-04-08 +NULL NULL NULL NULL NULL NULL 162 val_162 2008-04-08 +NULL NULL NULL NULL NULL NULL 163 val_163 2008-04-08 +NULL NULL NULL NULL NULL NULL 164 val_164 2008-04-08 +NULL NULL NULL NULL NULL NULL 164 val_164 2008-04-08 +NULL NULL NULL NULL NULL NULL 165 val_165 2008-04-08 +NULL NULL NULL NULL NULL NULL 165 val_165 2008-04-08 +NULL NULL NULL NULL NULL NULL 166 val_166 2008-04-08 +NULL NULL NULL NULL NULL NULL 167 val_167 2008-04-08 +NULL NULL NULL NULL NULL NULL 167 val_167 2008-04-08 +NULL NULL NULL NULL NULL NULL 167 val_167 2008-04-08 +NULL NULL NULL NULL NULL NULL 168 val_168 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 169 val_169 2008-04-08 +NULL NULL NULL NULL NULL NULL 17 val_17 2008-04-08 +NULL NULL NULL NULL NULL NULL 170 val_170 2008-0
<TRUNCATED>
