PageRenderTime 22ms CodeModel.GetById 10ms app.highlight 4ms RepoModel.GetById 4ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/symlink_text_input_format.q.out

#
text | 240 lines | 221 code | 19 blank | 0 comment | 0 complexity | 05eea09b87091148051215516c60d2b9 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
  3PREHOOK: type: CREATETABLE
  4POSTHOOK: query: EXPLAIN
  5CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
  6POSTHOOK: type: CREATETABLE
  7ABSTRACT SYNTAX TREE:
  8  (TOK_CREATETABLE (TOK_TABNAME symlink_text_input_format) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_STRING) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEFILEFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'))
  9
 10STAGE DEPENDENCIES:
 11  Stage-0 is a root stage
 12
 13STAGE PLANS:
 14  Stage: Stage-0
 15      Create Table Operator:
 16        Create Table
 17          columns: key string, value string
 18          if not exists: false
 19          input format: org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat
 20          # buckets: -1
 21          output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
 22          name: symlink_text_input_format
 23          isExternal: false
 24
 25
 26PREHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
 27PREHOOK: type: CREATETABLE
 28POSTHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
 29POSTHOOK: type: CREATETABLE
 30POSTHOOK: Output: default@symlink_text_input_format
 31PREHOOK: query: EXPLAIN SELECT * FROM symlink_text_input_format order by key, value
 32PREHOOK: type: QUERY
 33POSTHOOK: query: EXPLAIN SELECT * FROM symlink_text_input_format order by key, value
 34POSTHOOK: type: QUERY
 35ABSTRACT SYNTAX TREE:
 36  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME symlink_text_input_format))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value)))))
 37
 38STAGE DEPENDENCIES:
 39  Stage-1 is a root stage
 40  Stage-0 is a root stage
 41
 42STAGE PLANS:
 43  Stage: Stage-1
 44    Map Reduce
 45      Alias -> Map Operator Tree:
 46        symlink_text_input_format 
 47          TableScan
 48            alias: symlink_text_input_format
 49            Select Operator
 50              expressions:
 51                    expr: key
 52                    type: string
 53                    expr: value
 54                    type: string
 55              outputColumnNames: _col0, _col1
 56              Reduce Output Operator
 57                key expressions:
 58                      expr: _col0
 59                      type: string
 60                      expr: _col1
 61                      type: string
 62                sort order: ++
 63                tag: -1
 64                value expressions:
 65                      expr: _col0
 66                      type: string
 67                      expr: _col1
 68                      type: string
 69      Reduce Operator Tree:
 70        Extract
 71          File Output Operator
 72            compressed: false
 73            GlobalTableId: 0
 74            table:
 75                input format: org.apache.hadoop.mapred.TextInputFormat
 76                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 77
 78  Stage: Stage-0
 79    Fetch Operator
 80      limit: -1
 81
 82
 83PREHOOK: query: SELECT * FROM symlink_text_input_format order by key, value
 84PREHOOK: type: QUERY
 85PREHOOK: Input: default@symlink_text_input_format
 86PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-10_305_4117602077727755730/-mr-10000
 87POSTHOOK: query: SELECT * FROM symlink_text_input_format order by key, value
 88POSTHOOK: type: QUERY
 89POSTHOOK: Input: default@symlink_text_input_format
 90POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-10_305_4117602077727755730/-mr-10000
 911	11
 922	12
 932	12
 942	22
 953	13
 963	13
 974	14
 984	14
 995	15
1006	16
1017	17
1027	17
1038	18
1048	18
1058	18
1068	28
107PREHOOK: query: EXPLAIN SELECT value FROM symlink_text_input_format order by value
108PREHOOK: type: QUERY
109POSTHOOK: query: EXPLAIN SELECT value FROM symlink_text_input_format order by value
110POSTHOOK: type: QUERY
111ABSTRACT SYNTAX TREE:
112  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME symlink_text_input_format))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value)))))
113
114STAGE DEPENDENCIES:
115  Stage-1 is a root stage
116  Stage-0 is a root stage
117
118STAGE PLANS:
119  Stage: Stage-1
120    Map Reduce
121      Alias -> Map Operator Tree:
122        symlink_text_input_format 
123          TableScan
124            alias: symlink_text_input_format
125            Select Operator
126              expressions:
127                    expr: value
128                    type: string
129              outputColumnNames: _col0
130              Reduce Output Operator
131                key expressions:
132                      expr: _col0
133                      type: string
134                sort order: +
135                tag: -1
136                value expressions:
137                      expr: _col0
138                      type: string
139      Reduce Operator Tree:
140        Extract
141          File Output Operator
142            compressed: false
143            GlobalTableId: 0
144            table:
145                input format: org.apache.hadoop.mapred.TextInputFormat
146                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
147
148  Stage: Stage-0
149    Fetch Operator
150      limit: -1
151
152
153PREHOOK: query: SELECT value FROM symlink_text_input_format order by value
154PREHOOK: type: QUERY
155PREHOOK: Input: default@symlink_text_input_format
156PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-13_733_1088047071909969175/-mr-10000
157POSTHOOK: query: SELECT value FROM symlink_text_input_format order by value
158POSTHOOK: type: QUERY
159POSTHOOK: Input: default@symlink_text_input_format
160POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-13_733_1088047071909969175/-mr-10000
16111
16212
16312
16413
16513
16614
16714
16815
16916
17017
17117
17218
17318
17418
17522
17628
177PREHOOK: query: EXPLAIN SELECT count(1) FROM symlink_text_input_format
178PREHOOK: type: QUERY
179POSTHOOK: query: EXPLAIN SELECT count(1) FROM symlink_text_input_format
180POSTHOOK: type: QUERY
181ABSTRACT SYNTAX TREE:
182  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME symlink_text_input_format))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
183
184STAGE DEPENDENCIES:
185  Stage-1 is a root stage
186  Stage-0 is a root stage
187
188STAGE PLANS:
189  Stage: Stage-1
190    Map Reduce
191      Alias -> Map Operator Tree:
192        symlink_text_input_format 
193          TableScan
194            alias: symlink_text_input_format
195            Select Operator
196              Group By Operator
197                aggregations:
198                      expr: count(1)
199                bucketGroup: false
200                mode: hash
201                outputColumnNames: _col0
202                Reduce Output Operator
203                  sort order: 
204                  tag: -1
205                  value expressions:
206                        expr: _col0
207                        type: bigint
208      Reduce Operator Tree:
209        Group By Operator
210          aggregations:
211                expr: count(VALUE._col0)
212          bucketGroup: false
213          mode: mergepartial
214          outputColumnNames: _col0
215          Select Operator
216            expressions:
217                  expr: _col0
218                  type: bigint
219            outputColumnNames: _col0
220            File Output Operator
221              compressed: false
222              GlobalTableId: 0
223              table:
224                  input format: org.apache.hadoop.mapred.TextInputFormat
225                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
226
227  Stage: Stage-0
228    Fetch Operator
229      limit: -1
230
231
232PREHOOK: query: SELECT count(1) FROM symlink_text_input_format
233PREHOOK: type: QUERY
234PREHOOK: Input: default@symlink_text_input_format
235PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-17_064_8014152935662500610/-mr-10000
236POSTHOOK: query: SELECT count(1) FROM symlink_text_input_format
237POSTHOOK: type: QUERY
238POSTHOOK: Input: default@symlink_text_input_format
239POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-17_064_8014152935662500610/-mr-10000
24016