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

  1PREHOOK: query: -- no input pruning, sample filter
  2EXPLAIN
  3SELECT s.key
  4FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
  5PREHOOK: type: QUERY
  6POSTHOOK: query: -- no input pruning, sample filter
  7EXPLAIN
  8SELECT s.key
  9FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
 10POSTHOOK: type: QUERY
 11ABSTRACT SYNTAX TREE:
 12  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcbucket) (TOK_TABLEBUCKETSAMPLE 1 5 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s) key)))))
 13
 14STAGE DEPENDENCIES:
 15  Stage-1 is a root stage
 16  Stage-0 is a root stage
 17
 18STAGE PLANS:
 19  Stage: Stage-1
 20    Map Reduce
 21      Alias -> Map Operator Tree:
 22        s 
 23          TableScan
 24            alias: s
 25            Filter Operator
 26              predicate:
 27                  expr: (((hash(key) & 2147483647) % 5) = 0)
 28                  type: boolean
 29              Select Operator
 30                expressions:
 31                      expr: key
 32                      type: int
 33                outputColumnNames: _col0
 34                File Output Operator
 35                  compressed: false
 36                  GlobalTableId: 0
 37                  table:
 38                      input format: org.apache.hadoop.mapred.TextInputFormat
 39                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 40
 41  Stage: Stage-0
 42    Fetch Operator
 43      limit: -1
 44
 45
 46PREHOOK: query: SELECT s.key
 47FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
 48PREHOOK: type: QUERY
 49PREHOOK: Input: default@srcbucket
 50PREHOOK: Output: file:/tmp/sdong/hive_2011-04-19_19-54-10_335_2811911774445865646/-mr-10000
 51POSTHOOK: query: SELECT s.key
 52FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
 53POSTHOOK: type: QUERY
 54POSTHOOK: Input: default@srcbucket
 55POSTHOOK: Output: file:/tmp/sdong/hive_2011-04-19_19-54-10_335_2811911774445865646/-mr-10000
 560
 570
 580
 590
 600
 615
 625
 635
 645
 6510
 6610
 6715
 6815
 6915
 7015
 7120
 7220
 7320
 7430
 7530
 7635
 7735
 7835
 7935
 8035
 8135
 8240
 8340
 8450
 8560
 8665
 8765
 8865
 8970
 9070
 9170
 9270
 9375
 9480
 9580
 9685
 9785
 9890
 9990
10090
10195
10295
103100
104100
105100
106100
107105
108105
109105
110110
111120
112120
113120
114125
115125
116125
117135
118135
119135
120140
121145
122150
123155
124160
125160
126165
127165
128165
129170
130170
131175
132175
133175
134175
135180
136185
137190
138195
139195
140200
141200
142205
143205
144205
145215
146230
147230
148230
149230
150230
151235
152235
153240
154245
155245
156255
157255
158260
159260
160260
161265
162265
163265
164275
165275
166275
167280
168280
169285
170285
171295
172295
173300
174300
175305
176305
177310
178310
179310
180310
181315
182325
183325
184330
185335
186335
187335
188340
189345
190355
191355
192360
193360
194365
195375
196375
197375
198375
199375
200375
201385
202385
203390
204390
205390
206395
207395
208395
209395
210400
211405
212410
213415
214425
215430
216430
217430
218430
219435
220435
221440
222440
223450
224450
225455
226455
227455
228460
229470
230470
231475
232475
233480
234480
235480
236480
237480
238485
239485
240485
241490
242490
243495
244495