You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/01/07 22:54:39 UTC
svn commit: r897026 [4/4] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,78 @@
+PREHOOK: query: DESCRIBE FUNCTION minute
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION minute
+POSTHOOK: type: DESCFUNCTION
+minute(date) - Returns the minute of date
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED minute
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED minute
+POSTHOOK: type: DESCFUNCTION
+minute(date) - Returns the minute of date
+date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
+Example:
+ > SELECT minute('2009-07-30 12:58:59') FROM src LIMIT 1;
+ 58
+ > SELECT minute('12:58:59') FROM src LIMIT 1;
+ 58
+PREHOOK: query: EXPLAIN
+SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
+FROM src WHERE key = 86
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: minute('2009-08-07 13:14:15')
+ type: int
+ expr: minute('13:14:15')
+ type: int
+ expr: minute('2009-08-07')
+ type: int
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/113919951/10000
+POSTHOOK: query: SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
+FROM src WHERE key = 86
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/113919951/10000
+14 14 NULL
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_modulo.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_modulo.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_modulo.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_modulo.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION %
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION %
+POSTHOOK: type: DESCFUNCTION
+a % b - Returns the remainder when dividing a by b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED %
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED %
+POSTHOOK: type: DESCFUNCTION
+a % b - Returns the remainder when dividing a by b
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_month.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_month.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_month.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_month.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION minute
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION minute
+POSTHOOK: type: DESCFUNCTION
+minute(date) - Returns the minute of date
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED minute
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED minute
+POSTHOOK: type: DESCFUNCTION
+minute(date) - Returns the minute of date
+date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
+Example:
+ > SELECT minute('2009-07-30 12:58:59') FROM src LIMIT 1;
+ 58
+ > SELECT minute('12:58:59') FROM src LIMIT 1;
+ 58
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out Thu Jan 7 21:54:33 2010
@@ -8,57 +8,69 @@
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED negative
POSTHOOK: type: DESCFUNCTION
negative a - Returns -a
+PREHOOK: query: -- synonym
+DESCRIBE FUNCTION -
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: -- synonym
+DESCRIBE FUNCTION -
+POSTHOOK: type: DESCFUNCTION
+a - b - Returns the difference a-b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED -
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED -
+POSTHOOK: type: DESCFUNCTION
+a - b - Returns the difference a-b
PREHOOK: query: select - null from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1255375616/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1454545320/10000
POSTHOOK: query: select - null from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1255375616/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1454545320/10000
NULL
PREHOOK: query: select - cast(null as int) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/925422494/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1079502691/10000
POSTHOOK: query: select - cast(null as int) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/925422494/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1079502691/10000
NULL
PREHOOK: query: select - cast(null as smallint) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/75605941/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/224532150/10000
POSTHOOK: query: select - cast(null as smallint) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/75605941/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/224532150/10000
NULL
PREHOOK: query: select - cast(null as bigint) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/914031656/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1782782294/10000
POSTHOOK: query: select - cast(null as bigint) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/914031656/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1782782294/10000
NULL
PREHOOK: query: select - cast(null as double) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/551335924/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/19357445/10000
POSTHOOK: query: select - cast(null as double) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/551335924/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/19357445/10000
NULL
PREHOOK: query: select - cast(null as float) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/708448995/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1723958918/10000
POSTHOOK: query: select - cast(null as float) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/708448995/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1723958918/10000
NULL
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,24 @@
+PREHOOK: query: DESCRIBE FUNCTION not
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION not
+POSTHOOK: type: DESCFUNCTION
+not a - Logical not
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED not
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED not
+POSTHOOK: type: DESCFUNCTION
+not a - Logical not
+Synonyms: !
+PREHOOK: query: -- synonym
+DESCRIBE FUNCTION !
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: -- synonym
+DESCRIBE FUNCTION !
+POSTHOOK: type: DESCFUNCTION
+! a - Logical not
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED !
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED !
+POSTHOOK: type: DESCFUNCTION
+! a - Logical not
+Synonyms: not
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,1146 @@
+PREHOOK: query: DESCRIBE FUNCTION <>
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION <>
+POSTHOOK: type: DESCFUNCTION
+a <> b - Returns TRUE if a is not equal to b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED <>
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <>
+POSTHOOK: type: DESCFUNCTION
+a <> b - Returns TRUE if a is not equal to b
+Synonyms: !=
+PREHOOK: query: DESCRIBE FUNCTION !=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION !=
+POSTHOOK: type: DESCFUNCTION
+a != b - Returns TRUE if a is not equal to b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED !=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED !=
+POSTHOOK: type: DESCFUNCTION
+a != b - Returns TRUE if a is not equal to b
+Synonyms: <>
+PREHOOK: query: EXPLAIN
+SELECT key, value
+FROM src
+WHERE key <> '302'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT key, value
+FROM src
+WHERE key <> '302'
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_WHERE (<> (TOK_TABLE_OR_COL key) '302'))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key <> '302')
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (key <> '302')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT key, value
+FROM src
+WHERE key <> '302'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/250131163/10000
+POSTHOOK: query: SELECT key, value
+FROM src
+WHERE key <> '302'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/250131163/10000
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
+PREHOOK: query: EXPLAIN
+SELECT key, value
+FROM src
+WHERE key != '302'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT key, value
+FROM src
+WHERE key != '302'
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_WHERE (!= (TOK_TABLE_OR_COL key) '302'))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key <> '302')
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (key <> '302')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT key, value
+FROM src
+WHERE key != '302'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/414907244/10000
+POSTHOOK: query: SELECT key, value
+FROM src
+WHERE key != '302'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/414907244/10000
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_or.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_or.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_or.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_or.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION or
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION or
+POSTHOOK: type: DESCFUNCTION
+a or b - Logical or
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED or
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED or
+POSTHOOK: type: DESCFUNCTION
+a or b - Logical or
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,22 @@
+PREHOOK: query: DESCRIBE FUNCTION positive
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION positive
+POSTHOOK: type: DESCFUNCTION
+positive a - Returns a
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED positive
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED positive
+POSTHOOK: type: DESCFUNCTION
+positive a - Returns a
+PREHOOK: query: -- synonym
+DESCRIBE FUNCTION +
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: -- synonym
+DESCRIBE FUNCTION +
+POSTHOOK: type: DESCFUNCTION
+a + b - Returns a+b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED +
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED +
+POSTHOOK: type: DESCFUNCTION
+a + b - Returns a+b
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pow.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pow.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pow.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pow.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+PREHOOK: query: DESCRIBE FUNCTION pow
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION pow
+POSTHOOK: type: DESCFUNCTION
+pow(x1, x2) - raise x1 to the power of x2
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED pow
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED pow
+POSTHOOK: type: DESCFUNCTION
+pow(x1, x2) - raise x1 to the power of x2
+Synonyms: power
+Example:
+ > SELECT pow(2, 3) FROM src LIMIT 1;
+ 8
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_power.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_power.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_power.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_power.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+PREHOOK: query: DESCRIBE FUNCTION power
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION power
+POSTHOOK: type: DESCFUNCTION
+power(x1, x2) - raise x1 to the power of x2
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED power
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED power
+POSTHOOK: type: DESCFUNCTION
+power(x1, x2) - raise x1 to the power of x2
+Synonyms: pow
+Example:
+ > SELECT power(2, 3) FROM src LIMIT 1;
+ 8
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rand.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rand.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rand.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rand.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION rand
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rand
+POSTHOOK: type: DESCFUNCTION
+rand([seed]) - Returns a pseudorandom number between 0 and 1
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rand
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rand
+POSTHOOK: type: DESCFUNCTION
+rand([seed]) - Returns a pseudorandom number between 0 and 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp.q.out Thu Jan 7 21:54:33 2010
@@ -8,6 +8,7 @@
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED regexp
POSTHOOK: type: DESCFUNCTION
str regexp regexp - Returns true if str matches regexp and false otherwise
+Synonyms: rlike
Example:
> SELECT 'fb' regexp '.*' FROM src LIMIT 1;
true
@@ -16,11 +17,11 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/tmp/852993560/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1188479337/10000
POSTHOOK: query: SELECT 'fofo' REGEXP '^fo', 'fo\no' REGEXP '^fo\no$', 'Bn' REGEXP '^Ba*n', 'afofo' REGEXP 'fo',
'afofo' REGEXP '^fo', 'Baan' REGEXP '^Ba?n', 'axe' REGEXP 'pi|apa', 'pip' REGEXP '^(pi)*$'
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/tmp/852993560/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1188479337/10000
true true true true false false false false
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_extract.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_extract.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_extract.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION regexp_extract
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION regexp_extract
+POSTHOOK: type: DESCFUNCTION
+regexp_extract(str, regexp[, idx]) - extracts a group that matches regexp
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_extract
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_extract
+POSTHOOK: type: DESCFUNCTION
+regexp_extract(str, regexp[, idx]) - extracts a group that matches regexp
+Example:
+ > SELECT regexp_extract('100-200', '(\d+)-(\d+)', 1) FROM src LIMIT 1;
+ '100'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_replace.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_replace.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_replace.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_replace.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION regexp_replace
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION regexp_replace
+POSTHOOK: type: DESCFUNCTION
+regexp_replace(str, regexp, rep) - replace all substrings of str that match regexp with rep
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_replace
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_replace
+POSTHOOK: type: DESCFUNCTION
+regexp_replace(str, regexp, rep) - replace all substrings of str that match regexp with rep
+Example:
+ > SELECT regexp_replace('100-200', '(\d+)', 'num') FROM src LIMIT 1;
+ 'num-num'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rlike.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rlike.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rlike.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rlike.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+PREHOOK: query: DESCRIBE FUNCTION rlike
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rlike
+POSTHOOK: type: DESCFUNCTION
+str rlike regexp - Returns true if str matches regexp and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rlike
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rlike
+POSTHOOK: type: DESCFUNCTION
+str rlike regexp - Returns true if str matches regexp and false otherwise
+Synonyms: regexp
+Example:
+ > SELECT 'fb' rlike '.*' FROM src LIMIT 1;
+ true
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rpad.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rpad.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rpad.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rpad.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,80 @@
+PREHOOK: query: DESCRIBE FUNCTION rpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rpad
+POSTHOOK: type: DESCFUNCTION
+rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
+POSTHOOK: type: DESCFUNCTION
+rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
+If str is longer than len, the return value is shortened to len characters.
+Example:
+ > SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
+ 'hi???' > SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
+ 'h'
+PREHOOK: query: EXPLAIN SELECT
+ rpad('hi', 1, '?'),
+ rpad('hi', 5, '.'),
+ rpad('hi', 6, '123')
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT
+ rpad('hi', 1, '?'),
+ rpad('hi', 5, '.'),
+ rpad('hi', 6, '123')
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 6 '123'))) (TOK_LIMIT 1)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Select Operator
+ expressions:
+ expr: rpad('hi', 1, '?')
+ type: string
+ expr: rpad('hi', 5, '.')
+ type: string
+ expr: rpad('hi', 6, '123')
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 1
+
+
+PREHOOK: query: SELECT
+ rpad('hi', 1, '?'),
+ rpad('hi', 5, '.'),
+ rpad('hi', 6, '123')
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/523452931/10000
+POSTHOOK: query: SELECT
+ rpad('hi', 1, '?'),
+ rpad('hi', 5, '.'),
+ rpad('hi', 6, '123')
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/523452931/10000
+h hi... hi1231
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rtrim.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rtrim.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rtrim.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rtrim.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION rtrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rtrim
+POSTHOOK: type: DESCFUNCTION
+rtrim(str) - Removes the trailing space characters from str
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rtrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rtrim
+POSTHOOK: type: DESCFUNCTION
+rtrim(str) - Removes the trailing space characters from str
+Example:
+ > SELECT rtrim('facebook ') FROM src LIMIT 1;
+ 'facebook'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_second.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_second.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_second.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_second.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,78 @@
+PREHOOK: query: DESCRIBE FUNCTION second
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION second
+POSTHOOK: type: DESCFUNCTION
+second(date) - Returns the second of date
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED second
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED second
+POSTHOOK: type: DESCFUNCTION
+second(date) - Returns the second of date
+date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
+Example:
+ > SELECT second('2009-07-30 12:58:59') FROM src LIMIT 1;
+ 59
+ > SELECT second('12:58:59') FROM src LIMIT 1;
+ 59
+PREHOOK: query: EXPLAIN
+SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION second '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION second '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION second '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: second('2009-08-07 13:14:15')
+ type: int
+ expr: second('13:14:15')
+ type: int
+ expr: second('2009-08-07')
+ type: int
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1610069945/10000
+POSTHOOK: query: SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1610069945/10000
+15 15 NULL
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_smallint.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_smallint.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_smallint.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_smallint.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION smallint
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION smallint
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'smallint'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED smallint
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED smallint
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'smallint'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sqrt.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sqrt.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sqrt.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sqrt.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION sqrt
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION sqrt
+POSTHOOK: type: DESCFUNCTION
+sqrt(x) - returns the square root of x
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED sqrt
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sqrt
+POSTHOOK: type: DESCFUNCTION
+sqrt(x) - returns the square root of x
+Example:
+ > SELECT sqrt(4) FROM src LIMIT 1;
+ 2
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_std.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_std.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_std.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_std.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,11 @@
+PREHOOK: query: DESCRIBE FUNCTION std
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION std
+POSTHOOK: type: DESCFUNCTION
+std(x) - Returns the standard deviation of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED std
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED std
+POSTHOOK: type: DESCFUNCTION
+std(x) - Returns the standard deviation of a set of numbers
+Synonyms: stddev_pop, stddev
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,11 @@
+PREHOOK: query: DESCRIBE FUNCTION stddev
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION stddev
+POSTHOOK: type: DESCFUNCTION
+stddev(x) - Returns the standard deviation of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
+POSTHOOK: type: DESCFUNCTION
+stddev(x) - Returns the standard deviation of a set of numbers
+Synonyms: stddev_pop, std
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_pop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_pop.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_pop.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_pop.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION udf_stddev_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION udf_stddev_pop
+POSTHOOK: type: DESCFUNCTION
+Function 'udf_stddev_pop' does not exist.
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED udf_stddev_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED udf_stddev_pop
+POSTHOOK: type: DESCFUNCTION
+Function 'udf_stddev_pop' does not exist.
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_samp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_samp.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_samp.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_samp.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,20 @@
+PREHOOK: query: DESCRIBE FUNCTION stddev_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION stddev_samp
+POSTHOOK: type: DESCFUNCTION
+stddev_samp(x) - Returns the sample standard deviation of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
+POSTHOOK: type: DESCFUNCTION
+stddev_samp(x) - Returns the sample standard deviation of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION stddev_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION stddev_samp
+POSTHOOK: type: DESCFUNCTION
+stddev_samp(x) - Returns the sample standard deviation of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
+POSTHOOK: type: DESCFUNCTION
+stddev_samp(x) - Returns the sample standard deviation of a set of numbers
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_string.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_string.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_string.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_string.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION string
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION string
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'string'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED string
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED string
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'string'
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out Thu Jan 7 21:54:33 2010
@@ -8,6 +8,7 @@
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED substr
POSTHOOK: type: DESCFUNCTION
substr(str, pos[, len]) - returns the substring of str that starts at pos and is of length len
+Synonyms: substring
pos is a 1-based index. If pos<0 the starting position is determined by counting backwards from the end of str.
Example:
> SELECT substr('Facebook', 5) FROM src LIMIT 1;
@@ -23,7 +24,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/385391222/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1212301644/10000
POSTHOOK: query: SELECT
substr(null, 1), substr(null, 1, 1),
substr('ABC', null), substr('ABC', null, 1),
@@ -31,7 +32,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/385391222/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1212301644/10000
NULL NULL NULL NULL NULL
PREHOOK: query: SELECT
substr('ABC', 1, 0), substr('ABC', 1, -1), substr('ABC', 2, -100),
@@ -43,7 +44,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1555439693/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/975822262/10000
POSTHOOK: query: SELECT
substr('ABC', 1, 0), substr('ABC', 1, -1), substr('ABC', 2, -100),
substr('ABC', 4), substr('ABC', 4, 100),
@@ -54,7 +55,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1555439693/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/975822262/10000
PREHOOK: query: SELECT
substr('ABCDEFG', 3, 4), substr('ABCDEFG', -5, 4),
@@ -65,7 +66,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1351450825/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/967105187/10000
POSTHOOK: query: SELECT
substr('ABCDEFG', 3, 4), substr('ABCDEFG', -5, 4),
substr('ABCDEFG', 3), substr('ABCDEFG', -5),
@@ -75,7 +76,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1351450825/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/967105187/10000
CDEF CDEF CDEFG CDEFG ABC ABC BC C ABC BC A A A
PREHOOK: query: SELECT
substr('ABC', 0, 1), substr('ABC', 0, 2), substr('ABC', 0, 3), substr('ABC', 0, 4),
@@ -86,7 +87,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1909380959/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/459634365/10000
POSTHOOK: query: SELECT
substr('ABC', 0, 1), substr('ABC', 0, 2), substr('ABC', 0, 3), substr('ABC', 0, 4),
substr('ABC', 1, 1), substr('ABC', 1, 2), substr('ABC', 1, 3), substr('ABC', 1, 4),
@@ -96,7 +97,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1909380959/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/459634365/10000
A AB ABC ABC A AB ABC ABC B BC BC BC C C C C
PREHOOK: query: SELECT
substr('ABC', -1, 1), substr('ABC', -1, 2), substr('ABC', -1, 3), substr('ABC', -1, 4),
@@ -106,7 +107,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/606649550/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/563894102/10000
POSTHOOK: query: SELECT
substr('ABC', -1, 1), substr('ABC', -1, 2), substr('ABC', -1, 3), substr('ABC', -1, 4),
substr('ABC', -2, 1), substr('ABC', -2, 2), substr('ABC', -2, 3), substr('ABC', -2, 4),
@@ -115,7 +116,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/606649550/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/563894102/10000
C C C C B BC BC BC A AB ABC ABC
PREHOOK: query: -- substring() is a synonim of substr(), so just perform some basic tests
SELECT
@@ -127,7 +128,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1053388822/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/833687667/10000
POSTHOOK: query: -- substring() is a synonim of substr(), so just perform some basic tests
SELECT
substring('ABCDEFG', 3, 4), substring('ABCDEFG', -5, 4),
@@ -138,5 +139,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1053388822/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/833687667/10000
CDEF CDEF CDEFG CDEFG ABC ABC BC C ABC BC A A A
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substring.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substring.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substring.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substring.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,21 @@
+PREHOOK: query: -- Synonym. See udf_substr.q
+DESCRIBE FUNCTION substring
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: -- Synonym. See udf_substr.q
+DESCRIBE FUNCTION substring
+POSTHOOK: type: DESCFUNCTION
+substring(str, pos[, len]) - returns the substring of str that starts at pos and is of length len
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED substring
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED substring
+POSTHOOK: type: DESCFUNCTION
+substring(str, pos[, len]) - returns the substring of str that starts at pos and is of length len
+Synonyms: substr
+pos is a 1-based index. If pos<0 the starting position is determined by counting backwards from the end of str.
+Example:
+ > SELECT substring('Facebook', 5) FROM src LIMIT 1;
+ 'book'
+ > SELECT substring('Facebook', -5) FROM src LIMIT 1;
+ 'ebook'
+ > SELECT substring('Facebook', 5, 1) FROM src LIMIT 1;
+ 'b'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_subtract.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_subtract.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_subtract.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_subtract.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION -
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION -
+POSTHOOK: type: DESCFUNCTION
+a - b - Returns the difference a-b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED -
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED -
+POSTHOOK: type: DESCFUNCTION
+a - b - Returns the difference a-b
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sum.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sum.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sum.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sum.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,20 @@
+PREHOOK: query: DESCRIBE FUNCTION sum
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION sum
+POSTHOOK: type: DESCFUNCTION
+sum(x) - Returns the sum of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED sum
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sum
+POSTHOOK: type: DESCFUNCTION
+sum(x) - Returns the sum of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION sum
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION sum
+POSTHOOK: type: DESCFUNCTION
+sum(x) - Returns the sum of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED sum
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sum
+POSTHOOK: type: DESCFUNCTION
+sum(x) - Returns the sum of a set of numbers
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_tinyint.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_tinyint.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_tinyint.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_tinyint.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION tinyint
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION tinyint
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'tinyint'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED tinyint
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED tinyint
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'tinyint'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_to_date.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_to_date.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_to_date.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_to_date.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION to_date
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION to_date
+POSTHOOK: type: DESCFUNCTION
+to_date(expr) - Extracts the date part of the date or datetime expression expr
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED to_date
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED to_date
+POSTHOOK: type: DESCFUNCTION
+to_date(expr) - Extracts the date part of the date or datetime expression expr
+Example:
+ > SELECT to_date('2009-30-07 04:17:52') FROM src LIMIT 1;
+ '2009-30-07'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_trim.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_trim.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_trim.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_trim.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION trim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION trim
+POSTHOOK: type: DESCFUNCTION
+trim(str) - Removes the leading and trailing space characters from str
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED trim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED trim
+POSTHOOK: type: DESCFUNCTION
+trim(str) - Removes the leading and trailing space characters from str
+Example:
+ > SELECT trim(' facebook ') FROM src LIMIT 1;
+ 'facebook'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ucase.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ucase.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ucase.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ucase.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+PREHOOK: query: DESCRIBE FUNCTION ucase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ucase
+POSTHOOK: type: DESCFUNCTION
+ucase(str) - Returns str with all characters changed to uppercase
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ucase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ucase
+POSTHOOK: type: DESCFUNCTION
+ucase(str) - Returns str with all characters changed to uppercase
+Synonyms: upper
+Example:
+ > SELECT ucase('Facebook') FROM src LIMIT 1;
+ 'FACEBOOK'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_upper.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_upper.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_upper.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_upper.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+PREHOOK: query: DESCRIBE FUNCTION upper
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION upper
+POSTHOOK: type: DESCFUNCTION
+upper(str) - Returns str with all characters changed to uppercase
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED upper
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED upper
+POSTHOOK: type: DESCFUNCTION
+upper(str) - Returns str with all characters changed to uppercase
+Synonyms: ucase
+Example:
+ > SELECT upper('Facebook') FROM src LIMIT 1;
+ 'FACEBOOK'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_pop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_pop.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_pop.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_pop.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,11 @@
+PREHOOK: query: DESCRIBE FUNCTION var_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION var_pop
+POSTHOOK: type: DESCFUNCTION
+var_pop(x) - Returns the variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
+POSTHOOK: type: DESCFUNCTION
+var_pop(x) - Returns the variance of a set of numbers
+Synonyms: variance
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_samp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_samp.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_samp.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_samp.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,20 @@
+PREHOOK: query: DESCRIBE FUNCTION var_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION var_samp
+POSTHOOK: type: DESCFUNCTION
+var_samp(x) - Returns the sample variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
+POSTHOOK: type: DESCFUNCTION
+var_samp(x) - Returns the sample variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION var_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION var_samp
+POSTHOOK: type: DESCFUNCTION
+var_samp(x) - Returns the sample variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
+POSTHOOK: type: DESCFUNCTION
+var_samp(x) - Returns the sample variance of a set of numbers
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_variance.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_variance.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_variance.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_variance.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,44 @@
+PREHOOK: query: DESCRIBE FUNCTION variance
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION variance
+POSTHOOK: type: DESCFUNCTION
+variance(x) - Returns the variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED variance
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED variance
+POSTHOOK: type: DESCFUNCTION
+variance(x) - Returns the variance of a set of numbers
+Synonyms: var_pop
+PREHOOK: query: DESCRIBE FUNCTION var_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION var_pop
+POSTHOOK: type: DESCFUNCTION
+var_pop(x) - Returns the variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
+POSTHOOK: type: DESCFUNCTION
+var_pop(x) - Returns the variance of a set of numbers
+Synonyms: variance
+PREHOOK: query: DESCRIBE FUNCTION variance
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION variance
+POSTHOOK: type: DESCFUNCTION
+variance(x) - Returns the variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED variance
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED variance
+POSTHOOK: type: DESCFUNCTION
+variance(x) - Returns the variance of a set of numbers
+Synonyms: var_pop
+PREHOOK: query: DESCRIBE FUNCTION var_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION var_pop
+POSTHOOK: type: DESCFUNCTION
+var_pop(x) - Returns the variance of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
+POSTHOOK: type: DESCFUNCTION
+var_pop(x) - Returns the variance of a set of numbers
+Synonyms: variance
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out Thu Jan 7 21:54:33 2010
@@ -1,3 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION when
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION when
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'when'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED when
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED when
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'when'
PREHOOK: query: EXPLAIN
SELECT CASE
WHEN 1=1 THEN 2
@@ -124,7 +134,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1103797531/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/260148553/10000
POSTHOOK: query: SELECT CASE
WHEN 1=1 THEN 2
WHEN 1=3 THEN 4
@@ -153,5 +163,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1103797531/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/260148553/10000
2 9 14 NULL 24 NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out Thu Jan 7 21:54:33 2010
@@ -1,298 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION explode
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION explode
-POSTHOOK: type: DESCFUNCTION
-explode(a) - separates the elements of array a into multiple rows
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED explode
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED explode
-POSTHOOK: type: DESCFUNCTION
-explode(a) - separates the elements of array a into multiple rows
-PREHOOK: query: EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION explode (TOK_FUNCTION array 1 2 3)) myCol)) (TOK_LIMIT 3)))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: array(1,2,3)
- type: array<int>
- outputColumnNames: _col0
- UDTF Operator
- function name: explode
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1666222499/10001
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- columns col
- serialization.format 1
- columns.types int
- Needs Tagging: false
- Path -> Alias:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src [src]
- Path -> Partition:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src
- Partition
- base file name: src
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name src
- columns.types string:string
- serialization.ddl struct src { string key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1262809225
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name src
- columns.types string:string
- serialization.ddl struct src { string key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1262809225
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: src
- name: src
-
- Stage: Stage-0
- Fetch Operator
- limit: 3
-
-
-PREHOOK: query: EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION explode (TOK_FUNCTION array 1 2 3)) myCol)) (TOK_LIMIT 3))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) myCol)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL a) myCol))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- a:src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: array(1,2,3)
- type: array<int>
- outputColumnNames: _col0
- UDTF Operator
- function name: explode
- Limit
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: col
- type: int
- Needs Tagging: false
- Path -> Alias:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src [a:src]
- Path -> Partition:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src
- Partition
- base file name: src
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name src
- columns.types string:string
- serialization.ddl struct src { string key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1262809225
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name src
- columns.types string:string
- serialization.ddl struct src { string key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/carl/Projects/hd9/hive-trunk/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1262809225
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: src
- name: src
- Reduce Operator Tree:
- Extract
- Limit
- Select Operator
- expressions:
- expr: _col0
- type: int
- outputColumnNames: _col0
- Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- keys:
- expr: _col0
- type: int
- mode: hash
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/894782310/10002
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1
- columns.types int,bigint
- escape.delim \
-
- Stage: Stage-2
- Map Reduce
- Alias -> Map Operator Tree:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/894782310/10002
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: int
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
- Needs Tagging: false
- Path -> Alias:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/894782310/10002 [file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/894782310/10002]
- Path -> Partition:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/894782310/10002
- Partition
- base file name: 10002
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1
- columns.types int,bigint
- escape.delim \
-
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1
- columns.types int,bigint
- escape.delim \
- Reduce Operator Tree:
- Group By Operator
- aggregations:
- expr: count(VALUE._col0)
- bucketGroup: false
- keys:
- expr: KEY._col0
- type: int
- mode: mergepartial
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/894782310/10001
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- columns _col0,_col1
- serialization.format 1
- columns.types int:bigint
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
-
-
-PREHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/882248436/10000
-POSTHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/882248436/10000
-1
-2
-3
-PREHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1127088300/10000
-POSTHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1127088300/10000
-1
-2
-3
-PREHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1245396324/10000
-POSTHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1245396324/10000
-1 1
-2 1
-3 1