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

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

#
text | 551 lines | 538 code | 13 blank | 0 comment | 0 complexity | 65e697372ea2f7b9a7aadaf84dc3cde7 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: EXPLAIN
    2. 

  2. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    3. 

  3. FROM
    4. 

  4. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    5. 

  5.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    6. 

  6.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
    7. 

  7. PREHOOK: type: QUERY
    8. 

  8. POSTHOOK: query: EXPLAIN
    9. 

  9. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    10. 

  10. FROM
    11. 

  11. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    12. 

  12.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    13. 

  13.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
    14. 

  14. POSTHOOK: type: QUERY
    15. 

  15. ABSTRACT SYNTAX TREE:
    16. 

  16.   (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key) key1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) value1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key) key2) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value) value2)))) subq) (TOK_TABREF (TOK_TABNAME srcpart) z) (and (and (= (. (TOK_TABLE_OR_COL subq) key1) (. (TOK_TABLE_OR_COL z) key)) (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL z) hr) 11)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST z))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL subq) key1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value)))))
    17. 

  17. 

  18. STAGE DEPENDENCIES:
    19. 

  19.   Stage-4 is a root stage
    20. 

  20.   Stage-1 depends on stages: Stage-4
    21. 

  21.   Stage-0 is a root stage
    22. 

  22. 

  23. STAGE PLANS:
    24. 

  24.   Stage: Stage-4
    25. 

  25.     Map Reduce Local Work
    26. 

  26.       Alias -> Map Local Tables:
    27. 

  27.         subq:x 
    28. 

  28.           Fetch Operator
    29. 

  29.             limit: -1
    30. 

  30.         z 
    31. 

  31.           Fetch Operator
    32. 

  32.             limit: -1
    33. 

  33.       Alias -> Map Local Operator Tree:
    34. 

  34.         subq:x 
    35. 

  35.           TableScan
    36. 

  36.             alias: x
    37. 

  37.             HashTable Sink Operator
    38. 

  38.               condition expressions:
    39. 

  39.                 0 {key}
    40. 

  40.                 1 
    41. 

  41.               handleSkewJoin: false
    42. 

  42.               keys:
    43. 

  43.                 0 [Column[key]]
    44. 

  44.                 1 [Column[key]]
    45. 

  45.               Position of Big Table: 1
    46. 

  46.         z 
    47. 

  47.           TableScan
    48. 

  48.             alias: z
    49. 

  49.             Filter Operator
    50. 

  50.               predicate:
    51. 

  51.                   expr: (ds = '2008-04-08')
    52. 

  52.                   type: boolean
    53. 

  53.               Filter Operator
    54. 

  54.                 predicate:
    55. 

  55.                     expr: (hr = 11)
    56. 

  56.                     type: boolean
    57. 

  57.                 HashTable Sink Operator
    58. 

  58.                   condition expressions:
    59. 

  59.                     0 {_col0}
    60. 

  60.                     1 {value}
    61. 

  61.                   handleSkewJoin: false
    62. 

  62.                   keys:
    63. 

  63.                     0 [Column[_col0]]
    64. 

  64.                     1 [Column[key]]
    65. 

  65.                   Position of Big Table: 0
    66. 

  66. 

  67.   Stage: Stage-1
    68. 

  68.     Map Reduce
    69. 

  69.       Alias -> Map Operator Tree:
    70. 

  70.         subq:y 
    71. 

  71.           TableScan
    72. 

  72.             alias: y
    73. 

  73.             Map Join Operator
    74. 

  74.               condition map:
    75. 

  75.                    Inner Join 0 to 1
    76. 

  76.               condition expressions:
    77. 

  77.                 0 {key}
    78. 

  78.                 1 
    79. 

  79.               handleSkewJoin: false
    80. 

  80.               keys:
    81. 

  81.                 0 [Column[key]]
    82. 

  82.                 1 [Column[key]]
    83. 

  83.               outputColumnNames: _col0
    84. 

  84.               Position of Big Table: 1
    85. 

  85.               Select Operator
    86. 

  86.                 expressions:
    87. 

  87.                       expr: _col0
    88. 

  88.                       type: string
    89. 

  89.                 outputColumnNames: _col0
    90. 

  90.                 Select Operator
    91. 

  91.                   expressions:
    92. 

  92.                         expr: _col0
    93. 

  93.                         type: string
    94. 

  94.                   outputColumnNames: _col0
    95. 

  95.                   Map Join Operator
    96. 

  96.                     condition map:
    97. 

  97.                          Inner Join 0 to 1
    98. 

  98.                     condition expressions:
    99. 

  99.                       0 {_col0}
    100. 

  100.                       1 {value}
    101. 

  101.                     handleSkewJoin: false
    102. 

  102.                     keys:
    103. 

  103.                       0 [Column[_col0]]
    104. 

  104.                       1 [Column[key]]
    105. 

  105.                     outputColumnNames: _col0, _col5
    106. 

  106.                     Position of Big Table: 0
    107. 

  107.                     Select Operator
    108. 

  108.                       expressions:
    109. 

  109.                             expr: _col0
    110. 

  110.                             type: string
    111. 

  111.                             expr: _col5
    112. 

  112.                             type: string
    113. 

  113.                       outputColumnNames: _col0, _col5
    114. 

  114.                       Select Operator
    115. 

  115.                         expressions:
    116. 

  116.                               expr: _col0
    117. 

  117.                               type: string
    118. 

  118.                               expr: _col5
    119. 

  119.                               type: string
    120. 

  120.                         outputColumnNames: _col0, _col1
    121. 

  121.                         File Output Operator
    122. 

  122.                           compressed: false
    123. 

  123.                           GlobalTableId: 0
    124. 

  124.                           table:
    125. 

  125.                               input format: org.apache.hadoop.mapred.TextInputFormat
    126. 

  126.                               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    127. 

  127.       Local Work:
    128. 

  128.         Map Reduce Local Work
    129. 

  129. 

  130.   Stage: Stage-0
    131. 

  131.     Fetch Operator
    132. 

  132.       limit: -1
    133. 

  133. 

  134. 

  135. PREHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    136. 

  136. FROM
    137. 

  137. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    138. 

  138.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    139. 

  139.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
    140. 

  140. PREHOOK: type: QUERY
    141. 

  141. PREHOOK: Input: default@src
    142. 

  142. PREHOOK: Input: default@src1
    143. 

  143. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    144. 

  144. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-39-29_731_509300544483919463/-mr-10000
    145. 

  145. POSTHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    146. 

  146. FROM
    147. 

  147. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    148. 

  148.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    149. 

  149.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
    150. 

  150. POSTHOOK: type: QUERY
    151. 

  151. POSTHOOK: Input: default@src
    152. 

  152. POSTHOOK: Input: default@src1
    153. 

  153. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    154. 

  154. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-39-29_731_509300544483919463/-mr-10000
    155. 

  155. 238	val_238
    156. 

  156. 238	val_238
    157. 

  157. 311	val_311
    158. 

  158. 311	val_311
    159. 

  159. 311	val_311
    160. 

  160. 255	val_255
    161. 

  161. 255	val_255
    162. 

  162. 278	val_278
    163. 

  163. 278	val_278
    164. 

  164. 98	val_98
    165. 

  165. 98	val_98
    166. 

  166. 401	val_401
    167. 

  167. 401	val_401
    168. 

  168. 401	val_401
    169. 

  169. 401	val_401
    170. 

  170. 401	val_401
    171. 

  171. 150	val_150
    172. 

  172. 273	val_273
    173. 

  173. 273	val_273
    174. 

  174. 273	val_273
    175. 

  175. 224	val_224
    176. 

  176. 224	val_224
    177. 

  177. 369	val_369
    178. 

  178. 369	val_369
    179. 

  179. 369	val_369
    180. 

  180. 66	val_66
    181. 

  181. 128	val_128
    182. 

  182. 128	val_128
    183. 

  183. 128	val_128
    184. 

  184. 213	val_213
    185. 

  185. 213	val_213
    186. 

  186. 146	val_146
    187. 

  187. 146	val_146
    188. 

  188. 406	val_406
    189. 

  189. 406	val_406
    190. 

  190. 406	val_406
    191. 

  191. 406	val_406
    192. 

  192. 128	val_128
    193. 

  193. 128	val_128
    194. 

  194. 128	val_128
    195. 

  195. 311	val_311
    196. 

  196. 311	val_311
    197. 

  197. 311	val_311
    198. 

  198. 213	val_213
    199. 

  199. 213	val_213
    200. 

  200. 278	val_278
    201. 

  201. 278	val_278
    202. 

  202. 311	val_311
    203. 

  203. 311	val_311
    204. 

  204. 311	val_311
    205. 

  205. 98	val_98
    206. 

  206. 98	val_98
    207. 

  207. 369	val_369
    208. 

  208. 369	val_369
    209. 

  209. 369	val_369
    210. 

  210. 238	val_238
    211. 

  211. 238	val_238
    212. 

  212. 273	val_273
    213. 

  213. 273	val_273
    214. 

  214. 273	val_273
    215. 

  215. 224	val_224
    216. 

  216. 224	val_224
    217. 

  217. 369	val_369
    218. 

  218. 369	val_369
    219. 

  219. 369	val_369
    220. 

  220. 401	val_401
    221. 

  221. 401	val_401
    222. 

  222. 401	val_401
    223. 

  223. 401	val_401
    224. 

  224. 401	val_401
    225. 

  225. 401	val_401
    226. 

  226. 401	val_401
    227. 

  227. 401	val_401
    228. 

  228. 401	val_401
    229. 

  229. 401	val_401
    230. 

  230. 128	val_128
    231. 

  231. 128	val_128
    232. 

  232. 128	val_128
    233. 

  233. 406	val_406
    234. 

  234. 406	val_406
    235. 

  235. 406	val_406
    236. 

  236. 406	val_406
    237. 

  237. 406	val_406
    238. 

  238. 406	val_406
    239. 

  239. 406	val_406
    240. 

  240. 406	val_406
    241. 

  241. 401	val_401
    242. 

  242. 401	val_401
    243. 

  243. 401	val_401
    244. 

  244. 401	val_401
    245. 

  245. 401	val_401
    246. 

  246. 255	val_255
    247. 

  247. 255	val_255
    248. 

  248. 406	val_406
    249. 

  249. 406	val_406
    250. 

  250. 406	val_406
    251. 

  251. 406	val_406
    252. 

  252. 401	val_401
    253. 

  253. 401	val_401
    254. 

  254. 401	val_401
    255. 

  255. 401	val_401
    256. 

  256. 401	val_401
    257. 

  257. 146	val_146
    258. 

  258. 146	val_146
    259. 

  259. 273	val_273
    260. 

  260. 273	val_273
    261. 

  261. 273	val_273
    262. 

  262. PREHOOK: query: EXPLAIN 
    263. 

  263. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    264. 

  264. FROM
    265. 

  265. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    266. 

  266.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    267. 

  267.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11) 
    268. 

  268.  order by subq.key1
    269. 

  269. PREHOOK: type: QUERY
    270. 

  270. POSTHOOK: query: EXPLAIN 
    271. 

  271. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    272. 

  272. FROM
    273. 

  273. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    274. 

  274.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    275. 

  275.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11) 
    276. 

  276.  order by subq.key1
    277. 

  277. POSTHOOK: type: QUERY
    278. 

  278. ABSTRACT SYNTAX TREE:
    279. 

  279.   (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key) key1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) value1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key) key2) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value) value2)))) subq) (TOK_TABREF (TOK_TABNAME srcpart) z) (and (and (= (. (TOK_TABLE_OR_COL subq) key1) (. (TOK_TABLE_OR_COL z) key)) (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL z) hr) 11)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST z))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL subq) key1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq) key1)))))
    280. 

  280. 

  281. STAGE DEPENDENCIES:
    282. 

  282.   Stage-5 is a root stage
    283. 

  283.   Stage-1 depends on stages: Stage-5
    284. 

  284.   Stage-2 depends on stages: Stage-1
    285. 

  285.   Stage-0 is a root stage
    286. 

  286. 

  287. STAGE PLANS:
    288. 

  288.   Stage: Stage-5
    289. 

  289.     Map Reduce Local Work
    290. 

  290.       Alias -> Map Local Tables:
    291. 

  291.         subq:x 
    292. 

  292.           Fetch Operator
    293. 

  293.             limit: -1
    294. 

  294.         z 
    295. 

  295.           Fetch Operator
    296. 

  296.             limit: -1
    297. 

  297.       Alias -> Map Local Operator Tree:
    298. 

  298.         subq:x 
    299. 

  299.           TableScan
    300. 

  300.             alias: x
    301. 

  301.             HashTable Sink Operator
    302. 

  302.               condition expressions:
    303. 

  303.                 0 {key}
    304. 

  304.                 1 
    305. 

  305.               handleSkewJoin: false
    306. 

  306.               keys:
    307. 

  307.                 0 [Column[key]]
    308. 

  308.                 1 [Column[key]]
    309. 

  309.               Position of Big Table: 1
    310. 

  310.         z 
    311. 

  311.           TableScan
    312. 

  312.             alias: z
    313. 

  313.             Filter Operator
    314. 

  314.               predicate:
    315. 

  315.                   expr: (ds = '2008-04-08')
    316. 

  316.                   type: boolean
    317. 

  317.               Filter Operator
    318. 

  318.                 predicate:
    319. 

  319.                     expr: (hr = 11)
    320. 

  320.                     type: boolean
    321. 

  321.                 HashTable Sink Operator
    322. 

  322.                   condition expressions:
    323. 

  323.                     0 {_col0}
    324. 

  324.                     1 {value}
    325. 

  325.                   handleSkewJoin: false
    326. 

  326.                   keys:
    327. 

  327.                     0 [Column[_col0]]
    328. 

  328.                     1 [Column[key]]
    329. 

  329.                   Position of Big Table: 0
    330. 

  330. 

  331.   Stage: Stage-1
    332. 

  332.     Map Reduce
    333. 

  333.       Alias -> Map Operator Tree:
    334. 

  334.         subq:y 
    335. 

  335.           TableScan
    336. 

  336.             alias: y
    337. 

  337.             Map Join Operator
    338. 

  338.               condition map:
    339. 

  339.                    Inner Join 0 to 1
    340. 

  340.               condition expressions:
    341. 

  341.                 0 {key}
    342. 

  342.                 1 
    343. 

  343.               handleSkewJoin: false
    344. 

  344.               keys:
    345. 

  345.                 0 [Column[key]]
    346. 

  346.                 1 [Column[key]]
    347. 

  347.               outputColumnNames: _col0
    348. 

  348.               Position of Big Table: 1
    349. 

  349.               Select Operator
    350. 

  350.                 expressions:
    351. 

  351.                       expr: _col0
    352. 

  352.                       type: string
    353. 

  353.                 outputColumnNames: _col0
    354. 

  354.                 Select Operator
    355. 

  355.                   expressions:
    356. 

  356.                         expr: _col0
    357. 

  357.                         type: string
    358. 

  358.                   outputColumnNames: _col0
    359. 

  359.                   Map Join Operator
    360. 

  360.                     condition map:
    361. 

  361.                          Inner Join 0 to 1
    362. 

  362.                     condition expressions:
    363. 

  363.                       0 {_col0}
    364. 

  364.                       1 {value}
    365. 

  365.                     handleSkewJoin: false
    366. 

  366.                     keys:
    367. 

  367.                       0 [Column[_col0]]
    368. 

  368.                       1 [Column[key]]
    369. 

  369.                     outputColumnNames: _col0, _col5
    370. 

  370.                     Position of Big Table: 0
    371. 

  371.                     File Output Operator
    372. 

  372.                       compressed: false
    373. 

  373.                       GlobalTableId: 0
    374. 

  374.                       table:
    375. 

  375.                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    376. 

  376.                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    377. 

  377.       Local Work:
    378. 

  378.         Map Reduce Local Work
    379. 

  379. 

  380.   Stage: Stage-2
    381. 

  381.     Map Reduce
    382. 

  382.       Alias -> Map Operator Tree:
    383. 

  383.         file:/tmp/sdong/hive_2011-02-10_16-39-35_519_3270478772330421829/-mr-10002 
    384. 

  384.           Select Operator
    385. 

  385.             expressions:
    386. 

  386.                   expr: _col0
    387. 

  387.                   type: string
    388. 

  388.                   expr: _col5
    389. 

  389.                   type: string
    390. 

  390.             outputColumnNames: _col0, _col5
    391. 

  391.             Select Operator
    392. 

  392.               expressions:
    393. 

  393.                     expr: _col0
    394. 

  394.                     type: string
    395. 

  395.                     expr: _col5
    396. 

  396.                     type: string
    397. 

  397.               outputColumnNames: _col0, _col1
    398. 

  398.               Reduce Output Operator
    399. 

  399.                 key expressions:
    400. 

  400.                       expr: _col0
    401. 

  401.                       type: string
    402. 

  402.                 sort order: +
    403. 

  403.                 tag: -1
    404. 

  404.                 value expressions:
    405. 

  405.                       expr: _col0
    406. 

  406.                       type: string
    407. 

  407.                       expr: _col1
    408. 

  408.                       type: string
    409. 

  409.       Reduce Operator Tree:
    410. 

  410.         Extract
    411. 

  411.           File Output Operator
    412. 

  412.             compressed: false
    413. 

  413.             GlobalTableId: 0
    414. 

  414.             table:
    415. 

  415.                 input format: org.apache.hadoop.mapred.TextInputFormat
    416. 

  416.                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    417. 

  417. 

  418.   Stage: Stage-0
    419. 

  419.     Fetch Operator
    420. 

  420.       limit: -1
    421. 

  421. 

  422. 

  423. PREHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    424. 

  424. FROM
    425. 

  425. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2  
    426. 

  426.  FROM src1 x JOIN src y ON (x.key = y.key)) subq 
    427. 

  427.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)  
    428. 

  428.  order by subq.key1
    429. 

  429. PREHOOK: type: QUERY
    430. 

  430. PREHOOK: Input: default@src
    431. 

  431. PREHOOK: Input: default@src1
    432. 

  432. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    433. 

  433. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-39-35_670_1415465364269978204/-mr-10000
    434. 

  434. POSTHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    435. 

  435. FROM
    436. 

  436. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2  
    437. 

  437.  FROM src1 x JOIN src y ON (x.key = y.key)) subq 
    438. 

  438.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)  
    439. 

  439.  order by subq.key1
    440. 

  440. POSTHOOK: type: QUERY
    441. 

  441. POSTHOOK: Input: default@src
    442. 

  442. POSTHOOK: Input: default@src1
    443. 

  443. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    444. 

  444. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-39-35_670_1415465364269978204/-mr-10000
    445. 

  445. 128	val_128
    446. 

  446. 128	val_128
    447. 

  447. 128	val_128
    448. 

  448. 128	val_128
    449. 

  449. 128	val_128
    450. 

  450. 128	val_128
    451. 

  451. 128	val_128
    452. 

  452. 128	val_128
    453. 

  453. 128	val_128
    454. 

  454. 146	val_146
    455. 

  455. 146	val_146
    456. 

  456. 146	val_146
    457. 

  457. 146	val_146
    458. 

  458. 150	val_150
    459. 

  459. 213	val_213
    460. 

  460. 213	val_213
    461. 

  461. 213	val_213
    462. 

  462. 213	val_213
    463. 

  463. 224	val_224
    464. 

  464. 224	val_224
    465. 

  465. 224	val_224
    466. 

  466. 224	val_224
    467. 

  467. 238	val_238
    468. 

  468. 238	val_238
    469. 

  469. 238	val_238
    470. 

  470. 238	val_238
    471. 

  471. 255	val_255
    472. 

  472. 255	val_255
    473. 

  473. 255	val_255
    474. 

  474. 255	val_255
    475. 

  475. 273	val_273
    476. 

  476. 273	val_273
    477. 

  477. 273	val_273
    478. 

  478. 273	val_273
    479. 

  479. 273	val_273
    480. 

  480. 273	val_273
    481. 

  481. 273	val_273
    482. 

  482. 273	val_273
    483. 

  483. 273	val_273
    484. 

  484. 278	val_278
    485. 

  485. 278	val_278
    486. 

  486. 278	val_278
    487. 

  487. 278	val_278
    488. 

  488. 311	val_311
    489. 

  489. 311	val_311
    490. 

  490. 311	val_311
    491. 

  491. 311	val_311
    492. 

  492. 311	val_311
    493. 

  493. 311	val_311
    494. 

  494. 311	val_311
    495. 

  495. 311	val_311
    496. 

  496. 311	val_311
    497. 

  497. 369	val_369
    498. 

  498. 369	val_369
    499. 

  499. 369	val_369
    500. 

  500. 369	val_369
    501. 

  501. 369	val_369
    502. 

  502. 369	val_369
    503. 

  503. 369	val_369
    504. 

  504. 369	val_369
    505. 

  505. 369	val_369
    506. 

  506. 401	val_401
    507. 

  507. 401	val_401
    508. 

  508. 401	val_401
    509. 

  509. 401	val_401
    510. 

  510. 401	val_401
    511. 

  511. 401	val_401
    512. 

  512. 401	val_401
    513. 

  513. 401	val_401
    514. 

  514. 401	val_401
    515. 

  515. 401	val_401
    516. 

  516. 401	val_401
    517. 

  517. 401	val_401
    518. 

  518. 401	val_401
    519. 

  519. 401	val_401
    520. 

  520. 401	val_401
    521. 

  521. 401	val_401
    522. 

  522. 401	val_401
    523. 

  523. 401	val_401
    524. 

  524. 401	val_401
    525. 

  525. 401	val_401
    526. 

  526. 401	val_401
    527. 

  527. 401	val_401
    528. 

  528. 401	val_401
    529. 

  529. 401	val_401
    530. 

  530. 401	val_401
    531. 

  531. 406	val_406
    532. 

  532. 406	val_406
    533. 

  533. 406	val_406
    534. 

  534. 406	val_406
    535. 

  535. 406	val_406
    536. 

  536. 406	val_406
    537. 

  537. 406	val_406
    538. 

  538. 406	val_406
    539. 

  539. 406	val_406
    540. 

  540. 406	val_406
    541. 

  541. 406	val_406
    542. 

  542. 406	val_406
    543. 

  543. 406	val_406
    544. 

  544. 406	val_406
    545. 

  545. 406	val_406
    546. 

  546. 406	val_406
    547. 

  547. 66	val_66
    548. 

  548. 98	val_98
    549. 

  549. 98	val_98
    550. 

  550. 98	val_98
    551. 

  551. 98	val_98
    552. 

  552.