PageRenderTime 40ms CodeModel.GetById 11ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 150 lines | 143 code | 7 blank | 0 comment | 0 complexity | 7b39c30bba0bbb47d6fe8bfbb09bb25b MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest1
  6. PREHOOK: query: EXPLAIN
  7. FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
  8. PREHOOK: type: QUERY
  9. POSTHOOK: query: EXPLAIN
  10. FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
  11. POSTHOOK: type: QUERY
  12. ABSTRACT SYNTAX TREE:
  13. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key)) (TOK_LIMIT 5)))
  14. STAGE DEPENDENCIES:
  15. Stage-1 is a root stage
  16. Stage-2 depends on stages: Stage-1
  17. Stage-0 depends on stages: Stage-2
  18. Stage-3 depends on stages: Stage-0
  19. STAGE PLANS:
  20. Stage: Stage-1
  21. Map Reduce
  22. Alias -> Map Operator Tree:
  23. src
  24. TableScan
  25. alias: src
  26. Select Operator
  27. expressions:
  28. expr: key
  29. type: string
  30. expr: value
  31. type: string
  32. outputColumnNames: key, value
  33. Group By Operator
  34. aggregations:
  35. expr: sum(substr(value, 5))
  36. bucketGroup: false
  37. keys:
  38. expr: key
  39. type: string
  40. mode: hash
  41. outputColumnNames: _col0, _col1
  42. Reduce Output Operator
  43. key expressions:
  44. expr: _col0
  45. type: string
  46. sort order: +
  47. Map-reduce partition columns:
  48. expr: _col0
  49. type: string
  50. tag: -1
  51. value expressions:
  52. expr: _col1
  53. type: double
  54. Reduce Operator Tree:
  55. Group By Operator
  56. aggregations:
  57. expr: sum(VALUE._col0)
  58. bucketGroup: false
  59. keys:
  60. expr: KEY._col0
  61. type: string
  62. mode: mergepartial
  63. outputColumnNames: _col0, _col1
  64. Select Operator
  65. expressions:
  66. expr: _col0
  67. type: string
  68. expr: _col1
  69. type: double
  70. outputColumnNames: _col0, _col1
  71. Limit
  72. File Output Operator
  73. compressed: false
  74. GlobalTableId: 0
  75. table:
  76. input format: org.apache.hadoop.mapred.SequenceFileInputFormat
  77. output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
  78. Stage: Stage-2
  79. Map Reduce
  80. Alias -> Map Operator Tree:
  81. file:/tmp/sdong/hive_2011-02-10_01-49-04_956_406305842309592902/-mr-10002
  82. Reduce Output Operator
  83. sort order:
  84. tag: -1
  85. value expressions:
  86. expr: _col0
  87. type: string
  88. expr: _col1
  89. type: double
  90. Reduce Operator Tree:
  91. Extract
  92. Limit
  93. Select Operator
  94. expressions:
  95. expr: UDFToInteger(_col0)
  96. type: int
  97. expr: _col1
  98. type: double
  99. outputColumnNames: _col0, _col1
  100. File Output Operator
  101. compressed: false
  102. GlobalTableId: 1
  103. table:
  104. input format: org.apache.hadoop.mapred.TextInputFormat
  105. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  106. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  107. name: default.dest1
  108. Stage: Stage-0
  109. Move Operator
  110. tables:
  111. replace: true
  112. table:
  113. input format: org.apache.hadoop.mapred.TextInputFormat
  114. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  115. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  116. name: default.dest1
  117. Stage: Stage-3
  118. Stats-Aggr Operator
  119. PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
  120. PREHOOK: type: QUERY
  121. PREHOOK: Input: default@src
  122. PREHOOK: Output: default@dest1
  123. POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
  124. POSTHOOK: type: QUERY
  125. POSTHOOK: Input: default@src
  126. POSTHOOK: Output: default@dest1
  127. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  128. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  129. PREHOOK: query: SELECT dest1.* FROM dest1
  130. PREHOOK: type: QUERY
  131. PREHOOK: Input: default@dest1
  132. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-49-12_798_2878850829077906411/-mr-10000
  133. POSTHOOK: query: SELECT dest1.* FROM dest1
  134. POSTHOOK: type: QUERY
  135. POSTHOOK: Input: default@dest1
  136. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-49-12_798_2878850829077906411/-mr-10000
  137. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  138. POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  139. 0 0.0
  140. 10 10.0
  141. 100 200.0
  142. 103 206.0
  143. 104 208.0