PageRenderTime 39ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 186 lines | 179 code | 7 blank | 0 comment | 0 complexity | 5c9175917d151f629ad4fc6258a086d2 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: explain
    2. 

  2. select * from (
    3. 

  3.   select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
    4. 

  4.     union all
    5. 

  5.   select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
    6. 

  6. )subq
    7. 

  7. PREHOOK: type: QUERY
    8. 

  8. POSTHOOK: query: explain
    9. 

  9. select * from (
    10. 

  10.   select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
    11. 

  11.     union all
    12. 

  12.   select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
    13. 

  13. )subq
    14. 

  14. POSTHOOK: type: QUERY
    15. 

  15. ABSTRACT SYNTAX TREE:
    16. 

  16.   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL a) hr) '11'))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key))) (TOK_LIMIT 5))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) b)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL b) hr) '14'))) (TOK_LIMIT 5)))) subq)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
    17. 

  17. 

  18. STAGE DEPENDENCIES:
    19. 

  19.   Stage-1 is a root stage
    20. 

  20.   Stage-2 depends on stages: Stage-1, Stage-3
    21. 

  21.   Stage-3 is a root stage
    22. 

  22.   Stage-0 is a root stage
    23. 

  23. 

  24. STAGE PLANS:
    25. 

  25.   Stage: Stage-1
    26. 

  26.     Map Reduce
    27. 

  27.       Alias -> Map Operator Tree:
    28. 

  28.         null-subquery1:subq-subquery1:a 
    29. 

  29.           TableScan
    30. 

  30.             alias: a
    31. 

  31.             Filter Operator
    32. 

  32.               predicate:
    33. 

  33.                   expr: ((ds = '2008-04-08') and (hr = '11'))
    34. 

  34.                   type: boolean
    35. 

  35.               Select Operator
    36. 

  36.                 expressions:
    37. 

  37.                       expr: key
    38. 

  38.                       type: string
    39. 

  39.                       expr: value
    40. 

  40.                       type: string
    41. 

  41.                       expr: ds
    42. 

  42.                       type: string
    43. 

  43.                       expr: hr
    44. 

  44.                       type: string
    45. 

  45.                 outputColumnNames: _col0, _col1, _col2, _col3
    46. 

  46.                 Reduce Output Operator
    47. 

  47.                   key expressions:
    48. 

  48.                         expr: _col0
    49. 

  49.                         type: string
    50. 

  50.                   sort order: +
    51. 

  51.                   tag: -1
    52. 

  52.                   value expressions:
    53. 

  53.                         expr: _col0
    54. 

  54.                         type: string
    55. 

  55.                         expr: _col1
    56. 

  56.                         type: string
    57. 

  57.                         expr: _col2
    58. 

  58.                         type: string
    59. 

  59.                         expr: _col3
    60. 

  60.                         type: string
    61. 

  61.       Reduce Operator Tree:
    62. 

  62.         Extract
    63. 

  63.           Limit
    64. 

  64.             File Output Operator
    65. 

  65.               compressed: false
    66. 

  66.               GlobalTableId: 0
    67. 

  67.               table:
    68. 

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

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

  70. 

  71.   Stage: Stage-2
    72. 

  72.     Map Reduce
    73. 

  73.       Alias -> Map Operator Tree:
    74. 

  74.         file:/tmp/sdong/hive_2011-02-10_15-54-47_775_6322428928723831214/-mr-10002 
    75. 

  75.           Union
    76. 

  76.             Select Operator
    77. 

  77.               expressions:
    78. 

  78.                     expr: _col0
    79. 

  79.                     type: string
    80. 

  80.                     expr: _col1
    81. 

  81.                     type: string
    82. 

  82.                     expr: _col2
    83. 

  83.                     type: string
    84. 

  84.                     expr: _col3
    85. 

  85.                     type: string
    86. 

  86.               outputColumnNames: _col0, _col1, _col2, _col3
    87. 

  87.               File Output Operator
    88. 

  88.                 compressed: false
    89. 

  89.                 GlobalTableId: 0
    90. 

  90.                 table:
    91. 

  91.                     input format: org.apache.hadoop.mapred.TextInputFormat
    92. 

  92.                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    93. 

  93.         file:/tmp/sdong/hive_2011-02-10_15-54-47_775_6322428928723831214/-mr-10003 
    94. 

  94.           Union
    95. 

  95.             Select Operator
    96. 

  96.               expressions:
    97. 

  97.                     expr: _col0
    98. 

  98.                     type: string
    99. 

  99.                     expr: _col1
    100. 

  100.                     type: string
    101. 

  101.                     expr: _col2
    102. 

  102.                     type: string
    103. 

  103.                     expr: _col3
    104. 

  104.                     type: string
    105. 

  105.               outputColumnNames: _col0, _col1, _col2, _col3
    106. 

  106.               File Output Operator
    107. 

  107.                 compressed: false
    108. 

  108.                 GlobalTableId: 0
    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. 

  113.   Stage: Stage-3
    114. 

  114.     Map Reduce
    115. 

  115.       Alias -> Map Operator Tree:
    116. 

  116.         null-subquery2:subq-subquery2:b 
    117. 

  117.           TableScan
    118. 

  118.             alias: b
    119. 

  119.             Filter Operator
    120. 

  120.               predicate:
    121. 

  121.                   expr: ((ds = '2008-04-08') and (hr = '14'))
    122. 

  122.                   type: boolean
    123. 

  123.               Filter Operator
    124. 

  124.                 predicate:
    125. 

  125.                     expr: ((ds = '2008-04-08') and (hr = '14'))
    126. 

  126.                     type: boolean
    127. 

  127.                 Select Operator
    128. 

  128.                   expressions:
    129. 

  129.                         expr: key
    130. 

  130.                         type: string
    131. 

  131.                         expr: value
    132. 

  132.                         type: string
    133. 

  133.                         expr: ds
    134. 

  134.                         type: string
    135. 

  135.                         expr: hr
    136. 

  136.                         type: string
    137. 

  137.                   outputColumnNames: _col0, _col1, _col2, _col3
    138. 

  138.                   Limit
    139. 

  139.                     Reduce Output Operator
    140. 

  140.                       sort order: 
    141. 

  141.                       tag: -1
    142. 

  142.                       value expressions:
    143. 

  143.                             expr: _col0
    144. 

  144.                             type: string
    145. 

  145.                             expr: _col1
    146. 

  146.                             type: string
    147. 

  147.                             expr: _col2
    148. 

  148.                             type: string
    149. 

  149.                             expr: _col3
    150. 

  150.                             type: string
    151. 

  151.       Reduce Operator Tree:
    152. 

  152.         Extract
    153. 

  153.           Limit
    154. 

  154.             File Output Operator
    155. 

  155.               compressed: false
    156. 

  156.               GlobalTableId: 0
    157. 

  157.               table:
    158. 

  158.                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    159. 

  159.                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    160. 

  160. 

  161.   Stage: Stage-0
    162. 

  162.     Fetch Operator
    163. 

  163.       limit: -1
    164. 

  164. 

  165. 

  166. PREHOOK: query: select * from (
    167. 

  167.   select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
    168. 

  168.     union all
    169. 

  169.   select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
    170. 

  170. )subq
    171. 

  171. PREHOOK: type: QUERY
    172. 

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

  173. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-47_937_1412967694655761034/-mr-10000
    174. 

  174. POSTHOOK: query: select * from (
    175. 

  175.   select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
    176. 

  176.     union all
    177. 

  177.   select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
    178. 

  178. )subq
    179. 

  179. POSTHOOK: type: QUERY
    180. 

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

  181. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-47_937_1412967694655761034/-mr-10000
    182. 

  182. 0	val_0	2008-04-08	11
    183. 

  183. 0	val_0	2008-04-08	11
    184. 

  184. 0	val_0	2008-04-08	11
    185. 

  185. 10	val_10	2008-04-08	11
    186. 

  186. 100	val_100	2008-04-08	11
    187. 

  187.