PageRenderTime 42ms CodeModel.GetById 14ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/notable_alias2.q.out

#
text | 190 lines | 184 code | 6 blank | 0 comment | 0 complexity | 64b6d84ba49597321103016d09c81e77 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value 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 '1234', src.key, count(1) WHERE key < 100 group by src.key
    9. 

  9. PREHOOK: type: QUERY
    10. 

  10. POSTHOOK: query: EXPLAIN
    11. 

  11. FROM src
    12. 

  12. INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
    13. 

  13. POSTHOOK: type: QUERY
    14. 

  14. ABSTRACT SYNTAX TREE:
    15. 

  15.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR '1234') (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 100)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
    16. 

  16. 

  17. STAGE DEPENDENCIES:
    18. 

  18.   Stage-1 is a root stage
    19. 

  19.   Stage-0 depends on stages: Stage-1
    20. 

  20.   Stage-2 depends on stages: Stage-0
    21. 

  21. 

  22. STAGE PLANS:
    23. 

  23.   Stage: Stage-1
    24. 

  24.     Map Reduce
    25. 

  25.       Alias -> Map Operator Tree:
    26. 

  26.         src 
    27. 

  27.           TableScan
    28. 

  28.             alias: src
    29. 

  29.             Filter Operator
    30. 

  30.               predicate:
    31. 

  31.                   expr: (key < 100)
    32. 

  32.                   type: boolean
    33. 

  33.               Select Operator
    34. 

  34.                 expressions:
    35. 

  35.                       expr: key
    36. 

  36.                       type: string
    37. 

  37.                 outputColumnNames: key
    38. 

  38.                 Group By Operator
    39. 

  39.                   aggregations:
    40. 

  40.                         expr: count(1)
    41. 

  41.                   bucketGroup: false
    42. 

  42.                   keys:
    43. 

  43.                         expr: key
    44. 

  44.                         type: string
    45. 

  45.                   mode: hash
    46. 

  46.                   outputColumnNames: _col0, _col1
    47. 

  47.                   Reduce Output Operator
    48. 

  48.                     key expressions:
    49. 

  49.                           expr: _col0
    50. 

  50.                           type: string
    51. 

  51.                     sort order: +
    52. 

  52.                     Map-reduce partition columns:
    53. 

  53.                           expr: _col0
    54. 

  54.                           type: string
    55. 

  55.                     tag: -1
    56. 

  56.                     value expressions:
    57. 

  57.                           expr: _col1
    58. 

  58.                           type: bigint
    59. 

  59.       Reduce Operator Tree:
    60. 

  60.         Group By Operator
    61. 

  61.           aggregations:
    62. 

  62.                 expr: count(VALUE._col0)
    63. 

  63.           bucketGroup: false
    64. 

  64.           keys:
    65. 

  65.                 expr: KEY._col0
    66. 

  66.                 type: string
    67. 

  67.           mode: mergepartial
    68. 

  68.           outputColumnNames: _col0, _col1
    69. 

  69.           Select Operator
    70. 

  70.             expressions:
    71. 

  71.                   expr: '1234'
    72. 

  72.                   type: string
    73. 

  73.                   expr: _col0
    74. 

  74.                   type: string
    75. 

  75.                   expr: _col1
    76. 

  76.                   type: bigint
    77. 

  77.             outputColumnNames: _col0, _col1, _col2
    78. 

  78.             Select Operator
    79. 

  79.               expressions:
    80. 

  80.                     expr: _col0
    81. 

  81.                     type: string
    82. 

  82.                     expr: UDFToInteger(_col1)
    83. 

  83.                     type: int
    84. 

  84.                     expr: UDFToDouble(_col2)
    85. 

  85.                     type: double
    86. 

  86.               outputColumnNames: _col0, _col1, _col2
    87. 

  87.               File Output Operator
    88. 

  88.                 compressed: false
    89. 

  89.                 GlobalTableId: 1
    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.                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    94. 

  94.                     name: default.dest1
    95. 

  95. 

  96.   Stage: Stage-0
    97. 

  97.     Move Operator
    98. 

  98.       tables:
    99. 

  99.           replace: true
    100. 

  100.           table:
    101. 

  101.               input format: org.apache.hadoop.mapred.TextInputFormat
    102. 

  102.               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    103. 

  103.               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
    104. 

  104.               name: default.dest1
    105. 

  105. 

  106.   Stage: Stage-2
    107. 

  107.     Stats-Aggr Operator
    108. 

  108. 

  109. 

  110. PREHOOK: query: FROM src
    111. 

  111. INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
    112. 

  112. PREHOOK: type: QUERY
    113. 

  113. PREHOOK: Input: default@src
    114. 

  114. PREHOOK: Output: default@dest1
    115. 

  115. POSTHOOK: query: FROM src
    116. 

  116. INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key
    117. 

  117. POSTHOOK: type: QUERY
    118. 

  118. POSTHOOK: Input: default@src
    119. 

  119. POSTHOOK: Output: default@dest1
    120. 

  120. POSTHOOK: Lineage: dest1.dummy SIMPLE []
    121. 

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

  122. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.null, ]
    123. 

  123. PREHOOK: query: SELECT dest1.* FROM dest1
    124. 

  124. PREHOOK: type: QUERY
    125. 

  125. PREHOOK: Input: default@dest1
    126. 

  126. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-46-42_892_8229387239834597089/-mr-10000
    127. 

  127. POSTHOOK: query: SELECT dest1.* FROM dest1
    128. 

  128. POSTHOOK: type: QUERY
    129. 

  129. POSTHOOK: Input: default@dest1
    130. 

  130. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-46-42_892_8229387239834597089/-mr-10000
    131. 

  131. POSTHOOK: Lineage: dest1.dummy SIMPLE []
    132. 

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

  133. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.null, ]
    134. 

  134. 1234	0	3.0
    135. 

  135. 1234	10	1.0
    136. 

  136. 1234	11	1.0
    137. 

  137. 1234	12	2.0
    138. 

  138. 1234	15	2.0
    139. 

  139. 1234	17	1.0
    140. 

  140. 1234	18	2.0
    141. 

  141. 1234	19	1.0
    142. 

  142. 1234	2	1.0
    143. 

  143. 1234	20	1.0
    144. 

  144. 1234	24	2.0
    145. 

  145. 1234	26	2.0
    146. 

  146. 1234	27	1.0
    147. 

  147. 1234	28	1.0
    148. 

  148. 1234	30	1.0
    149. 

  149. 1234	33	1.0
    150. 

  150. 1234	34	1.0
    151. 

  151. 1234	35	3.0
    152. 

  152. 1234	37	2.0
    153. 

  153. 1234	4	1.0
    154. 

  154. 1234	41	1.0
    155. 

  155. 1234	42	2.0
    156. 

  156. 1234	43	1.0
    157. 

  157. 1234	44	1.0
    158. 

  158. 1234	47	1.0
    159. 

  159. 1234	5	3.0
    160. 

  160. 1234	51	2.0
    161. 

  161. 1234	53	1.0
    162. 

  162. 1234	54	1.0
    163. 

  163. 1234	57	1.0
    164. 

  164. 1234	58	2.0
    165. 

  165. 1234	64	1.0
    166. 

  166. 1234	65	1.0
    167. 

  167. 1234	66	1.0
    168. 

  168. 1234	67	2.0
    169. 

  169. 1234	69	1.0
    170. 

  170. 1234	70	3.0
    171. 

  171. 1234	72	2.0
    172. 

  172. 1234	74	1.0
    173. 

  173. 1234	76	2.0
    174. 

  174. 1234	77	1.0
    175. 

  175. 1234	78	1.0
    176. 

  176. 1234	8	1.0
    177. 

  177. 1234	80	1.0
    178. 

  178. 1234	82	1.0
    179. 

  179. 1234	83	2.0
    180. 

  180. 1234	84	2.0
    181. 

  181. 1234	85	1.0
    182. 

  182. 1234	86	1.0
    183. 

  183. 1234	87	1.0
    184. 

  184. 1234	9	1.0
    185. 

  185. 1234	90	3.0
    186. 

  186. 1234	92	1.0
    187. 

  187. 1234	95	2.0
    188. 

  188. 1234	96	1.0
    189. 

  189. 1234	97	2.0
    190. 

  190. 1234	98	2.0
    191. 

  191.