PageRenderTime 17ms CodeModel.GetById 10ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 129 lines | 124 code | 5 blank | 0 comment | 0 complexity | edb752b73d6050f51d3ef2b241c84bc1 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2 FROM 
  3  src a
  4 LEFT OUTER JOIN 
  5  src b 
  6 ON (a.key = b.key)
  7 SELECT a.key, a.value, b.key, b.value
  8 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
  9PREHOOK: type: QUERY
 10POSTHOOK: query: EXPLAIN
 11 FROM 
 12  src a
 13 LEFT OUTER JOIN 
 14  src b 
 15 ON (a.key = b.key)
 16 SELECT a.key, a.value, b.key, b.value
 17 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 18POSTHOOK: type: QUERY
 19ABSTRACT SYNTAX TREE:
 20  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME src) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)))))
 21
 22STAGE DEPENDENCIES:
 23  Stage-1 is a root stage
 24  Stage-0 is a root stage
 25
 26STAGE PLANS:
 27  Stage: Stage-1
 28    Map Reduce
 29      Alias -> Map Operator Tree:
 30        a 
 31          TableScan
 32            alias: a
 33            Filter Operator
 34              predicate:
 35                  expr: ((key > 10) and (key < 20))
 36                  type: boolean
 37              Reduce Output Operator
 38                key expressions:
 39                      expr: key
 40                      type: string
 41                sort order: +
 42                Map-reduce partition columns:
 43                      expr: key
 44                      type: string
 45                tag: 0
 46                value expressions:
 47                      expr: key
 48                      type: string
 49                      expr: value
 50                      type: string
 51        b 
 52          TableScan
 53            alias: b
 54            Reduce Output Operator
 55              key expressions:
 56                    expr: key
 57                    type: string
 58              sort order: +
 59              Map-reduce partition columns:
 60                    expr: key
 61                    type: string
 62              tag: 1
 63              value expressions:
 64                    expr: key
 65                    type: string
 66                    expr: value
 67                    type: string
 68      Reduce Operator Tree:
 69        Join Operator
 70          condition map:
 71               Left Outer Join0 to 1
 72          condition expressions:
 73            0 {VALUE._col0} {VALUE._col1}
 74            1 {VALUE._col0} {VALUE._col1}
 75          handleSkewJoin: false
 76          outputColumnNames: _col0, _col1, _col4, _col5
 77          Filter Operator
 78            predicate:
 79                expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25))
 80                type: boolean
 81            Select Operator
 82              expressions:
 83                    expr: _col0
 84                    type: string
 85                    expr: _col1
 86                    type: string
 87                    expr: _col4
 88                    type: string
 89                    expr: _col5
 90                    type: string
 91              outputColumnNames: _col0, _col1, _col2, _col3
 92              File Output Operator
 93                compressed: false
 94                GlobalTableId: 0
 95                table:
 96                    input format: org.apache.hadoop.mapred.TextInputFormat
 97                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 98
 99  Stage: Stage-0
100    Fetch Operator
101      limit: -1
102
103
104PREHOOK: query: FROM 
105  src a
106 LEFT OUTER JOIN 
107  src b 
108 ON (a.key = b.key)
109 SELECT a.key, a.value, b.key, b.value
110 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
111PREHOOK: type: QUERY
112PREHOOK: Input: default@src
113PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-57-14_648_6362739881959261544/-mr-10000
114POSTHOOK: query: FROM 
115  src a
116 LEFT OUTER JOIN 
117  src b 
118 ON (a.key = b.key)
119 SELECT a.key, a.value, b.key, b.value
120 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
121POSTHOOK: type: QUERY
122POSTHOOK: Input: default@src
123POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-57-14_648_6362739881959261544/-mr-10000
12417	val_17	17	val_17
12518	val_18	18	val_18
12618	val_18	18	val_18
12718	val_18	18	val_18
12818	val_18	18	val_18
12919	val_19	19	val_19