PageRenderTime 46ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/ppd1.q.out

#
text | 434 lines | 429 code | 5 blank | 0 comment | 0 complexity | 618d8aee68b1f693abd8deaa67a145a7 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: EXPLAIN
  2. SELECT src.key as c3 from src where src.key > '2'
  3. PREHOOK: type: QUERY
  4. POSTHOOK: query: EXPLAIN
  5. SELECT src.key as c3 from src where src.key > '2'
  6. POSTHOOK: type: QUERY
  7. ABSTRACT SYNTAX TREE:
  8. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key) c3)) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) '2'))))
  9. STAGE DEPENDENCIES:
  10. Stage-1 is a root stage
  11. Stage-0 is a root stage
  12. STAGE PLANS:
  13. Stage: Stage-1
  14. Map Reduce
  15. Alias -> Map Operator Tree:
  16. src
  17. TableScan
  18. alias: src
  19. Filter Operator
  20. predicate:
  21. expr: (key > '2')
  22. type: boolean
  23. Filter Operator
  24. predicate:
  25. expr: (key > '2')
  26. type: boolean
  27. Select Operator
  28. expressions:
  29. expr: key
  30. type: string
  31. outputColumnNames: _col0
  32. File Output Operator
  33. compressed: false
  34. GlobalTableId: 0
  35. table:
  36. input format: org.apache.hadoop.mapred.TextInputFormat
  37. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  38. Stage: Stage-0
  39. Fetch Operator
  40. limit: -1
  41. PREHOOK: query: SELECT src.key as c3 from src where src.key > '2'
  42. PREHOOK: type: QUERY
  43. PREHOOK: Input: default@src
  44. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
  45. POSTHOOK: query: SELECT src.key as c3 from src where src.key > '2'
  46. POSTHOOK: type: QUERY
  47. POSTHOOK: Input: default@src
  48. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
  49. 238
  50. 86
  51. 311
  52. 27
  53. 409
  54. 255
  55. 278
  56. 98
  57. 484
  58. 265
  59. 401
  60. 273
  61. 224
  62. 369
  63. 66
  64. 213
  65. 406
  66. 429
  67. 374
  68. 469
  69. 495
  70. 37
  71. 327
  72. 281
  73. 277
  74. 209
  75. 82
  76. 403
  77. 417
  78. 430
  79. 252
  80. 292
  81. 219
  82. 287
  83. 338
  84. 446
  85. 459
  86. 394
  87. 237
  88. 482
  89. 413
  90. 494
  91. 207
  92. 466
  93. 208
  94. 399
  95. 396
  96. 247
  97. 417
  98. 489
  99. 377
  100. 397
  101. 309
  102. 365
  103. 266
  104. 439
  105. 342
  106. 367
  107. 325
  108. 475
  109. 203
  110. 339
  111. 455
  112. 311
  113. 316
  114. 57
  115. 302
  116. 205
  117. 438
  118. 345
  119. 20
  120. 489
  121. 378
  122. 221
  123. 92
  124. 47
  125. 72
  126. 4
  127. 280
  128. 35
  129. 427
  130. 277
  131. 208
  132. 356
  133. 399
  134. 382
  135. 498
  136. 386
  137. 437
  138. 469
  139. 286
  140. 54
  141. 459
  142. 51
  143. 239
  144. 213
  145. 216
  146. 430
  147. 278
  148. 289
  149. 221
  150. 65
  151. 318
  152. 332
  153. 311
  154. 275
  155. 241
  156. 83
  157. 333
  158. 284
  159. 230
  160. 67
  161. 260
  162. 404
  163. 384
  164. 489
  165. 353
  166. 373
  167. 272
  168. 217
  169. 84
  170. 348
  171. 466
  172. 58
  173. 8
  174. 411
  175. 230
  176. 208
  177. 348
  178. 24
  179. 463
  180. 431
  181. 42
  182. 496
  183. 322
  184. 468
  185. 393
  186. 454
  187. 298
  188. 418
  189. 96
  190. 26
  191. 327
  192. 230
  193. 205
  194. 51
  195. 404
  196. 43
  197. 436
  198. 469
  199. 468
  200. 308
  201. 95
  202. 288
  203. 481
  204. 457
  205. 98
  206. 282
  207. 318
  208. 318
  209. 409
  210. 470
  211. 369
  212. 316
  213. 413
  214. 85
  215. 77
  216. 490
  217. 87
  218. 364
  219. 395
  220. 282
  221. 238
  222. 419
  223. 72
  224. 90
  225. 307
  226. 435
  227. 277
  228. 273
  229. 306
  230. 224
  231. 309
  232. 389
  233. 327
  234. 242
  235. 369
  236. 392
  237. 272
  238. 331
  239. 401
  240. 242
  241. 452
  242. 226
  243. 5
  244. 497
  245. 402
  246. 396
  247. 317
  248. 395
  249. 58
  250. 35
  251. 336
  252. 95
  253. 34
  254. 229
  255. 233
  256. 472
  257. 322
  258. 498
  259. 42
  260. 321
  261. 430
  262. 489
  263. 458
  264. 78
  265. 76
  266. 41
  267. 223
  268. 492
  269. 449
  270. 218
  271. 228
  272. 453
  273. 30
  274. 209
  275. 64
  276. 468
  277. 76
  278. 74
  279. 342
  280. 69
  281. 230
  282. 33
  283. 368
  284. 296
  285. 216
  286. 367
  287. 344
  288. 274
  289. 219
  290. 239
  291. 485
  292. 223
  293. 256
  294. 263
  295. 70
  296. 487
  297. 480
  298. 401
  299. 288
  300. 5
  301. 244
  302. 438
  303. 467
  304. 432
  305. 202
  306. 316
  307. 229
  308. 469
  309. 463
  310. 280
  311. 35
  312. 283
  313. 331
  314. 235
  315. 80
  316. 44
  317. 321
  318. 335
  319. 466
  320. 366
  321. 403
  322. 483
  323. 53
  324. 257
  325. 406
  326. 409
  327. 406
  328. 401
  329. 258
  330. 90
  331. 203
  332. 262
  333. 348
  334. 424
  335. 396
  336. 201
  337. 217
  338. 431
  339. 454
  340. 478
  341. 298
  342. 431
  343. 424
  344. 382
  345. 5
  346. 70
  347. 397
  348. 480
  349. 291
  350. 24
  351. 351
  352. 255
  353. 70
  354. 438
  355. 414
  356. 200
  357. 491
  358. 237
  359. 439
  360. 360
  361. 248
  362. 479
  363. 305
  364. 417
  365. 444
  366. 429
  367. 443
  368. 323
  369. 325
  370. 277
  371. 230
  372. 478
  373. 468
  374. 310
  375. 317
  376. 333
  377. 493
  378. 460
  379. 207
  380. 249
  381. 265
  382. 480
  383. 83
  384. 353
  385. 214
  386. 462
  387. 233
  388. 406
  389. 454
  390. 375
  391. 401
  392. 421
  393. 407
  394. 384
  395. 256
  396. 26
  397. 67
  398. 384
  399. 379
  400. 462
  401. 492
  402. 298
  403. 9
  404. 341
  405. 498
  406. 458
  407. 362
  408. 285
  409. 348
  410. 273
  411. 281
  412. 344
  413. 97
  414. 469
  415. 315
  416. 84
  417. 28
  418. 37
  419. 448
  420. 348
  421. 307
  422. 414
  423. 477
  424. 222
  425. 90
  426. 403
  427. 400
  428. 200
  429. 97