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

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

#
text | 183 lines | 173 code | 10 blank | 0 comment | 0 complexity | e8d16ede587d9e4639bf2a019fb814ab MD5 | raw file
  1PREHOOK: query: explain
  2select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
  3PREHOOK: type: QUERY
  4POSTHOOK: query: explain
  5select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL x) value))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL x) value) 5)))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) key) 9999))))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-0 is a root stage
 13
 14STAGE PLANS:
 15  Stage: Stage-1
 16    Map Reduce
 17      Alias -> Map Operator Tree:
 18        x 
 19          TableScan
 20            alias: x
 21            Filter Operator
 22              predicate:
 23                  expr: (key = 9999)
 24                  type: boolean
 25              Filter Operator
 26                predicate:
 27                    expr: (key = 9999)
 28                    type: boolean
 29                Select Operator
 30                  expressions:
 31                        expr: value
 32                        type: string
 33                  outputColumnNames: value
 34                  Group By Operator
 35                    aggregations:
 36                          expr: count(1)
 37                          expr: count(DISTINCT value)
 38                          expr: count(DISTINCT substr(value, 5))
 39                    bucketGroup: false
 40                    keys:
 41                          expr: value
 42                          type: string
 43                          expr: substr(value, 5)
 44                          type: string
 45                    mode: hash
 46                    outputColumnNames: _col0, _col1, _col2, _col3, _col4
 47                    Reduce Output Operator
 48                      key expressions:
 49                            expr: _col0
 50                            type: string
 51                            expr: _col1
 52                            type: string
 53                      sort order: ++
 54                      tag: -1
 55                      value expressions:
 56                            expr: _col2
 57                            type: bigint
 58                            expr: _col3
 59                            type: bigint
 60                            expr: _col4
 61                            type: bigint
 62      Reduce Operator Tree:
 63        Group By Operator
 64          aggregations:
 65                expr: count(VALUE._col0)
 66                expr: count(DISTINCT KEY._col0:0._col0)
 67                expr: count(DISTINCT KEY._col0:1._col0)
 68          bucketGroup: false
 69          mode: mergepartial
 70          outputColumnNames: _col0, _col1, _col2
 71          Select Operator
 72            expressions:
 73                  expr: _col0
 74                  type: bigint
 75                  expr: _col1
 76                  type: bigint
 77                  expr: _col2
 78                  type: bigint
 79            outputColumnNames: _col0, _col1, _col2
 80            File Output Operator
 81              compressed: false
 82              GlobalTableId: 0
 83              table:
 84                  input format: org.apache.hadoop.mapred.TextInputFormat
 85                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 86
 87  Stage: Stage-0
 88    Fetch Operator
 89      limit: -1
 90
 91
 92PREHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
 93PREHOOK: type: QUERY
 94PREHOOK: Input: default@src
 95PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-27_281_6261349366093864618/-mr-10000
 96POSTHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
 97POSTHOOK: type: QUERY
 98POSTHOOK: Input: default@src
 99POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-27_281_6261349366093864618/-mr-10000
1000	0	0
101PREHOOK: query: explain
102select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
103PREHOOK: type: QUERY
104POSTHOOK: query: explain
105select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
106POSTHOOK: type: QUERY
107ABSTRACT SYNTAX TREE:
108  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL x) value))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL x) value) 5)))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) key) 9999))))
109
110STAGE DEPENDENCIES:
111  Stage-1 is a root stage
112  Stage-0 is a root stage
113
114STAGE PLANS:
115  Stage: Stage-1
116    Map Reduce
117      Alias -> Map Operator Tree:
118        x 
119          TableScan
120            alias: x
121            Filter Operator
122              predicate:
123                  expr: (key = 9999)
124                  type: boolean
125              Filter Operator
126                predicate:
127                    expr: (key = 9999)
128                    type: boolean
129                Select Operator
130                  expressions:
131                        expr: value
132                        type: string
133                  outputColumnNames: value
134                  Reduce Output Operator
135                    key expressions:
136                          expr: value
137                          type: string
138                          expr: substr(value, 5)
139                          type: string
140                    sort order: ++
141                    tag: -1
142                    value expressions:
143                          expr: 1
144                          type: int
145      Reduce Operator Tree:
146        Group By Operator
147          aggregations:
148                expr: count(VALUE._col0)
149                expr: count(DISTINCT KEY._col0:0._col0)
150                expr: count(DISTINCT KEY._col0:1._col0)
151          bucketGroup: false
152          mode: complete
153          outputColumnNames: _col0, _col1, _col2
154          Select Operator
155            expressions:
156                  expr: _col0
157                  type: bigint
158                  expr: _col1
159                  type: bigint
160                  expr: _col2
161                  type: bigint
162            outputColumnNames: _col0, _col1, _col2
163            File Output Operator
164              compressed: false
165              GlobalTableId: 0
166              table:
167                  input format: org.apache.hadoop.mapred.TextInputFormat
168                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
169
170  Stage: Stage-0
171    Fetch Operator
172      limit: -1
173
174
175PREHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
176PREHOOK: type: QUERY
177PREHOOK: Input: default@src
178PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-30_870_1082986772406527025/-mr-10000
179POSTHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
180POSTHOOK: type: QUERY
181POSTHOOK: Input: default@src
182POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-30_870_1082986772406527025/-mr-10000
1830	0	0