/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/input16_cc.q.out
text | 528 lines | 526 code | 2 blank | 0 comment | 0 complexity | fc5fc5bce9f65acea0ad6b12a0cff358 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: -- TestSerDe is a user defined serde where the default delimiter is Ctrl-B
- -- the user is overwriting it with ctrlC
- DROP TABLE INPUT16_CC
- PREHOOK: type: DROPTABLE
- POSTHOOK: query: -- TestSerDe is a user defined serde where the default delimiter is Ctrl-B
- -- the user is overwriting it with ctrlC
- DROP TABLE INPUT16_CC
- POSTHOOK: type: DROPTABLE
- PREHOOK: query: CREATE TABLE INPUT16_CC(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' with serdeproperties ('testserde.default.serialization.format'='\003', 'dummy.prop.not.used'='dummyy.val') STORED AS TEXTFILE
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: CREATE TABLE INPUT16_CC(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' with serdeproperties ('testserde.default.serialization.format'='\003', 'dummy.prop.not.used'='dummyy.val') STORED AS TEXTFILE
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@INPUT16_CC
- PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1_cc.txt' INTO TABLE INPUT16_CC
- PREHOOK: type: LOAD
- POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1_cc.txt' INTO TABLE INPUT16_CC
- POSTHOOK: type: LOAD
- POSTHOOK: Output: default@input16_cc
- PREHOOK: query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
- PREHOOK: type: QUERY
- PREHOOK: Input: default@input16_cc
- PREHOOK: Output: hdfs://localhost:55610/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/scratchdir/hive_2011-02-03_13-05-07_586_2987322822515306543/-mr-10000
- POSTHOOK: query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@input16_cc
- POSTHOOK: Output: hdfs://localhost:55610/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/scratchdir/hive_2011-02-03_13-05-07_586_2987322822515306543/-mr-10000
- val_238 238
- val_86 86
- val_311 311
- val_27 27
- val_165 165
- val_409 409
- val_255 255
- val_278 278
- val_98 98
- val_484 484
- val_265 265
- val_193 193
- val_401 401
- val_150 150
- val_273 273
- val_224 224
- val_369 369
- val_66 66
- val_128 128
- val_213 213
- val_146 146
- val_406 406
- val_429 429
- val_374 374
- val_152 152
- val_469 469
- val_145 145
- val_495 495
- val_37 37
- val_327 327
- val_281 281
- val_277 277
- val_209 209
- val_15 15
- val_82 82
- val_403 403
- val_166 166
- val_417 417
- val_430 430
- val_252 252
- val_292 292
- val_219 219
- val_287 287
- val_153 153
- val_193 193
- val_338 338
- val_446 446
- val_459 459
- val_394 394
- val_237 237
- val_482 482
- val_174 174
- val_413 413
- val_494 494
- val_207 207
- val_199 199
- val_466 466
- val_208 208
- val_174 174
- val_399 399
- val_396 396
- val_247 247
- val_417 417
- val_489 489
- val_162 162
- val_377 377
- val_397 397
- val_309 309
- val_365 365
- val_266 266
- val_439 439
- val_342 342
- val_367 367
- val_325 325
- val_167 167
- val_195 195
- val_475 475
- val_17 17
- val_113 113
- val_155 155
- val_203 203
- val_339 339
- val_0 0
- val_455 455
- val_128 128
- val_311 311
- val_316 316
- val_57 57
- val_302 302
- val_205 205
- val_149 149
- val_438 438
- val_345 345
- val_129 129
- val_170 170
- val_20 20
- val_489 489
- val_157 157
- val_378 378
- val_221 221
- val_92 92
- val_111 111
- val_47 47
- val_72 72
- val_4 4
- val_280 280
- val_35 35
- val_427 427
- val_277 277
- val_208 208
- val_356 356
- val_399 399
- val_169 169
- val_382 382
- val_498 498
- val_125 125
- val_386 386
- val_437 437
- val_469 469
- val_192 192
- val_286 286
- val_187 187
- val_176 176
- val_54 54
- val_459 459
- val_51 51
- val_138 138
- val_103 103
- val_239 239
- val_213 213
- val_216 216
- val_430 430
- val_278 278
- val_176 176
- val_289 289
- val_221 221
- val_65 65
- val_318 318
- val_332 332
- val_311 311
- val_275 275
- val_137 137
- val_241 241
- val_83 83
- val_333 333
- val_180 180
- val_284 284
- val_12 12
- val_230 230
- val_181 181
- val_67 67
- val_260 260
- val_404 404
- val_384 384
- val_489 489
- val_353 353
- val_373 373
- val_272 272
- val_138 138
- val_217 217
- val_84 84
- val_348 348
- val_466 466
- val_58 58
- val_8 8
- val_411 411
- val_230 230
- val_208 208
- val_348 348
- val_24 24
- val_463 463
- val_431 431
- val_179 179
- val_172 172
- val_42 42
- val_129 129
- val_158 158
- val_119 119
- val_496 496
- val_0 0
- val_322 322
- val_197 197
- val_468 468
- val_393 393
- val_454 454
- val_100 100
- val_298 298
- val_199 199
- val_191 191
- val_418 418
- val_96 96
- val_26 26
- val_165 165
- val_327 327
- val_230 230
- val_205 205
- val_120 120
- val_131 131
- val_51 51
- val_404 404
- val_43 43
- val_436 436
- val_156 156
- val_469 469
- val_468 468
- val_308 308
- val_95 95
- val_196 196
- val_288 288
- val_481 481
- val_457 457
- val_98 98
- val_282 282
- val_197 197
- val_187 187
- val_318 318
- val_318 318
- val_409 409
- val_470 470
- val_137 137
- val_369 369
- val_316 316
- val_169 169
- val_413 413
- val_85 85
- val_77 77
- val_0 0
- val_490 490
- val_87 87
- val_364 364
- val_179 179
- val_118 118
- val_134 134
- val_395 395
- val_282 282
- val_138 138
- val_238 238
- val_419 419
- val_15 15
- val_118 118
- val_72 72
- val_90 90
- val_307 307
- val_19 19
- val_435 435
- val_10 10
- val_277 277
- val_273 273
- val_306 306
- val_224 224
- val_309 309
- val_389 389
- val_327 327
- val_242 242
- val_369 369
- val_392 392
- val_272 272
- val_331 331
- val_401 401
- val_242 242
- val_452 452
- val_177 177
- val_226 226
- val_5 5
- val_497 497
- val_402 402
- val_396 396
- val_317 317
- val_395 395
- val_58 58
- val_35 35
- val_336 336
- val_95 95
- val_11 11
- val_168 168
- val_34 34
- val_229 229
- val_233 233
- val_143 143
- val_472 472
- val_322 322
- val_498 498
- val_160 160
- val_195 195
- val_42 42
- val_321 321
- val_430 430
- val_119 119
- val_489 489
- val_458 458
- val_78 78
- val_76 76
- val_41 41
- val_223 223
- val_492 492
- val_149 149
- val_449 449
- val_218 218
- val_228 228
- val_138 138
- val_453 453
- val_30 30
- val_209 209
- val_64 64
- val_468 468
- val_76 76
- val_74 74
- val_342 342
- val_69 69
- val_230 230
- val_33 33
- val_368 368
- val_103 103
- val_296 296
- val_113 113
- val_216 216
- val_367 367
- val_344 344
- val_167 167
- val_274 274
- val_219 219
- val_239 239
- val_485 485
- val_116 116
- val_223 223
- val_256 256
- val_263 263
- val_70 70
- val_487 487
- val_480 480
- val_401 401
- val_288 288
- val_191 191
- val_5 5
- val_244 244
- val_438 438
- val_128 128
- val_467 467
- val_432 432
- val_202 202
- val_316 316
- val_229 229
- val_469 469
- val_463 463
- val_280 280
- val_2 2
- val_35 35
- val_283 283
- val_331 331
- val_235 235
- val_80 80
- val_44 44
- val_193 193
- val_321 321
- val_335 335
- val_104 104
- val_466 466
- val_366 366
- val_175 175
- val_403 403
- val_483 483
- val_53 53
- val_105 105
- val_257 257
- val_406 406
- val_409 409
- val_190 190
- val_406 406
- val_401 401
- val_114 114
- val_258 258
- val_90 90
- val_203 203
- val_262 262
- val_348 348
- val_424 424
- val_12 12
- val_396 396
- val_201 201
- val_217 217
- val_164 164
- val_431 431
- val_454 454
- val_478 478
- val_298 298
- val_125 125
- val_431 431
- val_164 164
- val_424 424
- val_187 187
- val_382 382
- val_5 5
- val_70 70
- val_397 397
- val_480 480
- val_291 291
- val_24 24
- val_351 351
- val_255 255
- val_104 104
- val_70 70
- val_163 163
- val_438 438
- val_119 119
- val_414 414
- val_200 200
- val_491 491
- val_237 237
- val_439 439
- val_360 360
- val_248 248
- val_479 479
- val_305 305
- val_417 417
- val_199 199
- val_444 444
- val_120 120
- val_429 429
- val_169 169
- val_443 443
- val_323 323
- val_325 325
- val_277 277
- val_230 230
- val_478 478
- val_178 178
- val_468 468
- val_310 310
- val_317 317
- val_333 333
- val_493 493
- val_460 460
- val_207 207
- val_249 249
- val_265 265
- val_480 480
- val_83 83
- val_136 136
- val_353 353
- val_172 172
- val_214 214
- val_462 462
- val_233 233
- val_406 406
- val_133 133
- val_175 175
- val_189 189
- val_454 454
- val_375 375
- val_401 401
- val_421 421
- val_407 407
- val_384 384
- val_256 256
- val_26 26
- val_134 134
- val_67 67
- val_384 384
- val_379 379
- val_18 18
- val_462 462
- val_492 492
- val_100 100
- val_298 298
- val_9 9
- val_341 341
- val_498 498
- val_146 146
- val_458 458
- val_362 362
- val_186 186
- val_285 285
- val_348 348
- val_167 167
- val_18 18
- val_273 273
- val_183 183
- val_281 281
- val_344 344
- val_97 97
- val_469 469
- val_315 315
- val_84 84
- val_28 28
- val_37 37
- val_448 448
- val_152 152
- val_348 348
- val_307 307
- val_194 194
- val_414 414
- val_477 477
- val_222 222
- val_126 126
- val_90 90
- val_169 169
- val_403 403
- val_400 400
- val_200 200
- val_97 97