PageRenderTime 23ms CodeModel.GetById 13ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 159 lines | 153 code | 6 blank | 0 comment | 0 complexity | 1e4aba17e4a2c949bc8764c0533ac17f MD5 | raw file
  1PREHOOK: query: -- scanning un-partitioned data
  2explain extended select * from src where rand(1) < 0.1
  3PREHOOK: type: QUERY
  4POSTHOOK: query: -- scanning un-partitioned data
  5explain extended select * from src where rand(1) < 0.1
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (< (TOK_FUNCTION rand 1) 0.1))))
  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        src 
 19          TableScan
 20            alias: src
 21            GatherStats: false
 22            Filter Operator
 23              isSamplingPred: false
 24              predicate:
 25                  expr: (rand(1) < 0.1)
 26                  type: boolean
 27              Select Operator
 28                expressions:
 29                      expr: key
 30                      type: string
 31                      expr: value
 32                      type: string
 33                outputColumnNames: _col0, _col1
 34                File Output Operator
 35                  compressed: false
 36                  GlobalTableId: 0
 37                  directory: file:/tmp/sdong/hive_2011-02-10_16-59-15_337_3392401522353054315/-ext-10001
 38                  NumFilesPerFileSink: 1
 39                  Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_16-59-15_337_3392401522353054315/-ext-10001/
 40                  table:
 41                      input format: org.apache.hadoop.mapred.TextInputFormat
 42                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 43                      properties:
 44                        columns _col0,_col1
 45                        columns.types string:string
 46                        serialization.format 1
 47                  TotalFiles: 1
 48                  GatherStats: false
 49                  MultiFileSpray: false
 50      Needs Tagging: false
 51      Path -> Alias:
 52        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [src]
 53      Path -> Partition:
 54        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
 55          Partition
 56            base file name: src
 57            input format: org.apache.hadoop.mapred.TextInputFormat
 58            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 59            properties:
 60              bucket_count -1
 61              columns key,value
 62              columns.types string:string
 63              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 64              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 65              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 66              name default.src
 67              serialization.ddl struct src { string key, string value}
 68              serialization.format 1
 69              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 70              transient_lastDdlTime 1297378968
 71            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 72          
 73              input format: org.apache.hadoop.mapred.TextInputFormat
 74              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 75              properties:
 76                bucket_count -1
 77                columns key,value
 78                columns.types string:string
 79                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 80                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 81                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 82                name default.src
 83                serialization.ddl struct src { string key, string value}
 84                serialization.format 1
 85                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 86                transient_lastDdlTime 1297378968
 87              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 88              name: default.src
 89            name: default.src
 90
 91  Stage: Stage-0
 92    Fetch Operator
 93      limit: -1
 94
 95
 96PREHOOK: query: select * from src where rand(1) < 0.1
 97PREHOOK: type: QUERY
 98PREHOOK: Input: default@src
 99PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-59-15_417_3701035171047203208/-mr-10000
100POSTHOOK: query: select * from src where rand(1) < 0.1
101POSTHOOK: type: QUERY
102POSTHOOK: Input: default@src
103POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-59-15_417_3701035171047203208/-mr-10000
104409	val_409
105429	val_429
106209	val_209
107153	val_153
108203	val_203
109170	val_170
110489	val_489
111378	val_378
112221	val_221
113498	val_498
114469	val_469
115176	val_176
116176	val_176
117384	val_384
118217	val_217
119431	val_431
12051	val_51
121288	val_288
122457	val_457
123197	val_197
12477	val_77
125138	val_138
126277	val_277
127224	val_224
128309	val_309
129389	val_389
130331	val_331
131317	val_317
132336	val_336
13342	val_42
134458	val_458
13578	val_78
136453	val_453
13774	val_74
138103	val_103
139467	val_467
140202	val_202
141469	val_469
14244	val_44
143454	val_454
14470	val_70
145491	val_491
146199	val_199
147169	val_169
148310	val_310
149233	val_233
150133	val_133
15126	val_26
152134	val_134
15318	val_18
154298	val_298
155348	val_348
156469	val_469
15737	val_37
158152	val_152
159400	val_400