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

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

#
text | 852 lines | 829 code | 23 blank | 0 comment | 0 complexity | 7d7993f7c7f7668b0c05d68ff0c91334 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, value STRING) STORED AS TEXTFILE
    7. 

  7. PREHOOK: type: CREATETABLE
    8. 

  8. POSTHOOK: query: CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE
    9. 

  9. POSTHOOK: type: CREATETABLE
    10. 

  10. POSTHOOK: Output: default@dest2
    11. 

  11. PREHOOK: query: CREATE TABLE dest3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
    12. 

  12. PREHOOK: type: CREATETABLE
    13. 

  13. POSTHOOK: query: CREATE TABLE dest3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
    14. 

  14. POSTHOOK: type: CREATETABLE
    15. 

  15. POSTHOOK: Output: default@dest3
    16. 

  16. PREHOOK: query: EXPLAIN
    17. 

  17. FROM src
    18. 

  18. INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
    19. 

  19. INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
    20. 

  20. INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
    21. 

  21. INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300
    22. 

  22. PREHOOK: type: QUERY
    23. 

  23. POSTHOOK: query: EXPLAIN
    24. 

  24. FROM src
    25. 

  25. INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
    26. 

  26. INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
    27. 

  27. INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
    28. 

  28. INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300
    29. 

  29. POSTHOOK: type: QUERY
    30. 

  30. ABSTRACT SYNTAX TREE:
    31. 

  31.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME src)))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100))) (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_WHERE (and (>= (. (TOK_TABLE_OR_COL src) key) 100) (< (. (TOK_TABLE_OR_COL src) key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest3) (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL src) key) 200) (< (. (TOK_TABLE_OR_COL src) key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/dest4.out')) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (>= (. (TOK_TABLE_OR_COL src) key) 300))))
    32. 

  32. 

  33. STAGE DEPENDENCIES:
    34. 

  34.   Stage-4 is a root stage
    35. 

  35.   Stage-8 depends on stages: Stage-4 , consists of Stage-7, Stage-6
    36. 

  36.   Stage-7
    37. 

  37.   Stage-0 depends on stages: Stage-7, Stage-6
    38. 

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

  39.   Stage-6
    40. 

  40.   Stage-12 depends on stages: Stage-4 , consists of Stage-11, Stage-10
    41. 

  41.   Stage-11
    42. 

  42.   Stage-1 depends on stages: Stage-11, Stage-10
    43. 

  43.   Stage-9 depends on stages: Stage-1
    44. 

  44.   Stage-10
    45. 

  45.   Stage-16 depends on stages: Stage-4 , consists of Stage-15, Stage-14
    46. 

  46.   Stage-15
    47. 

  47.   Stage-2 depends on stages: Stage-15, Stage-14
    48. 

  48.   Stage-13 depends on stages: Stage-2
    49. 

  49.   Stage-14
    50. 

  50.   Stage-19 depends on stages: Stage-4 , consists of Stage-18, Stage-17
    51. 

  51.   Stage-18
    52. 

  52.   Stage-3 depends on stages: Stage-18, Stage-17
    53. 

  53.   Stage-17
    54. 

  54. 

  55. STAGE PLANS:
    56. 

  56.   Stage: Stage-4
    57. 

  57.     Map Reduce
    58. 

  58.       Alias -> Map Operator Tree:
    59. 

  59.         src 
    60. 

  60.           TableScan
    61. 

  61.             alias: src
    62. 

  62.             Filter Operator
    63. 

  63.               predicate:
    64. 

  64.                   expr: (key < 100)
    65. 

  65.                   type: boolean
    66. 

  66.               Select Operator
    67. 

  67.                 expressions:
    68. 

  68.                       expr: key
    69. 

  69.                       type: string
    70. 

  70.                       expr: value
    71. 

  71.                       type: string
    72. 

  72.                 outputColumnNames: _col0, _col1
    73. 

  73.                 Select Operator
    74. 

  74.                   expressions:
    75. 

  75.                         expr: UDFToInteger(_col0)
    76. 

  76.                         type: int
    77. 

  77.                         expr: _col1
    78. 

  78.                         type: string
    79. 

  79.                   outputColumnNames: _col0, _col1
    80. 

  80.                   File Output Operator
    81. 

  81.                     compressed: false
    82. 

  82.                     GlobalTableId: 1
    83. 

  83.                     table:
    84. 

  84.                         input format: org.apache.hadoop.mapred.TextInputFormat
    85. 

  85.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    86. 

  86.                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    87. 

  87.                         name: default.dest1
    88. 

  88.             Filter Operator
    89. 

  89.               predicate:
    90. 

  90.                   expr: ((key >= 100) and (key < 200))
    91. 

  91.                   type: boolean
    92. 

  92.               Select Operator
    93. 

  93.                 expressions:
    94. 

  94.                       expr: key
    95. 

  95.                       type: string
    96. 

  96.                       expr: value
    97. 

  97.                       type: string
    98. 

  98.                 outputColumnNames: _col0, _col1
    99. 

  99.                 Select Operator
    100. 

  100.                   expressions:
    101. 

  101.                         expr: UDFToInteger(_col0)
    102. 

  102.                         type: int
    103. 

  103.                         expr: _col1
    104. 

  104.                         type: string
    105. 

  105.                   outputColumnNames: _col0, _col1
    106. 

  106.                   File Output Operator
    107. 

  107.                     compressed: false
    108. 

  108.                     GlobalTableId: 2
    109. 

  109.                     table:
    110. 

  110.                         input format: org.apache.hadoop.mapred.TextInputFormat
    111. 

  111.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    112. 

  112.                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    113. 

  113.                         name: default.dest2
    114. 

  114.             Filter Operator
    115. 

  115.               predicate:
    116. 

  116.                   expr: ((key >= 200) and (key < 300))
    117. 

  117.                   type: boolean
    118. 

  118.               Select Operator
    119. 

  119.                 expressions:
    120. 

  120.                       expr: key
    121. 

  121.                       type: string
    122. 

  122.                 outputColumnNames: _col0
    123. 

  123.                 Select Operator
    124. 

  124.                   expressions:
    125. 

  125.                         expr: UDFToInteger(_col0)
    126. 

  126.                         type: int
    127. 

  127.                   outputColumnNames: _col0
    128. 

  128.                   File Output Operator
    129. 

  129.                     compressed: false
    130. 

  130.                     GlobalTableId: 3
    131. 

  131.                     table:
    132. 

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

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

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

  135.                         name: default.dest3
    136. 

  136.             Filter Operator
    137. 

  137.               predicate:
    138. 

  138.                   expr: (key >= 300)
    139. 

  139.                   type: boolean
    140. 

  140.               Select Operator
    141. 

  141.                 expressions:
    142. 

  142.                       expr: value
    143. 

  143.                       type: string
    144. 

  144.                 outputColumnNames: _col0
    145. 

  145.                 File Output Operator
    146. 

  146.                   compressed: false
    147. 

  147.                   GlobalTableId: 4
    148. 

  148.                   table:
    149. 

  149.                       input format: org.apache.hadoop.mapred.TextInputFormat
    150. 

  150.                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    151. 

  151. 

  152.   Stage: Stage-8
    153. 

  153.     Conditional Operator
    154. 

  154. 

  155.   Stage: Stage-7
    156. 

  156.     Move Operator
    157. 

  157.       files:
    158. 

  158.           hdfs directory: true
    159. 

  159.           destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10000
    160. 

  160. 

  161.   Stage: Stage-0
    162. 

  162.     Move Operator
    163. 

  163.       tables:
    164. 

  164.           replace: true
    165. 

  165.           table:
    166. 

  166.               input format: org.apache.hadoop.mapred.TextInputFormat
    167. 

  167.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    168. 

  168.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    169. 

  169.               name: default.dest1
    170. 

  170. 

  171.   Stage: Stage-5
    172. 

  172.     Stats-Aggr Operator
    173. 

  173. 

  174.   Stage: Stage-6
    175. 

  175.     Map Reduce
    176. 

  176.       Alias -> Map Operator Tree:
    177. 

  177.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10007 
    178. 

  178.             File Output Operator
    179. 

  179.               compressed: false
    180. 

  180.               GlobalTableId: 0
    181. 

  181.               table:
    182. 

  182.                   input format: org.apache.hadoop.mapred.TextInputFormat
    183. 

  183.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    184. 

  184.                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    185. 

  185.                   name: default.dest1
    186. 

  186. 

  187.   Stage: Stage-12
    188. 

  188.     Conditional Operator
    189. 

  189. 

  190.   Stage: Stage-11
    191. 

  191.     Move Operator
    192. 

  192.       files:
    193. 

  193.           hdfs directory: true
    194. 

  194.           destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10002
    195. 

  195. 

  196.   Stage: Stage-1
    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.dest2
    205. 

  205. 

  206.   Stage: Stage-9
    207. 

  207.     Stats-Aggr Operator
    208. 

  208. 

  209.   Stage: Stage-10
    210. 

  210.     Map Reduce
    211. 

  211.       Alias -> Map Operator Tree:
    212. 

  212.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10008 
    213. 

  213.             File Output Operator
    214. 

  214.               compressed: false
    215. 

  215.               GlobalTableId: 0
    216. 

  216.               table:
    217. 

  217.                   input format: org.apache.hadoop.mapred.TextInputFormat
    218. 

  218.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    219. 

  219.                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    220. 

  220.                   name: default.dest2
    221. 

  221. 

  222.   Stage: Stage-16
    223. 

  223.     Conditional Operator
    224. 

  224. 

  225.   Stage: Stage-15
    226. 

  226.     Move Operator
    227. 

  227.       files:
    228. 

  228.           hdfs directory: true
    229. 

  229.           destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10004
    230. 

  230. 

  231.   Stage: Stage-2
    232. 

  232.     Move Operator
    233. 

  233.       tables:
    234. 

  234.           partition:
    235. 

  235.             ds 2008-04-08
    236. 

  236.             hr 12
    237. 

  237.           replace: true
    238. 

  238.           table:
    239. 

  239.               input format: org.apache.hadoop.mapred.TextInputFormat
    240. 

  240.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    241. 

  241.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    242. 

  242.               name: default.dest3
    243. 

  243. 

  244.   Stage: Stage-13
    245. 

  245.     Stats-Aggr Operator
    246. 

  246. 

  247.   Stage: Stage-14
    248. 

  248.     Map Reduce
    249. 

  249.       Alias -> Map Operator Tree:
    250. 

  250.         pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10009 
    251. 

  251.             File Output Operator
    252. 

  252.               compressed: false
    253. 

  253.               GlobalTableId: 0
    254. 

  254.               table:
    255. 

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

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

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

  258.                   name: default.dest3
    259. 

  259. 

  260.   Stage: Stage-19
    261. 

  261.     Conditional Operator
    262. 

  262. 

  263.   Stage: Stage-18
    264. 

  264.     Move Operator
    265. 

  265.       files:
    266. 

  266.           hdfs directory: true
    267. 

  267.           destination: file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10006
    268. 

  268. 

  269.   Stage: Stage-3
    270. 

  270.     Move Operator
    271. 

  271.       files:
    272. 

  272.           hdfs directory: true
    273. 

  273.           destination: ../build/ql/test/data/warehouse/dest4.out
    274. 

  274. 

  275.   Stage: Stage-17
    276. 

  276.     Map Reduce
    277. 

  277.       Alias -> Map Operator Tree:
    278. 

  278.         file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-53-16_613_1322226487151381018/-ext-10010 
    279. 

  279.             File Output Operator
    280. 

  280.               compressed: false
    281. 

  281.               GlobalTableId: 0
    282. 

  282.               table:
    283. 

  283.                   input format: org.apache.hadoop.mapred.TextInputFormat
    284. 

  284.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    285. 

  285. 

  286. 

  287. PREHOOK: query: FROM src
    288. 

  288. INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
    289. 

  289. INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
    290. 

  290. INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
    291. 

  291. INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300
    292. 

  292. PREHOOK: type: QUERY
    293. 

  293. PREHOOK: Input: default@src
    294. 

  294. PREHOOK: Output: ../build/ql/test/data/warehouse/dest4.out
    295. 

  295. PREHOOK: Output: default@dest1
    296. 

  296. PREHOOK: Output: default@dest2
    297. 

  297. PREHOOK: Output: default@dest3@ds=2008-04-08/hr=12
    298. 

  298. POSTHOOK: query: FROM src
    299. 

  299. INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
    300. 

  300. INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
    301. 

  301. INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
    302. 

  302. INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300
    303. 

  303. POSTHOOK: type: QUERY
    304. 

  304. POSTHOOK: Input: default@src
    305. 

  305. POSTHOOK: Output: ../build/ql/test/data/warehouse/dest4.out
    306. 

  306. POSTHOOK: Output: default@dest1
    307. 

  307. POSTHOOK: Output: default@dest2
    308. 

  308. POSTHOOK: Output: default@dest3@ds=2008-04-08/hr=12
    309. 

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

  310. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    311. 

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

  312. POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    313. 

  313. POSTHOOK: Lineage: dest3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    314. 

  314. PREHOOK: query: SELECT dest1.* FROM dest1
    315. 

  315. PREHOOK: type: QUERY
    316. 

  316. PREHOOK: Input: default@dest1
    317. 

  317. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-22_841_3066800367150585075/-mr-10000
    318. 

  318. POSTHOOK: query: SELECT dest1.* FROM dest1
    319. 

  319. POSTHOOK: type: QUERY
    320. 

  320. POSTHOOK: Input: default@dest1
    321. 

  321. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-22_841_3066800367150585075/-mr-10000
    322. 

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

  323. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    324. 

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

  325. POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    326. 

  326. POSTHOOK: Lineage: dest3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    327. 

  327. 86	val_86
    328. 

  328. 27	val_27
    329. 

  329. 98	val_98
    330. 

  330. 66	val_66
    331. 

  331. 37	val_37
    332. 

  332. 15	val_15
    333. 

  333. 82	val_82
    334. 

  334. 17	val_17
    335. 

  335. 0	val_0
    336. 

  336. 57	val_57
    337. 

  337. 20	val_20
    338. 

  338. 92	val_92
    339. 

  339. 47	val_47
    340. 

  340. 72	val_72
    341. 

  341. 4	val_4
    342. 

  342. 35	val_35
    343. 

  343. 54	val_54
    344. 

  344. 51	val_51
    345. 

  345. 65	val_65
    346. 

  346. 83	val_83
    347. 

  347. 12	val_12
    348. 

  348. 67	val_67
    349. 

  349. 84	val_84
    350. 

  350. 58	val_58
    351. 

  351. 8	val_8
    352. 

  352. 24	val_24
    353. 

  353. 42	val_42
    354. 

  354. 0	val_0
    355. 

  355. 96	val_96
    356. 

  356. 26	val_26
    357. 

  357. 51	val_51
    358. 

  358. 43	val_43
    359. 

  359. 95	val_95
    360. 

  360. 98	val_98
    361. 

  361. 85	val_85
    362. 

  362. 77	val_77
    363. 

  363. 0	val_0
    364. 

  364. 87	val_87
    365. 

  365. 15	val_15
    366. 

  366. 72	val_72
    367. 

  367. 90	val_90
    368. 

  368. 19	val_19
    369. 

  369. 10	val_10
    370. 

  370. 5	val_5
    371. 

  371. 58	val_58
    372. 

  372. 35	val_35
    373. 

  373. 95	val_95
    374. 

  374. 11	val_11
    375. 

  375. 34	val_34
    376. 

  376. 42	val_42
    377. 

  377. 78	val_78
    378. 

  378. 76	val_76
    379. 

  379. 41	val_41
    380. 

  380. 30	val_30
    381. 

  381. 64	val_64
    382. 

  382. 76	val_76
    383. 

  383. 74	val_74
    384. 

  384. 69	val_69
    385. 

  385. 33	val_33
    386. 

  386. 70	val_70
    387. 

  387. 5	val_5
    388. 

  388. 2	val_2
    389. 

  389. 35	val_35
    390. 

  390. 80	val_80
    391. 

  391. 44	val_44
    392. 

  392. 53	val_53
    393. 

  393. 90	val_90
    394. 

  394. 12	val_12
    395. 

  395. 5	val_5
    396. 

  396. 70	val_70
    397. 

  397. 24	val_24
    398. 

  398. 70	val_70
    399. 

  399. 83	val_83
    400. 

  400. 26	val_26
    401. 

  401. 67	val_67
    402. 

  402. 18	val_18
    403. 

  403. 9	val_9
    404. 

  404. 18	val_18
    405. 

  405. 97	val_97
    406. 

  406. 84	val_84
    407. 

  407. 28	val_28
    408. 

  408. 37	val_37
    409. 

  409. 90	val_90
    410. 

  410. 97	val_97
    411. 

  411. PREHOOK: query: SELECT dest2.* FROM dest2
    412. 

  412. PREHOOK: type: QUERY
    413. 

  413. PREHOOK: Input: default@dest2
    414. 

  414. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-23_115_3259629464718805746/-mr-10000
    415. 

  415. POSTHOOK: query: SELECT dest2.* FROM dest2
    416. 

  416. POSTHOOK: type: QUERY
    417. 

  417. POSTHOOK: Input: default@dest2
    418. 

  418. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-23_115_3259629464718805746/-mr-10000
    419. 

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

  420. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    421. 

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

  422. POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    423. 

  423. POSTHOOK: Lineage: dest3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    424. 

  424. 165	val_165
    425. 

  425. 193	val_193
    426. 

  426. 150	val_150
    427. 

  427. 128	val_128
    428. 

  428. 146	val_146
    429. 

  429. 152	val_152
    430. 

  430. 145	val_145
    431. 

  431. 166	val_166
    432. 

  432. 153	val_153
    433. 

  433. 193	val_193
    434. 

  434. 174	val_174
    435. 

  435. 199	val_199
    436. 

  436. 174	val_174
    437. 

  437. 162	val_162
    438. 

  438. 167	val_167
    439. 

  439. 195	val_195
    440. 

  440. 113	val_113
    441. 

  441. 155	val_155
    442. 

  442. 128	val_128
    443. 

  443. 149	val_149
    444. 

  444. 129	val_129
    445. 

  445. 170	val_170
    446. 

  446. 157	val_157
    447. 

  447. 111	val_111
    448. 

  448. 169	val_169
    449. 

  449. 125	val_125
    450. 

  450. 192	val_192
    451. 

  451. 187	val_187
    452. 

  452. 176	val_176
    453. 

  453. 138	val_138
    454. 

  454. 103	val_103
    455. 

  455. 176	val_176
    456. 

  456. 137	val_137
    457. 

  457. 180	val_180
    458. 

  458. 181	val_181
    459. 

  459. 138	val_138
    460. 

  460. 179	val_179
    461. 

  461. 172	val_172
    462. 

  462. 129	val_129
    463. 

  463. 158	val_158
    464. 

  464. 119	val_119
    465. 

  465. 197	val_197
    466. 

  466. 100	val_100
    467. 

  467. 199	val_199
    468. 

  468. 191	val_191
    469. 

  469. 165	val_165
    470. 

  470. 120	val_120
    471. 

  471. 131	val_131
    472. 

  472. 156	val_156
    473. 

  473. 196	val_196
    474. 

  474. 197	val_197
    475. 

  475. 187	val_187
    476. 

  476. 137	val_137
    477. 

  477. 169	val_169
    478. 

  478. 179	val_179
    479. 

  479. 118	val_118
    480. 

  480. 134	val_134
    481. 

  481. 138	val_138
    482. 

  482. 118	val_118
    483. 

  483. 177	val_177
    484. 

  484. 168	val_168
    485. 

  485. 143	val_143
    486. 

  486. 160	val_160
    487. 

  487. 195	val_195
    488. 

  488. 119	val_119
    489. 

  489. 149	val_149
    490. 

  490. 138	val_138
    491. 

  491. 103	val_103
    492. 

  492. 113	val_113
    493. 

  493. 167	val_167
    494. 

  494. 116	val_116
    495. 

  495. 191	val_191
    496. 

  496. 128	val_128
    497. 

  497. 193	val_193
    498. 

  498. 104	val_104
    499. 

  499. 175	val_175
    500. 

  500. 105	val_105
    501. 

  501. 190	val_190
    502. 

  502. 114	val_114
    503. 

  503. 164	val_164
    504. 

  504. 125	val_125
    505. 

  505. 164	val_164
    506. 

  506. 187	val_187
    507. 

  507. 104	val_104
    508. 

  508. 163	val_163
    509. 

  509. 119	val_119
    510. 

  510. 199	val_199
    511. 

  511. 120	val_120
    512. 

  512. 169	val_169
    513. 

  513. 178	val_178
    514. 

  514. 136	val_136
    515. 

  515. 172	val_172
    516. 

  516. 133	val_133
    517. 

  517. 175	val_175
    518. 

  518. 189	val_189
    519. 

  519. 134	val_134
    520. 

  520. 100	val_100
    521. 

  521. 146	val_146
    522. 

  522. 186	val_186
    523. 

  523. 167	val_167
    524. 

  524. 183	val_183
    525. 

  525. 152	val_152
    526. 

  526. 194	val_194
    527. 

  527. 126	val_126
    528. 

  528. 169	val_169
    529. 

  529. PREHOOK: query: SELECT dest3.* FROM dest3
    530. 

  530. PREHOOK: type: QUERY
    531. 

  531. PREHOOK: Input: default@dest3@ds=2008-04-08/hr=12
    532. 

  532. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-23_381_121664267251302859/-mr-10000
    533. 

  533. POSTHOOK: query: SELECT dest3.* FROM dest3
    534. 

  534. POSTHOOK: type: QUERY
    535. 

  535. POSTHOOK: Input: default@dest3@ds=2008-04-08/hr=12
    536. 

  536. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-23_381_121664267251302859/-mr-10000
    537. 

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

  538. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    539. 

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

  540. POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    541. 

  541. POSTHOOK: Lineage: dest3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    542. 

  542. 238	2008-04-08	12
    543. 

  543. 255	2008-04-08	12
    544. 

  544. 278	2008-04-08	12
    545. 

  545. 265	2008-04-08	12
    546. 

  546. 273	2008-04-08	12
    547. 

  547. 224	2008-04-08	12
    548. 

  548. 213	2008-04-08	12
    549. 

  549. 281	2008-04-08	12
    550. 

  550. 277	2008-04-08	12
    551. 

  551. 209	2008-04-08	12
    552. 

  552. 252	2008-04-08	12
    553. 

  553. 292	2008-04-08	12
    554. 

  554. 219	2008-04-08	12
    555. 

  555. 287	2008-04-08	12
    556. 

  556. 237	2008-04-08	12
    557. 

  557. 207	2008-04-08	12
    558. 

  558. 208	2008-04-08	12
    559. 

  559. 247	2008-04-08	12
    560. 

  560. 266	2008-04-08	12
    561. 

  561. 203	2008-04-08	12
    562. 

  562. 205	2008-04-08	12
    563. 

  563. 221	2008-04-08	12
    564. 

  564. 280	2008-04-08	12
    565. 

  565. 277	2008-04-08	12
    566. 

  566. 208	2008-04-08	12
    567. 

  567. 286	2008-04-08	12
    568. 

  568. 239	2008-04-08	12
    569. 

  569. 213	2008-04-08	12
    570. 

  570. 216	2008-04-08	12
    571. 

  571. 278	2008-04-08	12
    572. 

  572. 289	2008-04-08	12
    573. 

  573. 221	2008-04-08	12
    574. 

  574. 275	2008-04-08	12
    575. 

  575. 241	2008-04-08	12
    576. 

  576. 284	2008-04-08	12
    577. 

  577. 230	2008-04-08	12
    578. 

  578. 260	2008-04-08	12
    579. 

  579. 272	2008-04-08	12
    580. 

  580. 217	2008-04-08	12
    581. 

  581. 230	2008-04-08	12
    582. 

  582. 208	2008-04-08	12
    583. 

  583. 298	2008-04-08	12
    584. 

  584. 230	2008-04-08	12
    585. 

  585. 205	2008-04-08	12
    586. 

  586. 288	2008-04-08	12
    587. 

  587. 282	2008-04-08	12
    588. 

  588. 282	2008-04-08	12
    589. 

  589. 238	2008-04-08	12
    590. 

  590. 277	2008-04-08	12
    591. 

  591. 273	2008-04-08	12
    592. 

  592. 224	2008-04-08	12
    593. 

  593. 242	2008-04-08	12
    594. 

  594. 272	2008-04-08	12
    595. 

  595. 242	2008-04-08	12
    596. 

  596. 226	2008-04-08	12
    597. 

  597. 229	2008-04-08	12
    598. 

  598. 233	2008-04-08	12
    599. 

  599. 223	2008-04-08	12
    600. 

  600. 218	2008-04-08	12
    601. 

  601. 228	2008-04-08	12
    602. 

  602. 209	2008-04-08	12
    603. 

  603. 230	2008-04-08	12
    604. 

  604. 296	2008-04-08	12
    605. 

  605. 216	2008-04-08	12
    606. 

  606. 274	2008-04-08	12
    607. 

  607. 219	2008-04-08	12
    608. 

  608. 239	2008-04-08	12
    609. 

  609. 223	2008-04-08	12
    610. 

  610. 256	2008-04-08	12
    611. 

  611. 263	2008-04-08	12
    612. 

  612. 288	2008-04-08	12
    613. 

  613. 244	2008-04-08	12
    614. 

  614. 202	2008-04-08	12
    615. 

  615. 229	2008-04-08	12
    616. 

  616. 280	2008-04-08	12
    617. 

  617. 283	2008-04-08	12
    618. 

  618. 235	2008-04-08	12
    619. 

  619. 257	2008-04-08	12
    620. 

  620. 258	2008-04-08	12
    621. 

  621. 203	2008-04-08	12
    622. 

  622. 262	2008-04-08	12
    623. 

  623. 201	2008-04-08	12
    624. 

  624. 217	2008-04-08	12
    625. 

  625. 298	2008-04-08	12
    626. 

  626. 291	2008-04-08	12
    627. 

  627. 255	2008-04-08	12
    628. 

  628. 200	2008-04-08	12
    629. 

  629. 237	2008-04-08	12
    630. 

  630. 248	2008-04-08	12
    631. 

  631. 277	2008-04-08	12
    632. 

  632. 230	2008-04-08	12
    633. 

  633. 207	2008-04-08	12
    634. 

  634. 249	2008-04-08	12
    635. 

  635. 265	2008-04-08	12
    636. 

  636. 214	2008-04-08	12
    637. 

  637. 233	2008-04-08	12
    638. 

  638. 256	2008-04-08	12
    639. 

  639. 298	2008-04-08	12
    640. 

  640. 285	2008-04-08	12
    641. 

  641. 273	2008-04-08	12
    642. 

  642. 281	2008-04-08	12
    643. 

  643. 222	2008-04-08	12
    644. 

  644. 200	2008-04-08	12
    645. 

  645. val_311
    646. 

  646. val_409
    647. 

  647. val_484
    648. 

  648. val_401
    649. 

  649. val_369
    650. 

  650. val_406
    651. 

  651. val_429
    652. 

  652. val_374
    653. 

  653. val_469
    654. 

  654. val_495
    655. 

  655. val_327
    656. 

  656. val_403
    657. 

  657. val_417
    658. 

  658. val_430
    659. 

  659. val_338
    660. 

  660. val_446
    661. 

  661. val_459
    662. 

  662. val_394
    663. 

  663. val_482
    664. 

  664. val_413
    665. 

  665. val_494
    666. 

  666. val_466
    667. 

  667. val_399
    668. 

  668. val_396
    669. 

  669. val_417
    670. 

  670. val_489
    671. 

  671. val_377
    672. 

  672. val_397
    673. 

  673. val_309
    674. 

  674. val_365
    675. 

  675. val_439
    676. 

  676. val_342
    677. 

  677. val_367
    678. 

  678. val_325
    679. 

  679. val_475
    680. 

  680. val_339
    681. 

  681. val_455
    682. 

  682. val_311
    683. 

  683. val_316
    684. 

  684. val_302
    685. 

  685. val_438
    686. 

  686. val_345
    687. 

  687. val_489
    688. 

  688. val_378
    689. 

  689. val_427
    690. 

  690. val_356
    691. 

  691. val_399
    692. 

  692. val_382
    693. 

  693. val_498
    694. 

  694. val_386
    695. 

  695. val_437
    696. 

  696. val_469
    697. 

  697. val_459
    698. 

  698. val_430
    699. 

  699. val_318
    700. 

  700. val_332
    701. 

  701. val_311
    702. 

  702. val_333
    703. 

  703. val_404
    704. 

  704. val_384
    705. 

  705. val_489
    706. 

  706. val_353
    707. 

  707. val_373
    708. 

  708. val_348
    709. 

  709. val_466
    710. 

  710. val_411
    711. 

  711. val_348
    712. 

  712. val_463
    713. 

  713. val_431
    714. 

  714. val_496
    715. 

  715. val_322
    716. 

  716. val_468
    717. 

  717. val_393
    718. 

  718. val_454
    719. 

  719. val_418
    720. 

  720. val_327
    721. 

  721. val_404
    722. 

  722. val_436
    723. 

  723. val_469
    724. 

  724. val_468
    725. 

  725. val_308
    726. 

  726. val_481
    727. 

  727. val_457
    728. 

  728. val_318
    729. 

  729. val_318
    730. 

  730. val_409
    731. 

  731. val_470
    732. 

  732. val_369
    733. 

  733. val_316
    734. 

  734. val_413
    735. 

  735. val_490
    736. 

  736. val_364
    737. 

  737. val_395
    738. 

  738. val_419
    739. 

  739. val_307
    740. 

  740. val_435
    741. 

  741. val_306
    742. 

  742. val_309
    743. 

  743. val_389
    744. 

  744. val_327
    745. 

  745. val_369
    746. 

  746. val_392
    747. 

  747. val_331
    748. 

  748. val_401
    749. 

  749. val_452
    750. 

  750. val_497
    751. 

  751. val_402
    752. 

  752. val_396
    753. 

  753. val_317
    754. 

  754. val_395
    755. 

  755. val_336
    756. 

  756. val_472
    757. 

  757. val_322
    758. 

  758. val_498
    759. 

  759. val_321
    760. 

  760. val_430
    761. 

  761. val_489
    762. 

  762. val_458
    763. 

  763. val_492
    764. 

  764. val_449
    765. 

  765. val_453
    766. 

  766. val_468
    767. 

  767. val_342
    768. 

  768. val_368
    769. 

  769. val_367
    770. 

  770. val_344
    771. 

  771. val_485
    772. 

  772. val_487
    773. 

  773. val_480
    774. 

  774. val_401
    775. 

  775. val_438
    776. 

  776. val_467
    777. 

  777. val_432
    778. 

  778. val_316
    779. 

  779. val_469
    780. 

  780. val_463
    781. 

  781. val_331
    782. 

  782. val_321
    783. 

  783. val_335
    784. 

  784. val_466
    785. 

  785. val_366
    786. 

  786. val_403
    787. 

  787. val_483
    788. 

  788. val_406
    789. 

  789. val_409
    790. 

  790. val_406
    791. 

  791. val_401
    792. 

  792. val_348
    793. 

  793. val_424
    794. 

  794. val_396
    795. 

  795. val_431
    796. 

  796. val_454
    797. 

  797. val_478
    798. 

  798. val_431
    799. 

  799. val_424
    800. 

  800. val_382
    801. 

  801. val_397
    802. 

  802. val_480
    803. 

  803. val_351
    804. 

  804. val_438
    805. 

  805. val_414
    806. 

  806. val_491
    807. 

  807. val_439
    808. 

  808. val_360
    809. 

  809. val_479
    810. 

  810. val_305
    811. 

  811. val_417
    812. 

  812. val_444
    813. 

  813. val_429
    814. 

  814. val_443
    815. 

  815. val_323
    816. 

  816. val_325
    817. 

  817. val_478
    818. 

  818. val_468
    819. 

  819. val_310
    820. 

  820. val_317
    821. 

  821. val_333
    822. 

  822. val_493
    823. 

  823. val_460
    824. 

  824. val_480
    825. 

  825. val_353
    826. 

  826. val_462
    827. 

  827. val_406
    828. 

  828. val_454
    829. 

  829. val_375
    830. 

  830. val_401
    831. 

  831. val_421
    832. 

  832. val_407
    833. 

  833. val_384
    834. 

  834. val_384
    835. 

  835. val_379
    836. 

  836. val_462
    837. 

  837. val_492
    838. 

  838. val_341
    839. 

  839. val_498
    840. 

  840. val_458
    841. 

  841. val_362
    842. 

  842. val_348
    843. 

  843. val_344
    844. 

  844. val_469
    845. 

  845. val_315
    846. 

  846. val_448
    847. 

  847. val_348
    848. 

  848. val_307
    849. 

  849. val_414
    850. 

  850. val_477
    851. 

  851. val_403
    852. 

  852. val_400
    853. 

  853.