PageRenderTime 51ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 886 lines | 876 code | 10 blank | 0 comment | 0 complexity | 16bfc86194ae1308926c36ab298930fd MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@DEST1
    6. 

  6. PREHOOK: query: CREATE TABLE DEST2(key INT, val1 STRING, val2 STRING) STORED AS TEXTFILE
    7. 

  7. PREHOOK: type: CREATETABLE
    8. 

  8. POSTHOOK: query: CREATE TABLE DEST2(key INT, val1 STRING, val2 STRING) STORED AS TEXTFILE
    9. 

  9. POSTHOOK: type: CREATETABLE
    10. 

  10. POSTHOOK: Output: default@DEST2
    11. 

  11. PREHOOK: query: EXPLAIN
    12. 

  12. FROM SRC
    13. 

  13. INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
    14. 

  14. INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
    15. 

  15. PREHOOK: type: QUERY
    16. 

  16. POSTHOOK: query: EXPLAIN
    17. 

  17. FROM SRC
    18. 

  18. INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
    19. 

  19. INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
    20. 

  20. POSTHOOK: type: QUERY
    21. 

  21. ABSTRACT SYNTAX TREE:
    22. 

  22.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME DEST1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME DEST2))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) value)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key) (. (TOK_TABLE_OR_COL SRC) value))))
    23. 

  23. 

  24. STAGE DEPENDENCIES:
    25. 

  25.   Stage-2 is a root stage
    26. 

  26.   Stage-3 depends on stages: Stage-2
    27. 

  27.   Stage-0 depends on stages: Stage-3
    28. 

  28.   Stage-4 depends on stages: Stage-0
    29. 

  29.   Stage-5 depends on stages: Stage-2
    30. 

  30.   Stage-1 depends on stages: Stage-5
    31. 

  31.   Stage-6 depends on stages: Stage-1
    32. 

  32. 

  33. STAGE PLANS:
    34. 

  34.   Stage: Stage-2
    35. 

  35.     Map Reduce
    36. 

  36.       Alias -> Map Operator Tree:
    37. 

  37.         src 
    38. 

  38.           TableScan
    39. 

  39.             alias: src
    40. 

  40.             Reduce Output Operator
    41. 

  41.               key expressions:
    42. 

  42.                     expr: substr(value, 5)
    43. 

  43.                     type: string
    44. 

  44.               sort order: +
    45. 

  45.               Map-reduce partition columns:
    46. 

  46.                     expr: substr(value, 5)
    47. 

  47.                     type: string
    48. 

  48.               tag: -1
    49. 

  49.               value expressions:
    50. 

  50.                     expr: key
    51. 

  51.                     type: string
    52. 

  52.                     expr: value
    53. 

  53.                     type: string
    54. 

  54.       Reduce Operator Tree:
    55. 

  55.         Forward
    56. 

  56.           Group By Operator
    57. 

  57.             aggregations:
    58. 

  58.                   expr: count(DISTINCT KEY._col0)
    59. 

  59.             bucketGroup: false
    60. 

  60.             keys:
    61. 

  61.                   expr: VALUE._col0
    62. 

  62.                   type: string
    63. 

  63.             mode: hash
    64. 

  64.             outputColumnNames: _col0, _col1
    65. 

  65.             File Output Operator
    66. 

  66.               compressed: false
    67. 

  67.               GlobalTableId: 0
    68. 

  68.               table:
    69. 

  69.                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    70. 

  70.                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    71. 

  71.           Group By Operator
    72. 

  72.             aggregations:
    73. 

  73.                   expr: count(DISTINCT KEY._col0)
    74. 

  74.             bucketGroup: false
    75. 

  75.             keys:
    76. 

  76.                   expr: VALUE._col0
    77. 

  77.                   type: string
    78. 

  78.                   expr: VALUE._col1
    79. 

  79.                   type: string
    80. 

  80.             mode: hash
    81. 

  81.             outputColumnNames: _col0, _col1, _col2
    82. 

  82.             File Output Operator
    83. 

  83.               compressed: false
    84. 

  84.               GlobalTableId: 0
    85. 

  85.               table:
    86. 

  86.                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    87. 

  87.                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    88. 

  88. 

  89.   Stage: Stage-3
    90. 

  90.     Map Reduce
    91. 

  91.       Alias -> Map Operator Tree:
    92. 

  92.         file:/tmp/sdong/hive_2011-02-10_01-54-04_927_822043255486757265/-mr-10004 
    93. 

  93.             Reduce Output Operator
    94. 

  94.               key expressions:
    95. 

  95.                     expr: _col0
    96. 

  96.                     type: string
    97. 

  97.               sort order: +
    98. 

  98.               Map-reduce partition columns:
    99. 

  99.                     expr: _col0
    100. 

  100.                     type: string
    101. 

  101.               tag: -1
    102. 

  102.               value expressions:
    103. 

  103.                     expr: _col1
    104. 

  104.                     type: bigint
    105. 

  105.       Reduce Operator Tree:
    106. 

  106.         Group By Operator
    107. 

  107.           aggregations:
    108. 

  108.                 expr: count(VALUE._col0)
    109. 

  109.           bucketGroup: false
    110. 

  110.           keys:
    111. 

  111.                 expr: KEY._col0
    112. 

  112.                 type: string
    113. 

  113.           mode: final
    114. 

  114.           outputColumnNames: _col0, _col1
    115. 

  115.           Select Operator
    116. 

  116.             expressions:
    117. 

  117.                   expr: _col0
    118. 

  118.                   type: string
    119. 

  119.                   expr: _col1
    120. 

  120.                   type: bigint
    121. 

  121.             outputColumnNames: _col0, _col1
    122. 

  122.             Select Operator
    123. 

  123.               expressions:
    124. 

  124.                     expr: UDFToInteger(_col0)
    125. 

  125.                     type: int
    126. 

  126.                     expr: _col1
    127. 

  127.                     type: bigint
    128. 

  128.               outputColumnNames: _col0, _col1
    129. 

  129.               File Output Operator
    130. 

  130.                 compressed: false
    131. 

  131.                 GlobalTableId: 1
    132. 

  132.                 table:
    133. 

  133.                     input format: org.apache.hadoop.mapred.TextInputFormat
    134. 

  134.                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    135. 

  135.                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    136. 

  136.                     name: default.dest1
    137. 

  137. 

  138.   Stage: Stage-0
    139. 

  139.     Move Operator
    140. 

  140.       tables:
    141. 

  141.           replace: true
    142. 

  142.           table:
    143. 

  143.               input format: org.apache.hadoop.mapred.TextInputFormat
    144. 

  144.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    145. 

  145.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    146. 

  146.               name: default.dest1
    147. 

  147. 

  148.   Stage: Stage-4
    149. 

  149.     Stats-Aggr Operator
    150. 

  150. 

  151.   Stage: Stage-5
    152. 

  152.     Map Reduce
    153. 

  153.       Alias -> Map Operator Tree:
    154. 

  154.         file:/tmp/sdong/hive_2011-02-10_01-54-04_927_822043255486757265/-mr-10005 
    155. 

  155.             Reduce Output Operator
    156. 

  156.               key expressions:
    157. 

  157.                     expr: _col0
    158. 

  158.                     type: string
    159. 

  159.                     expr: _col1
    160. 

  160.                     type: string
    161. 

  161.               sort order: ++
    162. 

  162.               Map-reduce partition columns:
    163. 

  163.                     expr: _col0
    164. 

  164.                     type: string
    165. 

  165.                     expr: _col1
    166. 

  166.                     type: string
    167. 

  167.               tag: -1
    168. 

  168.               value expressions:
    169. 

  169.                     expr: _col2
    170. 

  170.                     type: bigint
    171. 

  171.       Reduce Operator Tree:
    172. 

  172.         Group By Operator
    173. 

  173.           aggregations:
    174. 

  174.                 expr: count(VALUE._col0)
    175. 

  175.           bucketGroup: false
    176. 

  176.           keys:
    177. 

  177.                 expr: KEY._col0
    178. 

  178.                 type: string
    179. 

  179.                 expr: KEY._col1
    180. 

  180.                 type: string
    181. 

  181.           mode: final
    182. 

  182.           outputColumnNames: _col0, _col1, _col2
    183. 

  183.           Select Operator
    184. 

  184.             expressions:
    185. 

  185.                   expr: _col0
    186. 

  186.                   type: string
    187. 

  187.                   expr: _col1
    188. 

  188.                   type: string
    189. 

  189.                   expr: _col2
    190. 

  190.                   type: bigint
    191. 

  191.             outputColumnNames: _col0, _col1, _col2
    192. 

  192.             Select Operator
    193. 

  193.               expressions:
    194. 

  194.                     expr: UDFToInteger(_col0)
    195. 

  195.                     type: int
    196. 

  196.                     expr: _col1
    197. 

  197.                     type: string
    198. 

  198.                     expr: _col2
    199. 

  199.                     type: bigint
    200. 

  200.               outputColumnNames: _col0, _col1, _col2
    201. 

  201.               File Output Operator
    202. 

  202.                 compressed: false
    203. 

  203.                 GlobalTableId: 2
    204. 

  204.                 table:
    205. 

  205.                     input format: org.apache.hadoop.mapred.TextInputFormat
    206. 

  206.                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    207. 

  207.                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    208. 

  208.                     name: default.dest2
    209. 

  209. 

  210.   Stage: Stage-1
    211. 

  211.     Move Operator
    212. 

  212.       tables:
    213. 

  213.           replace: true
    214. 

  214.           table:
    215. 

  215.               input format: org.apache.hadoop.mapred.TextInputFormat
    216. 

  216.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    217. 

  217.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    218. 

  218.               name: default.dest2
    219. 

  219. 

  220.   Stage: Stage-6
    221. 

  221.     Stats-Aggr Operator
    222. 

  222. 

  223. 

  224. PREHOOK: query: FROM SRC
    225. 

  225. INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
    226. 

  226. INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
    227. 

  227. PREHOOK: type: QUERY
    228. 

  228. PREHOOK: Input: default@src
    229. 

  229. PREHOOK: Output: default@dest1
    230. 

  230. PREHOOK: Output: default@dest2
    231. 

  231. POSTHOOK: query: FROM SRC
    232. 

  232. INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
    233. 

  233. INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
    234. 

  234. POSTHOOK: type: QUERY
    235. 

  235. POSTHOOK: Input: default@src
    236. 

  236. POSTHOOK: Output: default@dest1
    237. 

  237. POSTHOOK: Output: default@dest2
    238. 

  238. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    239. 

  239. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    240. 

  240. POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    241. 

  241. POSTHOOK: Lineage: dest2.val1 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    242. 

  242. POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    243. 

  243. PREHOOK: query: SELECT DEST1.* FROM DEST1
    244. 

  244. PREHOOK: type: QUERY
    245. 

  245. PREHOOK: Input: default@dest1
    246. 

  246. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-54-17_890_6247829193198358875/-mr-10000
    247. 

  247. POSTHOOK: query: SELECT DEST1.* FROM DEST1
    248. 

  248. POSTHOOK: type: QUERY
    249. 

  249. POSTHOOK: Input: default@dest1
    250. 

  250. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-54-17_890_6247829193198358875/-mr-10000
    251. 

  251. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    252. 

  252. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    253. 

  253. POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    254. 

  254. POSTHOOK: Lineage: dest2.val1 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    255. 

  255. POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    256. 

  256. 0	1
    257. 

  257. 10	1
    258. 

  258. 100	1
    259. 

  259. 103	1
    260. 

  260. 104	1
    261. 

  261. 105	1
    262. 

  262. 11	1
    263. 

  263. 111	1
    264. 

  264. 113	1
    265. 

  265. 114	1
    266. 

  266. 116	1
    267. 

  267. 118	1
    268. 

  268. 119	1
    269. 

  269. 12	1
    270. 

  270. 120	1
    271. 

  271. 125	1
    272. 

  272. 126	1
    273. 

  273. 128	1
    274. 

  274. 129	1
    275. 

  275. 131	1
    276. 

  276. 133	1
    277. 

  277. 134	1
    278. 

  278. 136	1
    279. 

  279. 137	1
    280. 

  280. 138	1
    281. 

  281. 143	1
    282. 

  282. 145	1
    283. 

  283. 146	1
    284. 

  284. 149	1
    285. 

  285. 15	1
    286. 

  286. 150	1
    287. 

  287. 152	1
    288. 

  288. 153	1
    289. 

  289. 155	1
    290. 

  290. 156	1
    291. 

  291. 157	1
    292. 

  292. 158	1
    293. 

  293. 160	1
    294. 

  294. 162	1
    295. 

  295. 163	1
    296. 

  296. 164	1
    297. 

  297. 165	1
    298. 

  298. 166	1
    299. 

  299. 167	1
    300. 

  300. 168	1
    301. 

  301. 169	1
    302. 

  302. 17	1
    303. 

  303. 170	1
    304. 

  304. 172	1
    305. 

  305. 174	1
    306. 

  306. 175	1
    307. 

  307. 176	1
    308. 

  308. 177	1
    309. 

  309. 178	1
    310. 

  310. 179	1
    311. 

  311. 18	1
    312. 

  312. 180	1
    313. 

  313. 181	1
    314. 

  314. 183	1
    315. 

  315. 186	1
    316. 

  316. 187	1
    317. 

  317. 189	1
    318. 

  318. 19	1
    319. 

  319. 190	1
    320. 

  320. 191	1
    321. 

  321. 192	1
    322. 

  322. 193	1
    323. 

  323. 194	1
    324. 

  324. 195	1
    325. 

  325. 196	1
    326. 

  326. 197	1
    327. 

  327. 199	1
    328. 

  328. 2	1
    329. 

  329. 20	1
    330. 

  330. 200	1
    331. 

  331. 201	1
    332. 

  332. 202	1
    333. 

  333. 203	1
    334. 

  334. 205	1
    335. 

  335. 207	1
    336. 

  336. 208	1
    337. 

  337. 209	1
    338. 

  338. 213	1
    339. 

  339. 214	1
    340. 

  340. 216	1
    341. 

  341. 217	1
    342. 

  342. 218	1
    343. 

  343. 219	1
    344. 

  344. 221	1
    345. 

  345. 222	1
    346. 

  346. 223	1
    347. 

  347. 224	1
    348. 

  348. 226	1
    349. 

  349. 228	1
    350. 

  350. 229	1
    351. 

  351. 230	1
    352. 

  352. 233	1
    353. 

  353. 235	1
    354. 

  354. 237	1
    355. 

  355. 238	1
    356. 

  356. 239	1
    357. 

  357. 24	1
    358. 

  358. 241	1
    359. 

  359. 242	1
    360. 

  360. 244	1
    361. 

  361. 247	1
    362. 

  362. 248	1
    363. 

  363. 249	1
    364. 

  364. 252	1
    365. 

  365. 255	1
    366. 

  366. 256	1
    367. 

  367. 257	1
    368. 

  368. 258	1
    369. 

  369. 26	1
    370. 

  370. 260	1
    371. 

  371. 262	1
    372. 

  372. 263	1
    373. 

  373. 265	1
    374. 

  374. 266	1
    375. 

  375. 27	1
    376. 

  376. 272	1
    377. 

  377. 273	1
    378. 

  378. 274	1
    379. 

  379. 275	1
    380. 

  380. 277	1
    381. 

  381. 278	1
    382. 

  382. 28	1
    383. 

  383. 280	1
    384. 

  384. 281	1
    385. 

  385. 282	1
    386. 

  386. 283	1
    387. 

  387. 284	1
    388. 

  388. 285	1
    389. 

  389. 286	1
    390. 

  390. 287	1
    391. 

  391. 288	1
    392. 

  392. 289	1
    393. 

  393. 291	1
    394. 

  394. 292	1
    395. 

  395. 296	1
    396. 

  396. 298	1
    397. 

  397. 30	1
    398. 

  398. 302	1
    399. 

  399. 305	1
    400. 

  400. 306	1
    401. 

  401. 307	1
    402. 

  402. 308	1
    403. 

  403. 309	1
    404. 

  404. 310	1
    405. 

  405. 311	1
    406. 

  406. 315	1
    407. 

  407. 316	1
    408. 

  408. 317	1
    409. 

  409. 318	1
    410. 

  410. 321	1
    411. 

  411. 322	1
    412. 

  412. 323	1
    413. 

  413. 325	1
    414. 

  414. 327	1
    415. 

  415. 33	1
    416. 

  416. 331	1
    417. 

  417. 332	1
    418. 

  418. 333	1
    419. 

  419. 335	1
    420. 

  420. 336	1
    421. 

  421. 338	1
    422. 

  422. 339	1
    423. 

  423. 34	1
    424. 

  424. 341	1
    425. 

  425. 342	1
    426. 

  426. 344	1
    427. 

  427. 345	1
    428. 

  428. 348	1
    429. 

  429. 35	1
    430. 

  430. 351	1
    431. 

  431. 353	1
    432. 

  432. 356	1
    433. 

  433. 360	1
    434. 

  434. 362	1
    435. 

  435. 364	1
    436. 

  436. 365	1
    437. 

  437. 366	1
    438. 

  438. 367	1
    439. 

  439. 368	1
    440. 

  440. 369	1
    441. 

  441. 37	1
    442. 

  442. 373	1
    443. 

  443. 374	1
    444. 

  444. 375	1
    445. 

  445. 377	1
    446. 

  446. 378	1
    447. 

  447. 379	1
    448. 

  448. 382	1
    449. 

  449. 384	1
    450. 

  450. 386	1
    451. 

  451. 389	1
    452. 

  452. 392	1
    453. 

  453. 393	1
    454. 

  454. 394	1
    455. 

  455. 395	1
    456. 

  456. 396	1
    457. 

  457. 397	1
    458. 

  458. 399	1
    459. 

  459. 4	1
    460. 

  460. 400	1
    461. 

  461. 401	1
    462. 

  462. 402	1
    463. 

  463. 403	1
    464. 

  464. 404	1
    465. 

  465. 406	1
    466. 

  466. 407	1
    467. 

  467. 409	1
    468. 

  468. 41	1
    469. 

  469. 411	1
    470. 

  470. 413	1
    471. 

  471. 414	1
    472. 

  472. 417	1
    473. 

  473. 418	1
    474. 

  474. 419	1
    475. 

  475. 42	1
    476. 

  476. 421	1
    477. 

  477. 424	1
    478. 

  478. 427	1
    479. 

  479. 429	1
    480. 

  480. 43	1
    481. 

  481. 430	1
    482. 

  482. 431	1
    483. 

  483. 432	1
    484. 

  484. 435	1
    485. 

  485. 436	1
    486. 

  486. 437	1
    487. 

  487. 438	1
    488. 

  488. 439	1
    489. 

  489. 44	1
    490. 

  490. 443	1
    491. 

  491. 444	1
    492. 

  492. 446	1
    493. 

  493. 448	1
    494. 

  494. 449	1
    495. 

  495. 452	1
    496. 

  496. 453	1
    497. 

  497. 454	1
    498. 

  498. 455	1
    499. 

  499. 457	1
    500. 

  500. 458	1
    501. 

  501. 459	1
    502. 

  502. 460	1
    503. 

  503. 462	1
    504. 

  504. 463	1
    505. 

  505. 466	1
    506. 

  506. 467	1
    507. 

  507. 468	1
    508. 

  508. 469	1
    509. 

  509. 47	1
    510. 

  510. 470	1
    511. 

  511. 472	1
    512. 

  512. 475	1
    513. 

  513. 477	1
    514. 

  514. 478	1
    515. 

  515. 479	1
    516. 

  516. 480	1
    517. 

  517. 481	1
    518. 

  518. 482	1
    519. 

  519. 483	1
    520. 

  520. 484	1
    521. 

  521. 485	1
    522. 

  522. 487	1
    523. 

  523. 489	1
    524. 

  524. 490	1
    525. 

  525. 491	1
    526. 

  526. 492	1
    527. 

  527. 493	1
    528. 

  528. 494	1
    529. 

  529. 495	1
    530. 

  530. 496	1
    531. 

  531. 497	1
    532. 

  532. 498	1
    533. 

  533. 5	1
    534. 

  534. 51	1
    535. 

  535. 53	1
    536. 

  536. 54	1
    537. 

  537. 57	1
    538. 

  538. 58	1
    539. 

  539. 64	1
    540. 

  540. 65	1
    541. 

  541. 66	1
    542. 

  542. 67	1
    543. 

  543. 69	1
    544. 

  544. 70	1
    545. 

  545. 72	1
    546. 

  546. 74	1
    547. 

  547. 76	1
    548. 

  548. 77	1
    549. 

  549. 78	1
    550. 

  550. 8	1
    551. 

  551. 80	1
    552. 

  552. 82	1
    553. 

  553. 83	1
    554. 

  554. 84	1
    555. 

  555. 85	1
    556. 

  556. 86	1
    557. 

  557. 87	1
    558. 

  558. 9	1
    559. 

  559. 90	1
    560. 

  560. 92	1
    561. 

  561. 95	1
    562. 

  562. 96	1
    563. 

  563. 97	1
    564. 

  564. 98	1
    565. 

  565. PREHOOK: query: SELECT DEST2.* FROM DEST2
    566. 

  566. PREHOOK: type: QUERY
    567. 

  567. PREHOOK: Input: default@dest2
    568. 

  568. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-54-18_177_4478446184795939014/-mr-10000
    569. 

  569. POSTHOOK: query: SELECT DEST2.* FROM DEST2
    570. 

  570. POSTHOOK: type: QUERY
    571. 

  571. POSTHOOK: Input: default@dest2
    572. 

  572. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-54-18_177_4478446184795939014/-mr-10000
    573. 

  573. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    574. 

  574. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    575. 

  575. POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    576. 

  576. POSTHOOK: Lineage: dest2.val1 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    577. 

  577. POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    578. 

  578. 0	val_0	1
    579. 

  579. 10	val_10	1
    580. 

  580. 100	val_100	1
    581. 

  581. 103	val_103	1
    582. 

  582. 104	val_104	1
    583. 

  583. 105	val_105	1
    584. 

  584. 11	val_11	1
    585. 

  585. 111	val_111	1
    586. 

  586. 113	val_113	1
    587. 

  587. 114	val_114	1
    588. 

  588. 116	val_116	1
    589. 

  589. 118	val_118	1
    590. 

  590. 119	val_119	1
    591. 

  591. 12	val_12	1
    592. 

  592. 120	val_120	1
    593. 

  593. 125	val_125	1
    594. 

  594. 126	val_126	1
    595. 

  595. 128	val_128	1
    596. 

  596. 129	val_129	1
    597. 

  597. 131	val_131	1
    598. 

  598. 133	val_133	1
    599. 

  599. 134	val_134	1
    600. 

  600. 136	val_136	1
    601. 

  601. 137	val_137	1
    602. 

  602. 138	val_138	1
    603. 

  603. 143	val_143	1
    604. 

  604. 145	val_145	1
    605. 

  605. 146	val_146	1
    606. 

  606. 149	val_149	1
    607. 

  607. 15	val_15	1
    608. 

  608. 150	val_150	1
    609. 

  609. 152	val_152	1
    610. 

  610. 153	val_153	1
    611. 

  611. 155	val_155	1
    612. 

  612. 156	val_156	1
    613. 

  613. 157	val_157	1
    614. 

  614. 158	val_158	1
    615. 

  615. 160	val_160	1
    616. 

  616. 162	val_162	1
    617. 

  617. 163	val_163	1
    618. 

  618. 164	val_164	1
    619. 

  619. 165	val_165	1
    620. 

  620. 166	val_166	1
    621. 

  621. 167	val_167	1
    622. 

  622. 168	val_168	1
    623. 

  623. 169	val_169	1
    624. 

  624. 17	val_17	1
    625. 

  625. 170	val_170	1
    626. 

  626. 172	val_172	1
    627. 

  627. 174	val_174	1
    628. 

  628. 175	val_175	1
    629. 

  629. 176	val_176	1
    630. 

  630. 177	val_177	1
    631. 

  631. 178	val_178	1
    632. 

  632. 179	val_179	1
    633. 

  633. 18	val_18	1
    634. 

  634. 180	val_180	1
    635. 

  635. 181	val_181	1
    636. 

  636. 183	val_183	1
    637. 

  637. 186	val_186	1
    638. 

  638. 187	val_187	1
    639. 

  639. 189	val_189	1
    640. 

  640. 19	val_19	1
    641. 

  641. 190	val_190	1
    642. 

  642. 191	val_191	1
    643. 

  643. 192	val_192	1
    644. 

  644. 193	val_193	1
    645. 

  645. 194	val_194	1
    646. 

  646. 195	val_195	1
    647. 

  647. 196	val_196	1
    648. 

  648. 197	val_197	1
    649. 

  649. 199	val_199	1
    650. 

  650. 2	val_2	1
    651. 

  651. 20	val_20	1
    652. 

  652. 200	val_200	1
    653. 

  653. 201	val_201	1
    654. 

  654. 202	val_202	1
    655. 

  655. 203	val_203	1
    656. 

  656. 205	val_205	1
    657. 

  657. 207	val_207	1
    658. 

  658. 208	val_208	1
    659. 

  659. 209	val_209	1
    660. 

  660. 213	val_213	1
    661. 

  661. 214	val_214	1
    662. 

  662. 216	val_216	1
    663. 

  663. 217	val_217	1
    664. 

  664. 218	val_218	1
    665. 

  665. 219	val_219	1
    666. 

  666. 221	val_221	1
    667. 

  667. 222	val_222	1
    668. 

  668. 223	val_223	1
    669. 

  669. 224	val_224	1
    670. 

  670. 226	val_226	1
    671. 

  671. 228	val_228	1
    672. 

  672. 229	val_229	1
    673. 

  673. 230	val_230	1
    674. 

  674. 233	val_233	1
    675. 

  675. 235	val_235	1
    676. 

  676. 237	val_237	1
    677. 

  677. 238	val_238	1
    678. 

  678. 239	val_239	1
    679. 

  679. 24	val_24	1
    680. 

  680. 241	val_241	1
    681. 

  681. 242	val_242	1
    682. 

  682. 244	val_244	1
    683. 

  683. 247	val_247	1
    684. 

  684. 248	val_248	1
    685. 

  685. 249	val_249	1
    686. 

  686. 252	val_252	1
    687. 

  687. 255	val_255	1
    688. 

  688. 256	val_256	1
    689. 

  689. 257	val_257	1
    690. 

  690. 258	val_258	1
    691. 

  691. 26	val_26	1
    692. 

  692. 260	val_260	1
    693. 

  693. 262	val_262	1
    694. 

  694. 263	val_263	1
    695. 

  695. 265	val_265	1
    696. 

  696. 266	val_266	1
    697. 

  697. 27	val_27	1
    698. 

  698. 272	val_272	1
    699. 

  699. 273	val_273	1
    700. 

  700. 274	val_274	1
    701. 

  701. 275	val_275	1
    702. 

  702. 277	val_277	1
    703. 

  703. 278	val_278	1
    704. 

  704. 28	val_28	1
    705. 

  705. 280	val_280	1
    706. 

  706. 281	val_281	1
    707. 

  707. 282	val_282	1
    708. 

  708. 283	val_283	1
    709. 

  709. 284	val_284	1
    710. 

  710. 285	val_285	1
    711. 

  711. 286	val_286	1
    712. 

  712. 287	val_287	1
    713. 

  713. 288	val_288	1
    714. 

  714. 289	val_289	1
    715. 

  715. 291	val_291	1
    716. 

  716. 292	val_292	1
    717. 

  717. 296	val_296	1
    718. 

  718. 298	val_298	1
    719. 

  719. 30	val_30	1
    720. 

  720. 302	val_302	1
    721. 

  721. 305	val_305	1
    722. 

  722. 306	val_306	1
    723. 

  723. 307	val_307	1
    724. 

  724. 308	val_308	1
    725. 

  725. 309	val_309	1
    726. 

  726. 310	val_310	1
    727. 

  727. 311	val_311	1
    728. 

  728. 315	val_315	1
    729. 

  729. 316	val_316	1
    730. 

  730. 317	val_317	1
    731. 

  731. 318	val_318	1
    732. 

  732. 321	val_321	1
    733. 

  733. 322	val_322	1
    734. 

  734. 323	val_323	1
    735. 

  735. 325	val_325	1
    736. 

  736. 327	val_327	1
    737. 

  737. 33	val_33	1
    738. 

  738. 331	val_331	1
    739. 

  739. 332	val_332	1
    740. 

  740. 333	val_333	1
    741. 

  741. 335	val_335	1
    742. 

  742. 336	val_336	1
    743. 

  743. 338	val_338	1
    744. 

  744. 339	val_339	1
    745. 

  745. 34	val_34	1
    746. 

  746. 341	val_341	1
    747. 

  747. 342	val_342	1
    748. 

  748. 344	val_344	1
    749. 

  749. 345	val_345	1
    750. 

  750. 348	val_348	1
    751. 

  751. 35	val_35	1
    752. 

  752. 351	val_351	1
    753. 

  753. 353	val_353	1
    754. 

  754. 356	val_356	1
    755. 

  755. 360	val_360	1
    756. 

  756. 362	val_362	1
    757. 

  757. 364	val_364	1
    758. 

  758. 365	val_365	1
    759. 

  759. 366	val_366	1
    760. 

  760. 367	val_367	1
    761. 

  761. 368	val_368	1
    762. 

  762. 369	val_369	1
    763. 

  763. 37	val_37	1
    764. 

  764. 373	val_373	1
    765. 

  765. 374	val_374	1
    766. 

  766. 375	val_375	1
    767. 

  767. 377	val_377	1
    768. 

  768. 378	val_378	1
    769. 

  769. 379	val_379	1
    770. 

  770. 382	val_382	1
    771. 

  771. 384	val_384	1
    772. 

  772. 386	val_386	1
    773. 

  773. 389	val_389	1
    774. 

  774. 392	val_392	1
    775. 

  775. 393	val_393	1
    776. 

  776. 394	val_394	1
    777. 

  777. 395	val_395	1
    778. 

  778. 396	val_396	1
    779. 

  779. 397	val_397	1
    780. 

  780. 399	val_399	1
    781. 

  781. 4	val_4	1
    782. 

  782. 400	val_400	1
    783. 

  783. 401	val_401	1
    784. 

  784. 402	val_402	1
    785. 

  785. 403	val_403	1
    786. 

  786. 404	val_404	1
    787. 

  787. 406	val_406	1
    788. 

  788. 407	val_407	1
    789. 

  789. 409	val_409	1
    790. 

  790. 41	val_41	1
    791. 

  791. 411	val_411	1
    792. 

  792. 413	val_413	1
    793. 

  793. 414	val_414	1
    794. 

  794. 417	val_417	1
    795. 

  795. 418	val_418	1
    796. 

  796. 419	val_419	1
    797. 

  797. 42	val_42	1
    798. 

  798. 421	val_421	1
    799. 

  799. 424	val_424	1
    800. 

  800. 427	val_427	1
    801. 

  801. 429	val_429	1
    802. 

  802. 43	val_43	1
    803. 

  803. 430	val_430	1
    804. 

  804. 431	val_431	1
    805. 

  805. 432	val_432	1
    806. 

  806. 435	val_435	1
    807. 

  807. 436	val_436	1
    808. 

  808. 437	val_437	1
    809. 

  809. 438	val_438	1
    810. 

  810. 439	val_439	1
    811. 

  811. 44	val_44	1
    812. 

  812. 443	val_443	1
    813. 

  813. 444	val_444	1
    814. 

  814. 446	val_446	1
    815. 

  815. 448	val_448	1
    816. 

  816. 449	val_449	1
    817. 

  817. 452	val_452	1
    818. 

  818. 453	val_453	1
    819. 

  819. 454	val_454	1
    820. 

  820. 455	val_455	1
    821. 

  821. 457	val_457	1
    822. 

  822. 458	val_458	1
    823. 

  823. 459	val_459	1
    824. 

  824. 460	val_460	1
    825. 

  825. 462	val_462	1
    826. 

  826. 463	val_463	1
    827. 

  827. 466	val_466	1
    828. 

  828. 467	val_467	1
    829. 

  829. 468	val_468	1
    830. 

  830. 469	val_469	1
    831. 

  831. 47	val_47	1
    832. 

  832. 470	val_470	1
    833. 

  833. 472	val_472	1
    834. 

  834. 475	val_475	1
    835. 

  835. 477	val_477	1
    836. 

  836. 478	val_478	1
    837. 

  837. 479	val_479	1
    838. 

  838. 480	val_480	1
    839. 

  839. 481	val_481	1
    840. 

  840. 482	val_482	1
    841. 

  841. 483	val_483	1
    842. 

  842. 484	val_484	1
    843. 

  843. 485	val_485	1
    844. 

  844. 487	val_487	1
    845. 

  845. 489	val_489	1
    846. 

  846. 490	val_490	1
    847. 

  847. 491	val_491	1
    848. 

  848. 492	val_492	1
    849. 

  849. 493	val_493	1
    850. 

  850. 494	val_494	1
    851. 

  851. 495	val_495	1
    852. 

  852. 496	val_496	1
    853. 

  853. 497	val_497	1
    854. 

  854. 498	val_498	1
    855. 

  855. 5	val_5	1
    856. 

  856. 51	val_51	1
    857. 

  857. 53	val_53	1
    858. 

  858. 54	val_54	1
    859. 

  859. 57	val_57	1
    860. 

  860. 58	val_58	1
    861. 

  861. 64	val_64	1
    862. 

  862. 65	val_65	1
    863. 

  863. 66	val_66	1
    864. 

  864. 67	val_67	1
    865. 

  865. 69	val_69	1
    866. 

  866. 70	val_70	1
    867. 

  867. 72	val_72	1
    868. 

  868. 74	val_74	1
    869. 

  869. 76	val_76	1
    870. 

  870. 77	val_77	1
    871. 

  871. 78	val_78	1
    872. 

  872. 8	val_8	1
    873. 

  873. 80	val_80	1
    874. 

  874. 82	val_82	1
    875. 

  875. 83	val_83	1
    876. 

  876. 84	val_84	1
    877. 

  877. 85	val_85	1
    878. 

  878. 86	val_86	1
    879. 

  879. 87	val_87	1
    880. 

  880. 9	val_9	1
    881. 

  881. 90	val_90	1
    882. 

  882. 92	val_92	1
    883. 

  883. 95	val_95	1
    884. 

  884. 96	val_96	1
    885. 

  885. 97	val_97	1
    886. 

  886. 98	val_98	1
    887. 

  887.