PageRenderTime 30ms CodeModel.GetById 18ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/join23.q.out

#
text | 226 lines | 220 code | 6 blank | 0 comment | 0 complexity | 2ce7dcc1c499e0977b90e58b369a1381 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2SELECT *  FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
  3PREHOOK: type: QUERY
  4POSTHOOK: query: EXPLAIN
  5SELECT *  FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (< (. (TOK_TABLE_OR_COL src1) key) 10) (< (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)))))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-2 depends on stages: Stage-1
 13  Stage-0 is a root stage
 14
 15STAGE PLANS:
 16  Stage: Stage-1
 17    Map Reduce
 18      Alias -> Map Operator Tree:
 19        src1 
 20          TableScan
 21            alias: src1
 22            Filter Operator
 23              predicate:
 24                  expr: (key < 10)
 25                  type: boolean
 26              Reduce Output Operator
 27                sort order: 
 28                tag: 0
 29                value expressions:
 30                      expr: key
 31                      type: string
 32                      expr: value
 33                      type: string
 34        src2 
 35          TableScan
 36            alias: src2
 37            Filter Operator
 38              predicate:
 39                  expr: (key < 10)
 40                  type: boolean
 41              Reduce Output Operator
 42                sort order: 
 43                tag: 1
 44                value expressions:
 45                      expr: key
 46                      type: string
 47                      expr: value
 48                      type: string
 49      Reduce Operator Tree:
 50        Join Operator
 51          condition map:
 52               Inner Join 0 to 1
 53          condition expressions:
 54            0 {VALUE._col0} {VALUE._col1}
 55            1 {VALUE._col0} {VALUE._col1}
 56          handleSkewJoin: false
 57          outputColumnNames: _col0, _col1, _col4, _col5
 58          Filter Operator
 59            predicate:
 60                expr: ((_col0 < 10) and (_col4 < 10))
 61                type: boolean
 62            Select Operator
 63              expressions:
 64                    expr: _col0
 65                    type: string
 66                    expr: _col1
 67                    type: string
 68                    expr: _col4
 69                    type: string
 70                    expr: _col5
 71                    type: string
 72              outputColumnNames: _col0, _col1, _col2, _col3
 73              File Output Operator
 74                compressed: false
 75                GlobalTableId: 0
 76                table:
 77                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 78                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 79
 80  Stage: Stage-2
 81    Map Reduce
 82      Alias -> Map Operator Tree:
 83        file:/tmp/sdong/hive_2011-02-10_16-03-27_826_409683094596927397/-mr-10002 
 84            Reduce Output Operator
 85              key expressions:
 86                    expr: _col0
 87                    type: string
 88                    expr: _col1
 89                    type: string
 90                    expr: _col2
 91                    type: string
 92                    expr: _col3
 93                    type: string
 94              sort order: ++++
 95              tag: -1
 96              value expressions:
 97                    expr: _col0
 98                    type: string
 99                    expr: _col1
100                    type: string
101                    expr: _col2
102                    type: string
103                    expr: _col3
104                    type: string
105      Reduce Operator Tree:
106        Extract
107          File Output Operator
108            compressed: false
109            GlobalTableId: 0
110            table:
111                input format: org.apache.hadoop.mapred.TextInputFormat
112                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
113
114  Stage: Stage-0
115    Fetch Operator
116      limit: -1
117
118
119PREHOOK: query: SELECT *  FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
120PREHOOK: type: QUERY
121PREHOOK: Input: default@src
122PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-03-27_925_9012046018484050485/-mr-10000
123POSTHOOK: query: SELECT *  FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
124POSTHOOK: type: QUERY
125POSTHOOK: Input: default@src
126POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-03-27_925_9012046018484050485/-mr-10000
1270	val_0	0	val_0
1280	val_0	0	val_0
1290	val_0	0	val_0
1300	val_0	0	val_0
1310	val_0	0	val_0
1320	val_0	0	val_0
1330	val_0	0	val_0
1340	val_0	0	val_0
1350	val_0	0	val_0
1360	val_0	2	val_2
1370	val_0	2	val_2
1380	val_0	2	val_2
1390	val_0	4	val_4
1400	val_0	4	val_4
1410	val_0	4	val_4
1420	val_0	5	val_5
1430	val_0	5	val_5
1440	val_0	5	val_5
1450	val_0	5	val_5
1460	val_0	5	val_5
1470	val_0	5	val_5
1480	val_0	5	val_5
1490	val_0	5	val_5
1500	val_0	5	val_5
1510	val_0	8	val_8
1520	val_0	8	val_8
1530	val_0	8	val_8
1540	val_0	9	val_9
1550	val_0	9	val_9
1560	val_0	9	val_9
1572	val_2	0	val_0
1582	val_2	0	val_0
1592	val_2	0	val_0
1602	val_2	2	val_2
1612	val_2	4	val_4
1622	val_2	5	val_5
1632	val_2	5	val_5
1642	val_2	5	val_5
1652	val_2	8	val_8
1662	val_2	9	val_9
1674	val_4	0	val_0
1684	val_4	0	val_0
1694	val_4	0	val_0
1704	val_4	2	val_2
1714	val_4	4	val_4
1724	val_4	5	val_5
1734	val_4	5	val_5
1744	val_4	5	val_5
1754	val_4	8	val_8
1764	val_4	9	val_9
1775	val_5	0	val_0
1785	val_5	0	val_0
1795	val_5	0	val_0
1805	val_5	0	val_0
1815	val_5	0	val_0
1825	val_5	0	val_0
1835	val_5	0	val_0
1845	val_5	0	val_0
1855	val_5	0	val_0
1865	val_5	2	val_2
1875	val_5	2	val_2
1885	val_5	2	val_2
1895	val_5	4	val_4
1905	val_5	4	val_4
1915	val_5	4	val_4
1925	val_5	5	val_5
1935	val_5	5	val_5
1945	val_5	5	val_5
1955	val_5	5	val_5
1965	val_5	5	val_5
1975	val_5	5	val_5
1985	val_5	5	val_5
1995	val_5	5	val_5
2005	val_5	5	val_5
2015	val_5	8	val_8
2025	val_5	8	val_8
2035	val_5	8	val_8
2045	val_5	9	val_9
2055	val_5	9	val_9
2065	val_5	9	val_9
2078	val_8	0	val_0
2088	val_8	0	val_0
2098	val_8	0	val_0
2108	val_8	2	val_2
2118	val_8	4	val_4
2128	val_8	5	val_5
2138	val_8	5	val_5
2148	val_8	5	val_5
2158	val_8	8	val_8
2168	val_8	9	val_9
2179	val_9	0	val_0
2189	val_9	0	val_0
2199	val_9	0	val_0
2209	val_9	2	val_2
2219	val_9	4	val_4
2229	val_9	5	val_5
2239	val_9	5	val_5
2249	val_9	5	val_5
2259	val_9	8	val_8
2269	val_9	9	val_9