PageRenderTime 42ms CodeModel.GetById 13ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 214 lines | 208 code | 6 blank | 0 comment | 0 complexity | 240b5efccdd2072e9fca8d7a4d2a1022 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE dest1(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE dest1(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE) STORED AS TEXTFILE
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@dest1
    6. 

  6. PREHOOK: query: EXPLAIN
    7. 

  7. FROM src
    8. 

  8. INSERT OVERWRITE TABLE dest1 SELECT
    9. 

  9.   sum(substr(src.value,5)),
    10. 

  10.   avg(substr(src.value,5)),
    11. 

  11.   avg(DISTINCT substr(src.value,5)),
    12. 

  12.   max(substr(src.value,5)),
    13. 

  13.   min(substr(src.value,5)),
    14. 

  14.   std(substr(src.value,5)),
    15. 

  15.   stddev_samp(substr(src.value,5)),
    16. 

  16.   variance(substr(src.value,5)),
    17. 

  17.   var_samp(substr(src.value,5)),
    18. 

  18.   sum(DISTINCT substr(src.value, 5)),
    19. 

  19.   count(DISTINCT substr(src.value, 5))
    20. 

  20. PREHOOK: type: QUERY
    21. 

  21. POSTHOOK: query: EXPLAIN
    22. 

  22. FROM src
    23. 

  23. INSERT OVERWRITE TABLE dest1 SELECT
    24. 

  24.   sum(substr(src.value,5)),
    25. 

  25.   avg(substr(src.value,5)),
    26. 

  26.   avg(DISTINCT substr(src.value,5)),
    27. 

  27.   max(substr(src.value,5)),
    28. 

  28.   min(substr(src.value,5)),
    29. 

  29.   std(substr(src.value,5)),
    30. 

  30.   stddev_samp(substr(src.value,5)),
    31. 

  31.   variance(substr(src.value,5)),
    32. 

  32.   var_samp(substr(src.value,5)),
    33. 

  33.   sum(DISTINCT substr(src.value, 5)),
    34. 

  34.   count(DISTINCT substr(src.value, 5))
    35. 

  35. POSTHOOK: type: QUERY
    36. 

  36. ABSTRACT SYNTAX TREE:
    37. 

  37.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI avg (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION std (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION stddev_samp (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION variance (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION var_samp (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))))))
    38. 

  38. 

  39. STAGE DEPENDENCIES:
    40. 

  40.   Stage-1 is a root stage
    41. 

  41.   Stage-0 depends on stages: Stage-1
    42. 

  42.   Stage-2 depends on stages: Stage-0
    43. 

  43. 

  44. STAGE PLANS:
    45. 

  45.   Stage: Stage-1
    46. 

  46.     Map Reduce
    47. 

  47.       Alias -> Map Operator Tree:
    48. 

  48.         src 
    49. 

  49.           TableScan
    50. 

  50.             alias: src
    51. 

  51.             Select Operator
    52. 

  52.               expressions:
    53. 

  53.                     expr: value
    54. 

  54.                     type: string
    55. 

  55.               outputColumnNames: value
    56. 

  56.               Reduce Output Operator
    57. 

  57.                 key expressions:
    58. 

  58.                       expr: substr(value, 5)
    59. 

  59.                       type: string
    60. 

  60.                 sort order: +
    61. 

  61.                 tag: -1
    62. 

  62.       Reduce Operator Tree:
    63. 

  63.         Group By Operator
    64. 

  64.           aggregations:
    65. 

  65.                 expr: sum(KEY._col0:2._col0)
    66. 

  66.                 expr: avg(KEY._col0:2._col0)
    67. 

  67.                 expr: avg(DISTINCT KEY._col0:0._col0)
    68. 

  68.                 expr: max(KEY._col0:2._col0)
    69. 

  69.                 expr: min(KEY._col0:2._col0)
    70. 

  70.                 expr: std(KEY._col0:2._col0)
    71. 

  71.                 expr: stddev_samp(KEY._col0:2._col0)
    72. 

  72.                 expr: variance(KEY._col0:2._col0)
    73. 

  73.                 expr: var_samp(KEY._col0:2._col0)
    74. 

  74.                 expr: sum(DISTINCT KEY._col0:1._col0)
    75. 

  75.                 expr: count(DISTINCT KEY._col0:2._col0)
    76. 

  76.           bucketGroup: false
    77. 

  77.           mode: complete
    78. 

  78.           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
    79. 

  79.           Select Operator
    80. 

  80.             expressions:
    81. 

  81.                   expr: _col0
    82. 

  82.                   type: double
    83. 

  83.                   expr: _col1
    84. 

  84.                   type: double
    85. 

  85.                   expr: _col2
    86. 

  86.                   type: double
    87. 

  87.                   expr: _col3
    88. 

  88.                   type: string
    89. 

  89.                   expr: _col4
    90. 

  90.                   type: string
    91. 

  91.                   expr: _col5
    92. 

  92.                   type: double
    93. 

  93.                   expr: _col6
    94. 

  94.                   type: double
    95. 

  95.                   expr: _col7
    96. 

  96.                   type: double
    97. 

  97.                   expr: _col8
    98. 

  98.                   type: double
    99. 

  99.                   expr: _col9
    100. 

  100.                   type: double
    101. 

  101.                   expr: _col10
    102. 

  102.                   type: bigint
    103. 

  103.             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
    104. 

  104.             Select Operator
    105. 

  105.               expressions:
    106. 

  106.                     expr: _col0
    107. 

  107.                     type: double
    108. 

  108.                     expr: _col1
    109. 

  109.                     type: double
    110. 

  110.                     expr: _col2
    111. 

  111.                     type: double
    112. 

  112.                     expr: UDFToDouble(_col3)
    113. 

  113.                     type: double
    114. 

  114.                     expr: UDFToDouble(_col4)
    115. 

  115.                     type: double
    116. 

  116.                     expr: _col5
    117. 

  117.                     type: double
    118. 

  118.                     expr: _col6
    119. 

  119.                     type: double
    120. 

  120.                     expr: _col7
    121. 

  121.                     type: double
    122. 

  122.                     expr: _col8
    123. 

  123.                     type: double
    124. 

  124.                     expr: _col9
    125. 

  125.                     type: double
    126. 

  126.                     expr: UDFToDouble(_col10)
    127. 

  127.                     type: double
    128. 

  128.               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
    129. 

  129.               File Output Operator
    130. 

  130.                 compressed: false
    131. 

  131.                 GlobalTableId: 1
    132. 

  132.                 table:
    133. 

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

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

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

  136.                     name: default.dest1
    137. 

  137. 

  138.   Stage: Stage-0
    139. 

  139.     Move Operator
    140. 

  140.       tables:
    141. 

  141.           replace: true
    142. 

  142.           table:
    143. 

  143.               input format: org.apache.hadoop.mapred.TextInputFormat
    144. 

  144.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    145. 

  145.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    146. 

  146.               name: default.dest1
    147. 

  147. 

  148.   Stage: Stage-2
    149. 

  149.     Stats-Aggr Operator
    150. 

  150. 

  151. 

  152. PREHOOK: query: FROM src
    153. 

  153. INSERT OVERWRITE TABLE dest1 SELECT
    154. 

  154.   sum(substr(src.value,5)),
    155. 

  155.   avg(substr(src.value,5)),
    156. 

  156.   avg(DISTINCT substr(src.value,5)),
    157. 

  157.   max(substr(src.value,5)),
    158. 

  158.   min(substr(src.value,5)),
    159. 

  159.   std(substr(src.value,5)),
    160. 

  160.   stddev_samp(substr(src.value,5)),
    161. 

  161.   variance(substr(src.value,5)),
    162. 

  162.   var_samp(substr(src.value,5)),
    163. 

  163.   sum(DISTINCT substr(src.value, 5)),
    164. 

  164.   count(DISTINCT substr(src.value, 5))
    165. 

  165. PREHOOK: type: QUERY
    166. 

  166. PREHOOK: Input: default@src
    167. 

  167. PREHOOK: Output: default@dest1
    168. 

  168. POSTHOOK: query: FROM src
    169. 

  169. INSERT OVERWRITE TABLE dest1 SELECT
    170. 

  170.   sum(substr(src.value,5)),
    171. 

  171.   avg(substr(src.value,5)),
    172. 

  172.   avg(DISTINCT substr(src.value,5)),
    173. 

  173.   max(substr(src.value,5)),
    174. 

  174.   min(substr(src.value,5)),
    175. 

  175.   std(substr(src.value,5)),
    176. 

  176.   stddev_samp(substr(src.value,5)),
    177. 

  177.   variance(substr(src.value,5)),
    178. 

  178.   var_samp(substr(src.value,5)),
    179. 

  179.   sum(DISTINCT substr(src.value, 5)),
    180. 

  180.   count(DISTINCT substr(src.value, 5))
    181. 

  181. POSTHOOK: type: QUERY
    182. 

  182. POSTHOOK: Input: default@src
    183. 

  183. POSTHOOK: Output: default@dest1
    184. 

  184. POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.null, ]
    185. 

  185. POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.null, ]
    186. 

  186. POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.null, ]
    187. 

  187. POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.null, ]
    188. 

  188. POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    189. 

  189. POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.null, ]
    190. 

  190. POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.null, ]
    191. 

  191. POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.null, ]
    192. 

  192. POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.null, ]
    193. 

  193. POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.null, ]
    194. 

  194. POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.null, ]
    195. 

  195. PREHOOK: query: SELECT dest1.* FROM dest1
    196. 

  196. PREHOOK: type: QUERY
    197. 

  197. PREHOOK: Input: default@dest1
    198. 

  198. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-50-57_634_1889269807749157481/-mr-10000
    199. 

  199. POSTHOOK: query: SELECT dest1.* FROM dest1
    200. 

  200. POSTHOOK: type: QUERY
    201. 

  201. POSTHOOK: Input: default@dest1
    202. 

  202. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-50-57_634_1889269807749157481/-mr-10000
    203. 

  203. POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.null, ]
    204. 

  204. POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.null, ]
    205. 

  205. POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.null, ]
    206. 

  206. POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.null, ]
    207. 

  207. POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    208. 

  208. POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.null, ]
    209. 

  209. POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.null, ]
    210. 

  210. POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.null, ]
    211. 

  211. POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.null, ]
    212. 

  212. POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.null, ]
    213. 

  213. POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.null, ]
    214. 

  214. 130091.0	260.182	256.10355987055016	98.0	0.0	142.92680950752379	143.06995106518903	20428.07287599999	20469.010897795582	79136.0	309.0
    215. 

  215.