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

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/union17.q.out

#
text | 961 lines | 947 code | 14 blank | 0 comment | 0 complexity | 16c76637a105fc1ac4af720abaa92c45 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

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

  2. PREHOOK: type: CREATETABLE
    3. 

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

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@DEST1
    6. 

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

  7. PREHOOK: type: CREATETABLE
    8. 

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

  9. POSTHOOK: type: CREATETABLE
    10. 

  10. POSTHOOK: Output: default@DEST2
    11. 

  11. PREHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
    12. 

  12. 

  13. explain 
    14. 

  14. FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
    15. 

  15.                          UNION  ALL  
    16. 

  16.       select s2.key as key, s2.value as value from src s2) unionsrc
    17. 

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

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

  19. PREHOOK: type: QUERY
    20. 

  20. POSTHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
    21. 

  21. 

  22. explain 
    23. 

  23. FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
    24. 

  24.                          UNION  ALL  
    25. 

  25.       select s2.key as key, s2.value as value from src s2) unionsrc
    26. 

  26. INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
    27. 

  27. INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
    28. 

  28. POSTHOOK: type: QUERY
    29. 

  29. ABSTRACT SYNTAX TREE:
    30. 

  30.   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key) (TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME DEST1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL unionsrc) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL unionsrc) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME DEST2))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) value)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL unionsrc) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL unionsrc) key) (. (TOK_TABLE_OR_COL unionsrc) value))))
    31. 

  31. 

  32. STAGE DEPENDENCIES:
    33. 

  33.   Stage-2 is a root stage
    34. 

  34.   Stage-3 depends on stages: Stage-2, Stage-8
    35. 

  35.   Stage-4 depends on stages: Stage-3
    36. 

  36.   Stage-0 depends on stages: Stage-4
    37. 

  37.   Stage-5 depends on stages: Stage-0
    38. 

  38.   Stage-6 depends on stages: Stage-3
    39. 

  39.   Stage-1 depends on stages: Stage-6
    40. 

  40.   Stage-7 depends on stages: Stage-1
    41. 

  41.   Stage-8 is a root stage
    42. 

  42. 

  43. STAGE PLANS:
    44. 

  44.   Stage: Stage-2
    45. 

  45.     Map Reduce
    46. 

  46.       Alias -> Map Operator Tree:
    47. 

  47.         null-subquery1:unionsrc-subquery1:s1 
    48. 

  48.           TableScan
    49. 

  49.             alias: s1
    50. 

  50.             Select Operator
    51. 

  51.               Group By Operator
    52. 

  52.                 aggregations:
    53. 

  53.                       expr: count(1)
    54. 

  54.                 bucketGroup: false
    55. 

  55.                 mode: hash
    56. 

  56.                 outputColumnNames: _col0
    57. 

  57.                 Reduce Output Operator
    58. 

  58.                   sort order: 
    59. 

  59.                   tag: -1
    60. 

  60.                   value expressions:
    61. 

  61.                         expr: _col0
    62. 

  62.                         type: bigint
    63. 

  63.       Reduce Operator Tree:
    64. 

  64.         Group By Operator
    65. 

  65.           aggregations:
    66. 

  66.                 expr: count(VALUE._col0)
    67. 

  67.           bucketGroup: false
    68. 

  68.           mode: mergepartial
    69. 

  69.           outputColumnNames: _col0
    70. 

  70.           Select Operator
    71. 

  71.             expressions:
    72. 

  72.                   expr: 'tst1'
    73. 

  73.                   type: string
    74. 

  74.                   expr: UDFToString(_col0)
    75. 

  75.                   type: string
    76. 

  76.             outputColumnNames: _col0, _col1
    77. 

  77.             File Output Operator
    78. 

  78.               compressed: false
    79. 

  79.               GlobalTableId: 0
    80. 

  80.               table:
    81. 

  81.                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    82. 

  82.                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    83. 

  83. 

  84.   Stage: Stage-3
    85. 

  85.     Map Reduce
    86. 

  86.       Alias -> Map Operator Tree:
    87. 

  87.         file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10004 
    88. 

  88.           Union
    89. 

  89.             Reduce Output Operator
    90. 

  90.               key expressions:
    91. 

  91.                     expr: substr(_col1, 5)
    92. 

  92.                     type: string
    93. 

  93.               sort order: +
    94. 

  94.               Map-reduce partition columns:
    95. 

  95.                     expr: substr(_col1, 5)
    96. 

  96.                     type: string
    97. 

  97.               tag: -1
    98. 

  98.               value expressions:
    99. 

  99.                     expr: _col0
    100. 

  100.                     type: string
    101. 

  101.                     expr: _col1
    102. 

  102.                     type: string
    103. 

  103.         file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10007 
    104. 

  104.           Union
    105. 

  105.             Reduce Output Operator
    106. 

  106.               key expressions:
    107. 

  107.                     expr: substr(_col1, 5)
    108. 

  108.                     type: string
    109. 

  109.               sort order: +
    110. 

  110.               Map-reduce partition columns:
    111. 

  111.                     expr: substr(_col1, 5)
    112. 

  112.                     type: string
    113. 

  113.               tag: -1
    114. 

  114.               value expressions:
    115. 

  115.                     expr: _col0
    116. 

  116.                     type: string
    117. 

  117.                     expr: _col1
    118. 

  118.                     type: string
    119. 

  119.       Reduce Operator Tree:
    120. 

  120.         Forward
    121. 

  121.           Group By Operator
    122. 

  122.             aggregations:
    123. 

  123.                   expr: count(DISTINCT KEY._col0)
    124. 

  124.             bucketGroup: false
    125. 

  125.             keys:
    126. 

  126.                   expr: VALUE._col0
    127. 

  127.                   type: string
    128. 

  128.             mode: hash
    129. 

  129.             outputColumnNames: _col0, _col1
    130. 

  130.             File Output Operator
    131. 

  131.               compressed: false
    132. 

  132.               GlobalTableId: 0
    133. 

  133.               table:
    134. 

  134.                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    135. 

  135.                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    136. 

  136.           Group By Operator
    137. 

  137.             aggregations:
    138. 

  138.                   expr: count(DISTINCT KEY._col0)
    139. 

  139.             bucketGroup: false
    140. 

  140.             keys:
    141. 

  141.                   expr: VALUE._col0
    142. 

  142.                   type: string
    143. 

  143.                   expr: VALUE._col1
    144. 

  144.                   type: string
    145. 

  145.             mode: hash
    146. 

  146.             outputColumnNames: _col0, _col1, _col2
    147. 

  147.             File Output Operator
    148. 

  148.               compressed: false
    149. 

  149.               GlobalTableId: 0
    150. 

  150.               table:
    151. 

  151.                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    152. 

  152.                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    153. 

  153. 

  154.   Stage: Stage-4
    155. 

  155.     Map Reduce
    156. 

  156.       Alias -> Map Operator Tree:
    157. 

  157.         file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10005 
    158. 

  158.             Reduce Output Operator
    159. 

  159.               key expressions:
    160. 

  160.                     expr: _col0
    161. 

  161.                     type: string
    162. 

  162.               sort order: +
    163. 

  163.               Map-reduce partition columns:
    164. 

  164.                     expr: _col0
    165. 

  165.                     type: string
    166. 

  166.               tag: -1
    167. 

  167.               value expressions:
    168. 

  168.                     expr: _col1
    169. 

  169.                     type: bigint
    170. 

  170.       Reduce Operator Tree:
    171. 

  171.         Group By Operator
    172. 

  172.           aggregations:
    173. 

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

  174.           bucketGroup: false
    175. 

  175.           keys:
    176. 

  176.                 expr: KEY._col0
    177. 

  177.                 type: string
    178. 

  178.           mode: final
    179. 

  179.           outputColumnNames: _col0, _col1
    180. 

  180.           Select Operator
    181. 

  181.             expressions:
    182. 

  182.                   expr: _col0
    183. 

  183.                   type: string
    184. 

  184.                   expr: _col1
    185. 

  185.                   type: bigint
    186. 

  186.             outputColumnNames: _col0, _col1
    187. 

  187.             File Output Operator
    188. 

  188.               compressed: false
    189. 

  189.               GlobalTableId: 1
    190. 

  190.               table:
    191. 

  191.                   input format: org.apache.hadoop.mapred.TextInputFormat
    192. 

  192.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    193. 

  193.                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    194. 

  194.                   name: default.dest1
    195. 

  195. 

  196.   Stage: Stage-0
    197. 

  197.     Move Operator
    198. 

  198.       tables:
    199. 

  199.           replace: true
    200. 

  200.           table:
    201. 

  201.               input format: org.apache.hadoop.mapred.TextInputFormat
    202. 

  202.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    203. 

  203.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    204. 

  204.               name: default.dest1
    205. 

  205. 

  206.   Stage: Stage-5
    207. 

  207.     Stats-Aggr Operator
    208. 

  208. 

  209.   Stage: Stage-6
    210. 

  210.     Map Reduce
    211. 

  211.       Alias -> Map Operator Tree:
    212. 

  212.         file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10006 
    213. 

  213.             Reduce Output Operator
    214. 

  214.               key expressions:
    215. 

  215.                     expr: _col0
    216. 

  216.                     type: string
    217. 

  217.                     expr: _col1
    218. 

  218.                     type: string
    219. 

  219.               sort order: ++
    220. 

  220.               Map-reduce partition columns:
    221. 

  221.                     expr: _col0
    222. 

  222.                     type: string
    223. 

  223.                     expr: _col1
    224. 

  224.                     type: string
    225. 

  225.               tag: -1
    226. 

  226.               value expressions:
    227. 

  227.                     expr: _col2
    228. 

  228.                     type: bigint
    229. 

  229.       Reduce Operator Tree:
    230. 

  230.         Group By Operator
    231. 

  231.           aggregations:
    232. 

  232.                 expr: count(VALUE._col0)
    233. 

  233.           bucketGroup: false
    234. 

  234.           keys:
    235. 

  235.                 expr: KEY._col0
    236. 

  236.                 type: string
    237. 

  237.                 expr: KEY._col1
    238. 

  238.                 type: string
    239. 

  239.           mode: final
    240. 

  240.           outputColumnNames: _col0, _col1, _col2
    241. 

  241.           Select Operator
    242. 

  242.             expressions:
    243. 

  243.                   expr: _col0
    244. 

  244.                   type: string
    245. 

  245.                   expr: _col1
    246. 

  246.                   type: string
    247. 

  247.                   expr: _col2
    248. 

  248.                   type: bigint
    249. 

  249.             outputColumnNames: _col0, _col1, _col2
    250. 

  250.             File Output Operator
    251. 

  251.               compressed: false
    252. 

  252.               GlobalTableId: 2
    253. 

  253.               table:
    254. 

  254.                   input format: org.apache.hadoop.mapred.TextInputFormat
    255. 

  255.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    256. 

  256.                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    257. 

  257.                   name: default.dest2
    258. 

  258. 

  259.   Stage: Stage-1
    260. 

  260.     Move Operator
    261. 

  261.       tables:
    262. 

  262.           replace: true
    263. 

  263.           table:
    264. 

  264.               input format: org.apache.hadoop.mapred.TextInputFormat
    265. 

  265.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    266. 

  266.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    267. 

  267.               name: default.dest2
    268. 

  268. 

  269.   Stage: Stage-7
    270. 

  270.     Stats-Aggr Operator
    271. 

  271. 

  272.   Stage: Stage-8
    273. 

  273.     Map Reduce
    274. 

  274.       Alias -> Map Operator Tree:
    275. 

  275.         null-subquery2:unionsrc-subquery2:s2 
    276. 

  276.           TableScan
    277. 

  277.             alias: s2
    278. 

  278.             Select Operator
    279. 

  279.               expressions:
    280. 

  280.                     expr: key
    281. 

  281.                     type: string
    282. 

  282.                     expr: value
    283. 

  283.                     type: string
    284. 

  284.               outputColumnNames: _col0, _col1
    285. 

  285.               File Output Operator
    286. 

  286.                 compressed: false
    287. 

  287.                 GlobalTableId: 0
    288. 

  288.                 table:
    289. 

  289.                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    290. 

  290.                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    291. 

  291. 

  292. 

  293. PREHOOK: query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
    294. 

  294.                          UNION  ALL  
    295. 

  295.       select s2.key as key, s2.value as value from src s2) unionsrc
    296. 

  296. INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
    297. 

  297. INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
    298. 

  298. PREHOOK: type: QUERY
    299. 

  299. PREHOOK: Input: default@src
    300. 

  300. PREHOOK: Output: default@dest1
    301. 

  301. PREHOOK: Output: default@dest2
    302. 

  302. POSTHOOK: query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
    303. 

  303.                          UNION  ALL  
    304. 

  304.       select s2.key as key, s2.value as value from src s2) unionsrc
    305. 

  305. INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
    306. 

  306. INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
    307. 

  307. POSTHOOK: type: QUERY
    308. 

  308. POSTHOOK: Input: default@src
    309. 

  309. POSTHOOK: Output: default@dest1
    310. 

  310. POSTHOOK: Output: default@dest2
    311. 

  311. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
    312. 

  312. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    313. 

  313. POSTHOOK: Lineage: dest2.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
    314. 

  314. POSTHOOK: Lineage: dest2.val1 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    315. 

  315. POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    316. 

  316. PREHOOK: query: SELECT DEST1.* FROM DEST1
    317. 

  317. PREHOOK: type: QUERY
    318. 

  318. PREHOOK: Input: default@dest1
    319. 

  319. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_560_4410894515392312905/-mr-10000
    320. 

  320. POSTHOOK: query: SELECT DEST1.* FROM DEST1
    321. 

  321. POSTHOOK: type: QUERY
    322. 

  322. POSTHOOK: Input: default@dest1
    323. 

  323. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_560_4410894515392312905/-mr-10000
    324. 

  324. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
    325. 

  325. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    326. 

  326. POSTHOOK: Lineage: dest2.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
    327. 

  327. POSTHOOK: Lineage: dest2.val1 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    328. 

  328. POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    329. 

  329. 0	1
    330. 

  330. 10	1
    331. 

  331. 100	1
    332. 

  332. 103	1
    333. 

  333. 104	1
    334. 

  334. 105	1
    335. 

  335. 11	1
    336. 

  336. 111	1
    337. 

  337. 113	1
    338. 

  338. 114	1
    339. 

  339. 116	1
    340. 

  340. 118	1
    341. 

  341. 119	1
    342. 

  342. 12	1
    343. 

  343. 120	1
    344. 

  344. 125	1
    345. 

  345. 126	1
    346. 

  346. 128	1
    347. 

  347. 129	1
    348. 

  348. 131	1
    349. 

  349. 133	1
    350. 

  350. 134	1
    351. 

  351. 136	1
    352. 

  352. 137	1
    353. 

  353. 138	1
    354. 

  354. 143	1
    355. 

  355. 145	1
    356. 

  356. 146	1
    357. 

  357. 149	1
    358. 

  358. 15	1
    359. 

  359. 150	1
    360. 

  360. 152	1
    361. 

  361. 153	1
    362. 

  362. 155	1
    363. 

  363. 156	1
    364. 

  364. 157	1
    365. 

  365. 158	1
    366. 

  366. 160	1
    367. 

  367. 162	1
    368. 

  368. 163	1
    369. 

  369. 164	1
    370. 

  370. 165	1
    371. 

  371. 166	1
    372. 

  372. 167	1
    373. 

  373. 168	1
    374. 

  374. 169	1
    375. 

  375. 17	1
    376. 

  376. 170	1
    377. 

  377. 172	1
    378. 

  378. 174	1
    379. 

  379. 175	1
    380. 

  380. 176	1
    381. 

  381. 177	1
    382. 

  382. 178	1
    383. 

  383. 179	1
    384. 

  384. 18	1
    385. 

  385. 180	1
    386. 

  386. 181	1
    387. 

  387. 183	1
    388. 

  388. 186	1
    389. 

  389. 187	1
    390. 

  390. 189	1
    391. 

  391. 19	1
    392. 

  392. 190	1
    393. 

  393. 191	1
    394. 

  394. 192	1
    395. 

  395. 193	1
    396. 

  396. 194	1
    397. 

  397. 195	1
    398. 

  398. 196	1
    399. 

  399. 197	1
    400. 

  400. 199	1
    401. 

  401. 2	1
    402. 

  402. 20	1
    403. 

  403. 200	1
    404. 

  404. 201	1
    405. 

  405. 202	1
    406. 

  406. 203	1
    407. 

  407. 205	1
    408. 

  408. 207	1
    409. 

  409. 208	1
    410. 

  410. 209	1
    411. 

  411. 213	1
    412. 

  412. 214	1
    413. 

  413. 216	1
    414. 

  414. 217	1
    415. 

  415. 218	1
    416. 

  416. 219	1
    417. 

  417. 221	1
    418. 

  418. 222	1
    419. 

  419. 223	1
    420. 

  420. 224	1
    421. 

  421. 226	1
    422. 

  422. 228	1
    423. 

  423. 229	1
    424. 

  424. 230	1
    425. 

  425. 233	1
    426. 

  426. 235	1
    427. 

  427. 237	1
    428. 

  428. 238	1
    429. 

  429. 239	1
    430. 

  430. 24	1
    431. 

  431. 241	1
    432. 

  432. 242	1
    433. 

  433. 244	1
    434. 

  434. 247	1
    435. 

  435. 248	1
    436. 

  436. 249	1
    437. 

  437. 252	1
    438. 

  438. 255	1
    439. 

  439. 256	1
    440. 

  440. 257	1
    441. 

  441. 258	1
    442. 

  442. 26	1
    443. 

  443. 260	1
    444. 

  444. 262	1
    445. 

  445. 263	1
    446. 

  446. 265	1
    447. 

  447. 266	1
    448. 

  448. 27	1
    449. 

  449. 272	1
    450. 

  450. 273	1
    451. 

  451. 274	1
    452. 

  452. 275	1
    453. 

  453. 277	1
    454. 

  454. 278	1
    455. 

  455. 28	1
    456. 

  456. 280	1
    457. 

  457. 281	1
    458. 

  458. 282	1
    459. 

  459. 283	1
    460. 

  460. 284	1
    461. 

  461. 285	1
    462. 

  462. 286	1
    463. 

  463. 287	1
    464. 

  464. 288	1
    465. 

  465. 289	1
    466. 

  466. 291	1
    467. 

  467. 292	1
    468. 

  468. 296	1
    469. 

  469. 298	1
    470. 

  470. 30	1
    471. 

  471. 302	1
    472. 

  472. 305	1
    473. 

  473. 306	1
    474. 

  474. 307	1
    475. 

  475. 308	1
    476. 

  476. 309	1
    477. 

  477. 310	1
    478. 

  478. 311	1
    479. 

  479. 315	1
    480. 

  480. 316	1
    481. 

  481. 317	1
    482. 

  482. 318	1
    483. 

  483. 321	1
    484. 

  484. 322	1
    485. 

  485. 323	1
    486. 

  486. 325	1
    487. 

  487. 327	1
    488. 

  488. 33	1
    489. 

  489. 331	1
    490. 

  490. 332	1
    491. 

  491. 333	1
    492. 

  492. 335	1
    493. 

  493. 336	1
    494. 

  494. 338	1
    495. 

  495. 339	1
    496. 

  496. 34	1
    497. 

  497. 341	1
    498. 

  498. 342	1
    499. 

  499. 344	1
    500. 

  500. 345	1
    501. 

  501. 348	1
    502. 

  502. 35	1
    503. 

  503. 351	1
    504. 

  504. 353	1
    505. 

  505. 356	1
    506. 

  506. 360	1
    507. 

  507. 362	1
    508. 

  508. 364	1
    509. 

  509. 365	1
    510. 

  510. 366	1
    511. 

  511. 367	1
    512. 

  512. 368	1
    513. 

  513. 369	1
    514. 

  514. 37	1
    515. 

  515. 373	1
    516. 

  516. 374	1
    517. 

  517. 375	1
    518. 

  518. 377	1
    519. 

  519. 378	1
    520. 

  520. 379	1
    521. 

  521. 382	1
    522. 

  522. 384	1
    523. 

  523. 386	1
    524. 

  524. 389	1
    525. 

  525. 392	1
    526. 

  526. 393	1
    527. 

  527. 394	1
    528. 

  528. 395	1
    529. 

  529. 396	1
    530. 

  530. 397	1
    531. 

  531. 399	1
    532. 

  532. 4	1
    533. 

  533. 400	1
    534. 

  534. 401	1
    535. 

  535. 402	1
    536. 

  536. 403	1
    537. 

  537. 404	1
    538. 

  538. 406	1
    539. 

  539. 407	1
    540. 

  540. 409	1
    541. 

  541. 41	1
    542. 

  542. 411	1
    543. 

  543. 413	1
    544. 

  544. 414	1
    545. 

  545. 417	1
    546. 

  546. 418	1
    547. 

  547. 419	1
    548. 

  548. 42	1
    549. 

  549. 421	1
    550. 

  550. 424	1
    551. 

  551. 427	1
    552. 

  552. 429	1
    553. 

  553. 43	1
    554. 

  554. 430	1
    555. 

  555. 431	1
    556. 

  556. 432	1
    557. 

  557. 435	1
    558. 

  558. 436	1
    559. 

  559. 437	1
    560. 

  560. 438	1
    561. 

  561. 439	1
    562. 

  562. 44	1
    563. 

  563. 443	1
    564. 

  564. 444	1
    565. 

  565. 446	1
    566. 

  566. 448	1
    567. 

  567. 449	1
    568. 

  568. 452	1
    569. 

  569. 453	1
    570. 

  570. 454	1
    571. 

  571. 455	1
    572. 

  572. 457	1
    573. 

  573. 458	1
    574. 

  574. 459	1
    575. 

  575. 460	1
    576. 

  576. 462	1
    577. 

  577. 463	1
    578. 

  578. 466	1
    579. 

  579. 467	1
    580. 

  580. 468	1
    581. 

  581. 469	1
    582. 

  582. 47	1
    583. 

  583. 470	1
    584. 

  584. 472	1
    585. 

  585. 475	1
    586. 

  586. 477	1
    587. 

  587. 478	1
    588. 

  588. 479	1
    589. 

  589. 480	1
    590. 

  590. 481	1
    591. 

  591. 482	1
    592. 

  592. 483	1
    593. 

  593. 484	1
    594. 

  594. 485	1
    595. 

  595. 487	1
    596. 

  596. 489	1
    597. 

  597. 490	1
    598. 

  598. 491	1
    599. 

  599. 492	1
    600. 

  600. 493	1
    601. 

  601. 494	1
    602. 

  602. 495	1
    603. 

  603. 496	1
    604. 

  604. 497	1
    605. 

  605. 498	1
    606. 

  606. 5	1
    607. 

  607. 51	1
    608. 

  608. 53	1
    609. 

  609. 54	1
    610. 

  610. 57	1
    611. 

  611. 58	1
    612. 

  612. 64	1
    613. 

  613. 65	1
    614. 

  614. 66	1
    615. 

  615. 67	1
    616. 

  616. 69	1
    617. 

  617. 70	1
    618. 

  618. 72	1
    619. 

  619. 74	1
    620. 

  620. 76	1
    621. 

  621. 77	1
    622. 

  622. 78	1
    623. 

  623. 8	1
    624. 

  624. 80	1
    625. 

  625. 82	1
    626. 

  626. 83	1
    627. 

  627. 84	1
    628. 

  628. 85	1
    629. 

  629. 86	1
    630. 

  630. 87	1
    631. 

  631. 9	1
    632. 

  632. 90	1
    633. 

  633. 92	1
    634. 

  634. 95	1
    635. 

  635. 96	1
    636. 

  636. 97	1
    637. 

  637. 98	1
    638. 

  638. tst1	1
    639. 

  639. PREHOOK: query: SELECT DEST2.* FROM DEST2
    640. 

  640. PREHOOK: type: QUERY
    641. 

  641. PREHOOK: Input: default@dest2
    642. 

  642. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_948_8332394278542218529/-mr-10000
    643. 

  643. POSTHOOK: query: SELECT DEST2.* FROM DEST2
    644. 

  644. POSTHOOK: type: QUERY
    645. 

  645. POSTHOOK: Input: default@dest2
    646. 

  646. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_948_8332394278542218529/-mr-10000
    647. 

  647. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
    648. 

  648. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    649. 

  649. POSTHOOK: Lineage: dest2.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
    650. 

  650. POSTHOOK: Lineage: dest2.val1 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    651. 

  651. POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
    652. 

  652. 0	val_0	1
    653. 

  653. 10	val_10	1
    654. 

  654. 100	val_100	1
    655. 

  655. 103	val_103	1
    656. 

  656. 104	val_104	1
    657. 

  657. 105	val_105	1
    658. 

  658. 11	val_11	1
    659. 

  659. 111	val_111	1
    660. 

  660. 113	val_113	1
    661. 

  661. 114	val_114	1
    662. 

  662. 116	val_116	1
    663. 

  663. 118	val_118	1
    664. 

  664. 119	val_119	1
    665. 

  665. 12	val_12	1
    666. 

  666. 120	val_120	1
    667. 

  667. 125	val_125	1
    668. 

  668. 126	val_126	1
    669. 

  669. 128	val_128	1
    670. 

  670. 129	val_129	1
    671. 

  671. 131	val_131	1
    672. 

  672. 133	val_133	1
    673. 

  673. 134	val_134	1
    674. 

  674. 136	val_136	1
    675. 

  675. 137	val_137	1
    676. 

  676. 138	val_138	1
    677. 

  677. 143	val_143	1
    678. 

  678. 145	val_145	1
    679. 

  679. 146	val_146	1
    680. 

  680. 149	val_149	1
    681. 

  681. 15	val_15	1
    682. 

  682. 150	val_150	1
    683. 

  683. 152	val_152	1
    684. 

  684. 153	val_153	1
    685. 

  685. 155	val_155	1
    686. 

  686. 156	val_156	1
    687. 

  687. 157	val_157	1
    688. 

  688. 158	val_158	1
    689. 

  689. 160	val_160	1
    690. 

  690. 162	val_162	1
    691. 

  691. 163	val_163	1
    692. 

  692. 164	val_164	1
    693. 

  693. 165	val_165	1
    694. 

  694. 166	val_166	1
    695. 

  695. 167	val_167	1
    696. 

  696. 168	val_168	1
    697. 

  697. 169	val_169	1
    698. 

  698. 17	val_17	1
    699. 

  699. 170	val_170	1
    700. 

  700. 172	val_172	1
    701. 

  701. 174	val_174	1
    702. 

  702. 175	val_175	1
    703. 

  703. 176	val_176	1
    704. 

  704. 177	val_177	1
    705. 

  705. 178	val_178	1
    706. 

  706. 179	val_179	1
    707. 

  707. 18	val_18	1
    708. 

  708. 180	val_180	1
    709. 

  709. 181	val_181	1
    710. 

  710. 183	val_183	1
    711. 

  711. 186	val_186	1
    712. 

  712. 187	val_187	1
    713. 

  713. 189	val_189	1
    714. 

  714. 19	val_19	1
    715. 

  715. 190	val_190	1
    716. 

  716. 191	val_191	1
    717. 

  717. 192	val_192	1
    718. 

  718. 193	val_193	1
    719. 

  719. 194	val_194	1
    720. 

  720. 195	val_195	1
    721. 

  721. 196	val_196	1
    722. 

  722. 197	val_197	1
    723. 

  723. 199	val_199	1
    724. 

  724. 2	val_2	1
    725. 

  725. 20	val_20	1
    726. 

  726. 200	val_200	1
    727. 

  727. 201	val_201	1
    728. 

  728. 202	val_202	1
    729. 

  729. 203	val_203	1
    730. 

  730. 205	val_205	1
    731. 

  731. 207	val_207	1
    732. 

  732. 208	val_208	1
    733. 

  733. 209	val_209	1
    734. 

  734. 213	val_213	1
    735. 

  735. 214	val_214	1
    736. 

  736. 216	val_216	1
    737. 

  737. 217	val_217	1
    738. 

  738. 218	val_218	1
    739. 

  739. 219	val_219	1
    740. 

  740. 221	val_221	1
    741. 

  741. 222	val_222	1
    742. 

  742. 223	val_223	1
    743. 

  743. 224	val_224	1
    744. 

  744. 226	val_226	1
    745. 

  745. 228	val_228	1
    746. 

  746. 229	val_229	1
    747. 

  747. 230	val_230	1
    748. 

  748. 233	val_233	1
    749. 

  749. 235	val_235	1
    750. 

  750. 237	val_237	1
    751. 

  751. 238	val_238	1
    752. 

  752. 239	val_239	1
    753. 

  753. 24	val_24	1
    754. 

  754. 241	val_241	1
    755. 

  755. 242	val_242	1
    756. 

  756. 244	val_244	1
    757. 

  757. 247	val_247	1
    758. 

  758. 248	val_248	1
    759. 

  759. 249	val_249	1
    760. 

  760. 252	val_252	1
    761. 

  761. 255	val_255	1
    762. 

  762. 256	val_256	1
    763. 

  763. 257	val_257	1
    764. 

  764. 258	val_258	1
    765. 

  765. 26	val_26	1
    766. 

  766. 260	val_260	1
    767. 

  767. 262	val_262	1
    768. 

  768. 263	val_263	1
    769. 

  769. 265	val_265	1
    770. 

  770. 266	val_266	1
    771. 

  771. 27	val_27	1
    772. 

  772. 272	val_272	1
    773. 

  773. 273	val_273	1
    774. 

  774. 274	val_274	1
    775. 

  775. 275	val_275	1
    776. 

  776. 277	val_277	1
    777. 

  777. 278	val_278	1
    778. 

  778. 28	val_28	1
    779. 

  779. 280	val_280	1
    780. 

  780. 281	val_281	1
    781. 

  781. 282	val_282	1
    782. 

  782. 283	val_283	1
    783. 

  783. 284	val_284	1
    784. 

  784. 285	val_285	1
    785. 

  785. 286	val_286	1
    786. 

  786. 287	val_287	1
    787. 

  787. 288	val_288	1
    788. 

  788. 289	val_289	1
    789. 

  789. 291	val_291	1
    790. 

  790. 292	val_292	1
    791. 

  791. 296	val_296	1
    792. 

  792. 298	val_298	1
    793. 

  793. 30	val_30	1
    794. 

  794. 302	val_302	1
    795. 

  795. 305	val_305	1
    796. 

  796. 306	val_306	1
    797. 

  797. 307	val_307	1
    798. 

  798. 308	val_308	1
    799. 

  799. 309	val_309	1
    800. 

  800. 310	val_310	1
    801. 

  801. 311	val_311	1
    802. 

  802. 315	val_315	1
    803. 

  803. 316	val_316	1
    804. 

  804. 317	val_317	1
    805. 

  805. 318	val_318	1
    806. 

  806. 321	val_321	1
    807. 

  807. 322	val_322	1
    808. 

  808. 323	val_323	1
    809. 

  809. 325	val_325	1
    810. 

  810. 327	val_327	1
    811. 

  811. 33	val_33	1
    812. 

  812. 331	val_331	1
    813. 

  813. 332	val_332	1
    814. 

  814. 333	val_333	1
    815. 

  815. 335	val_335	1
    816. 

  816. 336	val_336	1
    817. 

  817. 338	val_338	1
    818. 

  818. 339	val_339	1
    819. 

  819. 34	val_34	1
    820. 

  820. 341	val_341	1
    821. 

  821. 342	val_342	1
    822. 

  822. 344	val_344	1
    823. 

  823. 345	val_345	1
    824. 

  824. 348	val_348	1
    825. 

  825. 35	val_35	1
    826. 

  826. 351	val_351	1
    827. 

  827. 353	val_353	1
    828. 

  828. 356	val_356	1
    829. 

  829. 360	val_360	1
    830. 

  830. 362	val_362	1
    831. 

  831. 364	val_364	1
    832. 

  832. 365	val_365	1
    833. 

  833. 366	val_366	1
    834. 

  834. 367	val_367	1
    835. 

  835. 368	val_368	1
    836. 

  836. 369	val_369	1
    837. 

  837. 37	val_37	1
    838. 

  838. 373	val_373	1
    839. 

  839. 374	val_374	1
    840. 

  840. 375	val_375	1
    841. 

  841. 377	val_377	1
    842. 

  842. 378	val_378	1
    843. 

  843. 379	val_379	1
    844. 

  844. 382	val_382	1
    845. 

  845. 384	val_384	1
    846. 

  846. 386	val_386	1
    847. 

  847. 389	val_389	1
    848. 

  848. 392	val_392	1
    849. 

  849. 393	val_393	1
    850. 

  850. 394	val_394	1
    851. 

  851. 395	val_395	1
    852. 

  852. 396	val_396	1
    853. 

  853. 397	val_397	1
    854. 

  854. 399	val_399	1
    855. 

  855. 4	val_4	1
    856. 

  856. 400	val_400	1
    857. 

  857. 401	val_401	1
    858. 

  858. 402	val_402	1
    859. 

  859. 403	val_403	1
    860. 

  860. 404	val_404	1
    861. 

  861. 406	val_406	1
    862. 

  862. 407	val_407	1
    863. 

  863. 409	val_409	1
    864. 

  864. 41	val_41	1
    865. 

  865. 411	val_411	1
    866. 

  866. 413	val_413	1
    867. 

  867. 414	val_414	1
    868. 

  868. 417	val_417	1
    869. 

  869. 418	val_418	1
    870. 

  870. 419	val_419	1
    871. 

  871. 42	val_42	1
    872. 

  872. 421	val_421	1
    873. 

  873. 424	val_424	1
    874. 

  874. 427	val_427	1
    875. 

  875. 429	val_429	1
    876. 

  876. 43	val_43	1
    877. 

  877. 430	val_430	1
    878. 

  878. 431	val_431	1
    879. 

  879. 432	val_432	1
    880. 

  880. 435	val_435	1
    881. 

  881. 436	val_436	1
    882. 

  882. 437	val_437	1
    883. 

  883. 438	val_438	1
    884. 

  884. 439	val_439	1
    885. 

  885. 44	val_44	1
    886. 

  886. 443	val_443	1
    887. 

  887. 444	val_444	1
    888. 

  888. 446	val_446	1
    889. 

  889. 448	val_448	1
    890. 

  890. 449	val_449	1
    891. 

  891. 452	val_452	1
    892. 

  892. 453	val_453	1
    893. 

  893. 454	val_454	1
    894. 

  894. 455	val_455	1
    895. 

  895. 457	val_457	1
    896. 

  896. 458	val_458	1
    897. 

  897. 459	val_459	1
    898. 

  898. 460	val_460	1
    899. 

  899. 462	val_462	1
    900. 

  900. 463	val_463	1
    901. 

  901. 466	val_466	1
    902. 

  902. 467	val_467	1
    903. 

  903. 468	val_468	1
    904. 

  904. 469	val_469	1
    905. 

  905. 47	val_47	1
    906. 

  906. 470	val_470	1
    907. 

  907. 472	val_472	1
    908. 

  908. 475	val_475	1
    909. 

  909. 477	val_477	1
    910. 

  910. 478	val_478	1
    911. 

  911. 479	val_479	1
    912. 

  912. 480	val_480	1
    913. 

  913. 481	val_481	1
    914. 

  914. 482	val_482	1
    915. 

  915. 483	val_483	1
    916. 

  916. 484	val_484	1
    917. 

  917. 485	val_485	1
    918. 

  918. 487	val_487	1
    919. 

  919. 489	val_489	1
    920. 

  920. 490	val_490	1
    921. 

  921. 491	val_491	1
    922. 

  922. 492	val_492	1
    923. 

  923. 493	val_493	1
    924. 

  924. 494	val_494	1
    925. 

  925. 495	val_495	1
    926. 

  926. 496	val_496	1
    927. 

  927. 497	val_497	1
    928. 

  928. 498	val_498	1
    929. 

  929. 5	val_5	1
    930. 

  930. 51	val_51	1
    931. 

  931. 53	val_53	1
    932. 

  932. 54	val_54	1
    933. 

  933. 57	val_57	1
    934. 

  934. 58	val_58	1
    935. 

  935. 64	val_64	1
    936. 

  936. 65	val_65	1
    937. 

  937. 66	val_66	1
    938. 

  938. 67	val_67	1
    939. 

  939. 69	val_69	1
    940. 

  940. 70	val_70	1
    941. 

  941. 72	val_72	1
    942. 

  942. 74	val_74	1
    943. 

  943. 76	val_76	1
    944. 

  944. 77	val_77	1
    945. 

  945. 78	val_78	1
    946. 

  946. 8	val_8	1
    947. 

  947. 80	val_80	1
    948. 

  948. 82	val_82	1
    949. 

  949. 83	val_83	1
    950. 

  950. 84	val_84	1
    951. 

  951. 85	val_85	1
    952. 

  952. 86	val_86	1
    953. 

  953. 87	val_87	1
    954. 

  954. 9	val_9	1
    955. 

  955. 90	val_90	1
    956. 

  956. 92	val_92	1
    957. 

  957. 95	val_95	1
    958. 

  958. 96	val_96	1
    959. 

  959. 97	val_97	1
    960. 

  960. 98	val_98	1
    961. 

  961. tst1	500	1
    962. 

  962.