PageRenderTime 44ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

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

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

  1. PREHOOK: query: explain
    2. 

  2. select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    3. 

  3. PREHOOK: type: QUERY
    4. 

  4. POSTHOOK: query: explain
    5. 

  5. select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    6. 

  6. POSTHOOK: type: QUERY
    7. 

  7. ABSTRACT SYNTAX TREE:
    8. 

  8.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL x) value))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL x) value) 5)))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) key) 9999))))
    9. 

  9. 

  10. STAGE DEPENDENCIES:
    11. 

  11.   Stage-1 is a root stage
    12. 

  12.   Stage-0 is a root stage
    13. 

  13. 

  14. STAGE PLANS:
    15. 

  15.   Stage: Stage-1
    16. 

  16.     Map Reduce
    17. 

  17.       Alias -> Map Operator Tree:
    18. 

  18.         x 
    19. 

  19.           TableScan
    20. 

  20.             alias: x
    21. 

  21.             Filter Operator
    22. 

  22.               predicate:
    23. 

  23.                   expr: (key = 9999)
    24. 

  24.                   type: boolean
    25. 

  25.               Filter Operator
    26. 

  26.                 predicate:
    27. 

  27.                     expr: (key = 9999)
    28. 

  28.                     type: boolean
    29. 

  29.                 Select Operator
    30. 

  30.                   expressions:
    31. 

  31.                         expr: value
    32. 

  32.                         type: string
    33. 

  33.                   outputColumnNames: value
    34. 

  34.                   Group By Operator
    35. 

  35.                     aggregations:
    36. 

  36.                           expr: count(1)
    37. 

  37.                           expr: count(DISTINCT value)
    38. 

  38.                           expr: count(DISTINCT substr(value, 5))
    39. 

  39.                     bucketGroup: false
    40. 

  40.                     keys:
    41. 

  41.                           expr: value
    42. 

  42.                           type: string
    43. 

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

  44.                           type: string
    45. 

  45.                     mode: hash
    46. 

  46.                     outputColumnNames: _col0, _col1, _col2, _col3, _col4
    47. 

  47.                     Reduce Output Operator
    48. 

  48.                       key expressions:
    49. 

  49.                             expr: _col0
    50. 

  50.                             type: string
    51. 

  51.                             expr: _col1
    52. 

  52.                             type: string
    53. 

  53.                       sort order: ++
    54. 

  54.                       tag: -1
    55. 

  55.                       value expressions:
    56. 

  56.                             expr: _col2
    57. 

  57.                             type: bigint
    58. 

  58.                             expr: _col3
    59. 

  59.                             type: bigint
    60. 

  60.                             expr: _col4
    61. 

  61.                             type: bigint
    62. 

  62.       Reduce Operator Tree:
    63. 

  63.         Group By Operator
    64. 

  64.           aggregations:
    65. 

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

  66.                 expr: count(DISTINCT KEY._col0:0._col0)
    67. 

  67.                 expr: count(DISTINCT KEY._col0:1._col0)
    68. 

  68.           bucketGroup: false
    69. 

  69.           mode: mergepartial
    70. 

  70.           outputColumnNames: _col0, _col1, _col2
    71. 

  71.           Select Operator
    72. 

  72.             expressions:
    73. 

  73.                   expr: _col0
    74. 

  74.                   type: bigint
    75. 

  75.                   expr: _col1
    76. 

  76.                   type: bigint
    77. 

  77.                   expr: _col2
    78. 

  78.                   type: bigint
    79. 

  79.             outputColumnNames: _col0, _col1, _col2
    80. 

  80.             File Output Operator
    81. 

  81.               compressed: false
    82. 

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

  87.   Stage: Stage-0
    88. 

  88.     Fetch Operator
    89. 

  89.       limit: -1
    90. 

  90. 

  91. 

  92. PREHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    93. 

  93. PREHOOK: type: QUERY
    94. 

  94. PREHOOK: Input: default@src
    95. 

  95. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-27_281_6261349366093864618/-mr-10000
    96. 

  96. POSTHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    97. 

  97. POSTHOOK: type: QUERY
    98. 

  98. POSTHOOK: Input: default@src
    99. 

  99. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-27_281_6261349366093864618/-mr-10000
    100. 

  100. 0	0	0
    101. 

  101. PREHOOK: query: explain
    102. 

  102. select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    103. 

  103. PREHOOK: type: QUERY
    104. 

  104. POSTHOOK: query: explain
    105. 

  105. select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    106. 

  106. POSTHOOK: type: QUERY
    107. 

  107. ABSTRACT SYNTAX TREE:
    108. 

  108.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL x) value))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL x) value) 5)))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) key) 9999))))
    109. 

  109. 

  110. STAGE DEPENDENCIES:
    111. 

  111.   Stage-1 is a root stage
    112. 

  112.   Stage-0 is a root stage
    113. 

  113. 

  114. STAGE PLANS:
    115. 

  115.   Stage: Stage-1
    116. 

  116.     Map Reduce
    117. 

  117.       Alias -> Map Operator Tree:
    118. 

  118.         x 
    119. 

  119.           TableScan
    120. 

  120.             alias: x
    121. 

  121.             Filter Operator
    122. 

  122.               predicate:
    123. 

  123.                   expr: (key = 9999)
    124. 

  124.                   type: boolean
    125. 

  125.               Filter Operator
    126. 

  126.                 predicate:
    127. 

  127.                     expr: (key = 9999)
    128. 

  128.                     type: boolean
    129. 

  129.                 Select Operator
    130. 

  130.                   expressions:
    131. 

  131.                         expr: value
    132. 

  132.                         type: string
    133. 

  133.                   outputColumnNames: value
    134. 

  134.                   Reduce Output Operator
    135. 

  135.                     key expressions:
    136. 

  136.                           expr: value
    137. 

  137.                           type: string
    138. 

  138.                           expr: substr(value, 5)
    139. 

  139.                           type: string
    140. 

  140.                     sort order: ++
    141. 

  141.                     tag: -1
    142. 

  142.                     value expressions:
    143. 

  143.                           expr: 1
    144. 

  144.                           type: int
    145. 

  145.       Reduce Operator Tree:
    146. 

  146.         Group By Operator
    147. 

  147.           aggregations:
    148. 

  148.                 expr: count(VALUE._col0)
    149. 

  149.                 expr: count(DISTINCT KEY._col0:0._col0)
    150. 

  150.                 expr: count(DISTINCT KEY._col0:1._col0)
    151. 

  151.           bucketGroup: false
    152. 

  152.           mode: complete
    153. 

  153.           outputColumnNames: _col0, _col1, _col2
    154. 

  154.           Select Operator
    155. 

  155.             expressions:
    156. 

  156.                   expr: _col0
    157. 

  157.                   type: bigint
    158. 

  158.                   expr: _col1
    159. 

  159.                   type: bigint
    160. 

  160.                   expr: _col2
    161. 

  161.                   type: bigint
    162. 

  162.             outputColumnNames: _col0, _col1, _col2
    163. 

  163.             File Output Operator
    164. 

  164.               compressed: false
    165. 

  165.               GlobalTableId: 0
    166. 

  166.               table:
    167. 

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

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

  169. 

  170.   Stage: Stage-0
    171. 

  171.     Fetch Operator
    172. 

  172.       limit: -1
    173. 

  173. 

  174. 

  175. PREHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    176. 

  176. PREHOOK: type: QUERY
    177. 

  177. PREHOOK: Input: default@src
    178. 

  178. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-30_870_1082986772406527025/-mr-10000
    179. 

  179. POSTHOOK: query: select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999
    180. 

  180. POSTHOOK: type: QUERY
    181. 

  181. POSTHOOK: Input: default@src
    182. 

  182. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-30_870_1082986772406527025/-mr-10000
    183. 

  183. 0	0	0
    184. 

  184.