PageRenderTime 49ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/contrib/src/test/results/clientpositive/serde_typedbytes3.q.out

#
text | 659 lines | 650 code | 9 blank | 0 comment | 0 complexity | c1399f04a74815ee7603ce3ec8cc8e66 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: drop table dest1
  2. PREHOOK: type: DROPTABLE
  3. POSTHOOK: query: drop table dest1
  4. POSTHOOK: type: DROPTABLE
  5. PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
  6. PREHOOK: type: CREATETABLE
  7. POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
  8. POSTHOOK: type: CREATETABLE
  9. POSTHOOK: Output: default@dest1
  10. PREHOOK: query: EXPLAIN
  11. FROM (
  12. FROM src
  13. SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  14. RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
  15. USING '/bin/cat'
  16. AS (tkey, tvalue) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  17. RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
  18. ) tmap
  19. INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
  20. PREHOOK: type: QUERY
  21. POSTHOOK: query: EXPLAIN
  22. FROM (
  23. FROM src
  24. SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  25. RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
  26. USING '/bin/cat'
  27. AS (tkey, tvalue) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  28. RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
  29. ) tmap
  30. INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
  31. POSTHOOK: type: QUERY
  32. ABSTRACT SYNTAX TREE:
  33. (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_FUNCTION TOK_SMALLINT (. (TOK_TABLE_OR_COL src) key)) (. (TOK_TABLE_OR_COL src) value)) (TOK_SERDE (TOK_SERDENAME 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe')) (TOK_RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter') '/bin/cat' (TOK_SERDE (TOK_SERDENAME 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe')) (TOK_RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader') (TOK_ALIASLIST tkey tvalue)))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL tkey)) (TOK_SELEXPR (TOK_TABLE_OR_COL tvalue)))))
  34. STAGE DEPENDENCIES:
  35. Stage-1 is a root stage
  36. Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
  37. Stage-4
  38. Stage-0 depends on stages: Stage-4, Stage-3
  39. Stage-2 depends on stages: Stage-0
  40. Stage-3
  41. STAGE PLANS:
  42. Stage: Stage-1
  43. Map Reduce
  44. Alias -> Map Operator Tree:
  45. tmap:src
  46. TableScan
  47. alias: src
  48. Select Operator
  49. expressions:
  50. expr: UDFToShort(key)
  51. type: smallint
  52. expr: value
  53. type: string
  54. outputColumnNames: _col0, _col1
  55. Transform Operator
  56. command: /bin/cat
  57. output info:
  58. input format: org.apache.hadoop.mapred.TextInputFormat
  59. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  60. Select Operator
  61. expressions:
  62. expr: _col0
  63. type: string
  64. expr: _col1
  65. type: string
  66. outputColumnNames: _col0, _col1
  67. File Output Operator
  68. compressed: false
  69. GlobalTableId: 1
  70. table:
  71. input format: org.apache.hadoop.mapred.TextInputFormat
  72. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  73. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  74. name: default.dest1
  75. Stage: Stage-5
  76. Conditional Operator
  77. Stage: Stage-4
  78. Move Operator
  79. files:
  80. hdfs directory: true
  81. destination: pfile:/data/users/sdong/www/open-source-hive3/build/contrib/scratchdir/hive_2011-02-16_20-10-09_280_7043943895424265055/-ext-10000
  82. Stage: Stage-0
  83. Move Operator
  84. tables:
  85. replace: true
  86. table:
  87. input format: org.apache.hadoop.mapred.TextInputFormat
  88. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  89. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  90. name: default.dest1
  91. Stage: Stage-2
  92. Stats-Aggr Operator
  93. Stage: Stage-3
  94. Map Reduce
  95. Alias -> Map Operator Tree:
  96. pfile:/data/users/sdong/www/open-source-hive3/build/contrib/scratchdir/hive_2011-02-16_20-10-09_280_7043943895424265055/-ext-10002
  97. File Output Operator
  98. compressed: false
  99. GlobalTableId: 0
  100. table:
  101. input format: org.apache.hadoop.mapred.TextInputFormat
  102. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  103. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  104. name: default.dest1
  105. PREHOOK: query: FROM (
  106. FROM src
  107. SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  108. RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
  109. USING '/bin/cat'
  110. AS (tkey, tvalue) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  111. RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
  112. ) tmap
  113. INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
  114. PREHOOK: type: QUERY
  115. PREHOOK: Input: default@src
  116. PREHOOK: Output: default@dest1
  117. POSTHOOK: query: FROM (
  118. FROM src
  119. SELECT TRANSFORM(cast(src.key as smallint), src.value) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  120. RECORDWRITER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordWriter'
  121. USING '/bin/cat'
  122. AS (tkey, tvalue) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.TypedBytesSerDe'
  123. RECORDREADER 'org.apache.hadoop.hive.contrib.util.typedbytes.TypedBytesRecordReader'
  124. ) tmap
  125. INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue
  126. POSTHOOK: type: QUERY
  127. POSTHOOK: Input: default@src
  128. POSTHOOK: Output: default@dest1
  129. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  130. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  131. PREHOOK: query: SELECT dest1.* FROM dest1
  132. PREHOOK: type: QUERY
  133. PREHOOK: Input: default@dest1
  134. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-13_910_8614946424854582615/-mr-10000
  135. POSTHOOK: query: SELECT dest1.* FROM dest1
  136. POSTHOOK: type: QUERY
  137. POSTHOOK: Input: default@dest1
  138. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-13_910_8614946424854582615/-mr-10000
  139. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  140. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  141. 238 val_238
  142. 86 val_86
  143. 311 val_311
  144. 27 val_27
  145. 165 val_165
  146. 409 val_409
  147. 255 val_255
  148. 278 val_278
  149. 98 val_98
  150. 484 val_484
  151. 265 val_265
  152. 193 val_193
  153. 401 val_401
  154. 150 val_150
  155. 273 val_273
  156. 224 val_224
  157. 369 val_369
  158. 66 val_66
  159. 128 val_128
  160. 213 val_213
  161. 146 val_146
  162. 406 val_406
  163. 429 val_429
  164. 374 val_374
  165. 152 val_152
  166. 469 val_469
  167. 145 val_145
  168. 495 val_495
  169. 37 val_37
  170. 327 val_327
  171. 281 val_281
  172. 277 val_277
  173. 209 val_209
  174. 15 val_15
  175. 82 val_82
  176. 403 val_403
  177. 166 val_166
  178. 417 val_417
  179. 430 val_430
  180. 252 val_252
  181. 292 val_292
  182. 219 val_219
  183. 287 val_287
  184. 153 val_153
  185. 193 val_193
  186. 338 val_338
  187. 446 val_446
  188. 459 val_459
  189. 394 val_394
  190. 237 val_237
  191. 482 val_482
  192. 174 val_174
  193. 413 val_413
  194. 494 val_494
  195. 207 val_207
  196. 199 val_199
  197. 466 val_466
  198. 208 val_208
  199. 174 val_174
  200. 399 val_399
  201. 396 val_396
  202. 247 val_247
  203. 417 val_417
  204. 489 val_489
  205. 162 val_162
  206. 377 val_377
  207. 397 val_397
  208. 309 val_309
  209. 365 val_365
  210. 266 val_266
  211. 439 val_439
  212. 342 val_342
  213. 367 val_367
  214. 325 val_325
  215. 167 val_167
  216. 195 val_195
  217. 475 val_475
  218. 17 val_17
  219. 113 val_113
  220. 155 val_155
  221. 203 val_203
  222. 339 val_339
  223. 0 val_0
  224. 455 val_455
  225. 128 val_128
  226. 311 val_311
  227. 316 val_316
  228. 57 val_57
  229. 302 val_302
  230. 205 val_205
  231. 149 val_149
  232. 438 val_438
  233. 345 val_345
  234. 129 val_129
  235. 170 val_170
  236. 20 val_20
  237. 489 val_489
  238. 157 val_157
  239. 378 val_378
  240. 221 val_221
  241. 92 val_92
  242. 111 val_111
  243. 47 val_47
  244. 72 val_72
  245. 4 val_4
  246. 280 val_280
  247. 35 val_35
  248. 427 val_427
  249. 277 val_277
  250. 208 val_208
  251. 356 val_356
  252. 399 val_399
  253. 169 val_169
  254. 382 val_382
  255. 498 val_498
  256. 125 val_125
  257. 386 val_386
  258. 437 val_437
  259. 469 val_469
  260. 192 val_192
  261. 286 val_286
  262. 187 val_187
  263. 176 val_176
  264. 54 val_54
  265. 459 val_459
  266. 51 val_51
  267. 138 val_138
  268. 103 val_103
  269. 239 val_239
  270. 213 val_213
  271. 216 val_216
  272. 430 val_430
  273. 278 val_278
  274. 176 val_176
  275. 289 val_289
  276. 221 val_221
  277. 65 val_65
  278. 318 val_318
  279. 332 val_332
  280. 311 val_311
  281. 275 val_275
  282. 137 val_137
  283. 241 val_241
  284. 83 val_83
  285. 333 val_333
  286. 180 val_180
  287. 284 val_284
  288. 12 val_12
  289. 230 val_230
  290. 181 val_181
  291. 67 val_67
  292. 260 val_260
  293. 404 val_404
  294. 384 val_384
  295. 489 val_489
  296. 353 val_353
  297. 373 val_373
  298. 272 val_272
  299. 138 val_138
  300. 217 val_217
  301. 84 val_84
  302. 348 val_348
  303. 466 val_466
  304. 58 val_58
  305. 8 val_8
  306. 411 val_411
  307. 230 val_230
  308. 208 val_208
  309. 348 val_348
  310. 24 val_24
  311. 463 val_463
  312. 431 val_431
  313. 179 val_179
  314. 172 val_172
  315. 42 val_42
  316. 129 val_129
  317. 158 val_158
  318. 119 val_119
  319. 496 val_496
  320. 0 val_0
  321. 322 val_322
  322. 197 val_197
  323. 468 val_468
  324. 393 val_393
  325. 454 val_454
  326. 100 val_100
  327. 298 val_298
  328. 199 val_199
  329. 191 val_191
  330. 418 val_418
  331. 96 val_96
  332. 26 val_26
  333. 165 val_165
  334. 327 val_327
  335. 230 val_230
  336. 205 val_205
  337. 120 val_120
  338. 131 val_131
  339. 51 val_51
  340. 404 val_404
  341. 43 val_43
  342. 436 val_436
  343. 156 val_156
  344. 469 val_469
  345. 468 val_468
  346. 308 val_308
  347. 95 val_95
  348. 196 val_196
  349. 288 val_288
  350. 481 val_481
  351. 457 val_457
  352. 98 val_98
  353. 282 val_282
  354. 197 val_197
  355. 187 val_187
  356. 318 val_318
  357. 318 val_318
  358. 409 val_409
  359. 470 val_470
  360. 137 val_137
  361. 369 val_369
  362. 316 val_316
  363. 169 val_169
  364. 413 val_413
  365. 85 val_85
  366. 77 val_77
  367. 0 val_0
  368. 490 val_490
  369. 87 val_87
  370. 364 val_364
  371. 179 val_179
  372. 118 val_118
  373. 134 val_134
  374. 395 val_395
  375. 282 val_282
  376. 138 val_138
  377. 238 val_238
  378. 419 val_419
  379. 15 val_15
  380. 118 val_118
  381. 72 val_72
  382. 90 val_90
  383. 307 val_307
  384. 19 val_19
  385. 435 val_435
  386. 10 val_10
  387. 277 val_277
  388. 273 val_273
  389. 306 val_306
  390. 224 val_224
  391. 309 val_309
  392. 389 val_389
  393. 327 val_327
  394. 242 val_242
  395. 369 val_369
  396. 392 val_392
  397. 272 val_272
  398. 331 val_331
  399. 401 val_401
  400. 242 val_242
  401. 452 val_452
  402. 177 val_177
  403. 226 val_226
  404. 5 val_5
  405. 497 val_497
  406. 402 val_402
  407. 396 val_396
  408. 317 val_317
  409. 395 val_395
  410. 58 val_58
  411. 35 val_35
  412. 336 val_336
  413. 95 val_95
  414. 11 val_11
  415. 168 val_168
  416. 34 val_34
  417. 229 val_229
  418. 233 val_233
  419. 143 val_143
  420. 472 val_472
  421. 322 val_322
  422. 498 val_498
  423. 160 val_160
  424. 195 val_195
  425. 42 val_42
  426. 321 val_321
  427. 430 val_430
  428. 119 val_119
  429. 489 val_489
  430. 458 val_458
  431. 78 val_78
  432. 76 val_76
  433. 41 val_41
  434. 223 val_223
  435. 492 val_492
  436. 149 val_149
  437. 449 val_449
  438. 218 val_218
  439. 228 val_228
  440. 138 val_138
  441. 453 val_453
  442. 30 val_30
  443. 209 val_209
  444. 64 val_64
  445. 468 val_468
  446. 76 val_76
  447. 74 val_74
  448. 342 val_342
  449. 69 val_69
  450. 230 val_230
  451. 33 val_33
  452. 368 val_368
  453. 103 val_103
  454. 296 val_296
  455. 113 val_113
  456. 216 val_216
  457. 367 val_367
  458. 344 val_344
  459. 167 val_167
  460. 274 val_274
  461. 219 val_219
  462. 239 val_239
  463. 485 val_485
  464. 116 val_116
  465. 223 val_223
  466. 256 val_256
  467. 263 val_263
  468. 70 val_70
  469. 487 val_487
  470. 480 val_480
  471. 401 val_401
  472. 288 val_288
  473. 191 val_191
  474. 5 val_5
  475. 244 val_244
  476. 438 val_438
  477. 128 val_128
  478. 467 val_467
  479. 432 val_432
  480. 202 val_202
  481. 316 val_316
  482. 229 val_229
  483. 469 val_469
  484. 463 val_463
  485. 280 val_280
  486. 2 val_2
  487. 35 val_35
  488. 283 val_283
  489. 331 val_331
  490. 235 val_235
  491. 80 val_80
  492. 44 val_44
  493. 193 val_193
  494. 321 val_321
  495. 335 val_335
  496. 104 val_104
  497. 466 val_466
  498. 366 val_366
  499. 175 val_175
  500. 403 val_403
  501. 483 val_483
  502. 53 val_53
  503. 105 val_105
  504. 257 val_257
  505. 406 val_406
  506. 409 val_409
  507. 190 val_190
  508. 406 val_406
  509. 401 val_401
  510. 114 val_114
  511. 258 val_258
  512. 90 val_90
  513. 203 val_203
  514. 262 val_262
  515. 348 val_348
  516. 424 val_424
  517. 12 val_12
  518. 396 val_396
  519. 201 val_201
  520. 217 val_217
  521. 164 val_164
  522. 431 val_431
  523. 454 val_454
  524. 478 val_478
  525. 298 val_298
  526. 125 val_125
  527. 431 val_431
  528. 164 val_164
  529. 424 val_424
  530. 187 val_187
  531. 382 val_382
  532. 5 val_5
  533. 70 val_70
  534. 397 val_397
  535. 480 val_480
  536. 291 val_291
  537. 24 val_24
  538. 351 val_351
  539. 255 val_255
  540. 104 val_104
  541. 70 val_70
  542. 163 val_163
  543. 438 val_438
  544. 119 val_119
  545. 414 val_414
  546. 200 val_200
  547. 491 val_491
  548. 237 val_237
  549. 439 val_439
  550. 360 val_360
  551. 248 val_248
  552. 479 val_479
  553. 305 val_305
  554. 417 val_417
  555. 199 val_199
  556. 444 val_444
  557. 120 val_120
  558. 429 val_429
  559. 169 val_169
  560. 443 val_443
  561. 323 val_323
  562. 325 val_325
  563. 277 val_277
  564. 230 val_230
  565. 478 val_478
  566. 178 val_178
  567. 468 val_468
  568. 310 val_310
  569. 317 val_317
  570. 333 val_333
  571. 493 val_493
  572. 460 val_460
  573. 207 val_207
  574. 249 val_249
  575. 265 val_265
  576. 480 val_480
  577. 83 val_83
  578. 136 val_136
  579. 353 val_353
  580. 172 val_172
  581. 214 val_214
  582. 462 val_462
  583. 233 val_233
  584. 406 val_406
  585. 133 val_133
  586. 175 val_175
  587. 189 val_189
  588. 454 val_454
  589. 375 val_375
  590. 401 val_401
  591. 421 val_421
  592. 407 val_407
  593. 384 val_384
  594. 256 val_256
  595. 26 val_26
  596. 134 val_134
  597. 67 val_67
  598. 384 val_384
  599. 379 val_379
  600. 18 val_18
  601. 462 val_462
  602. 492 val_492
  603. 100 val_100
  604. 298 val_298
  605. 9 val_9
  606. 341 val_341
  607. 498 val_498
  608. 146 val_146
  609. 458 val_458
  610. 362 val_362
  611. 186 val_186
  612. 285 val_285
  613. 348 val_348
  614. 167 val_167
  615. 18 val_18
  616. 273 val_273
  617. 183 val_183
  618. 281 val_281
  619. 344 val_344
  620. 97 val_97
  621. 469 val_469
  622. 315 val_315
  623. 84 val_84
  624. 28 val_28
  625. 37 val_37
  626. 448 val_448
  627. 152 val_152
  628. 348 val_348
  629. 307 val_307
  630. 194 val_194
  631. 414 val_414
  632. 477 val_477
  633. 222 val_222
  634. 126 val_126
  635. 90 val_90
  636. 169 val_169
  637. 403 val_403
  638. 400 val_400
  639. 200 val_200
  640. 97 val_97
  641. PREHOOK: query: drop table dest1
  642. PREHOOK: type: DROPTABLE
  643. PREHOOK: Input: default@dest1
  644. PREHOOK: Output: default@dest1
  645. POSTHOOK: query: drop table dest1
  646. POSTHOOK: type: DROPTABLE
  647. POSTHOOK: Input: default@dest1
  648. POSTHOOK: Output: default@dest1
  649. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  650. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]