PageRenderTime 117ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 223 lines | 217 code | 6 blank | 0 comment | 0 complexity | 3c1c21b9386990380046f8d7f42871ed 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 STRING) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest1
  6. PREHOOK: query: EXPLAIN
  7. FROM (
  8. FROM src
  9. SELECT TRANSFORM(src.key, src.value)
  10. USING '/bin/cat' AS (tkey, tvalue)
  11. CLUSTER BY tkey
  12. ) tmap
  13. INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
  14. PREHOOK: type: QUERY
  15. POSTHOOK: query: EXPLAIN
  16. FROM (
  17. FROM src
  18. SELECT TRANSFORM(src.key, src.value)
  19. USING '/bin/cat' AS (tkey, tvalue)
  20. CLUSTER BY tkey
  21. ) tmap
  22. INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
  23. POSTHOOK: type: QUERY
  24. ABSTRACT SYNTAX TREE:
  25. (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) TOK_SERDE TOK_RECORDWRITER '/bin/cat' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL tkey)))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tkey)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tvalue))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL tmap) tkey) 100))))
  26. STAGE DEPENDENCIES:
  27. Stage-1 is a root stage
  28. Stage-0 depends on stages: Stage-1
  29. Stage-2 depends on stages: Stage-0
  30. STAGE PLANS:
  31. Stage: Stage-1
  32. Map Reduce
  33. Alias -> Map Operator Tree:
  34. tmap:src
  35. TableScan
  36. alias: src
  37. Select Operator
  38. expressions:
  39. expr: key
  40. type: string
  41. expr: value
  42. type: string
  43. outputColumnNames: _col0, _col1
  44. Transform Operator
  45. command: /bin/cat
  46. output info:
  47. input format: org.apache.hadoop.mapred.TextInputFormat
  48. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  49. Reduce Output Operator
  50. key expressions:
  51. expr: _col0
  52. type: string
  53. sort order: +
  54. Map-reduce partition columns:
  55. expr: _col0
  56. type: string
  57. tag: -1
  58. value expressions:
  59. expr: _col0
  60. type: string
  61. expr: _col1
  62. type: string
  63. Reduce Operator Tree:
  64. Extract
  65. Filter Operator
  66. predicate:
  67. expr: (_col0 < 100)
  68. type: boolean
  69. Select Operator
  70. expressions:
  71. expr: _col0
  72. type: string
  73. expr: _col1
  74. type: string
  75. outputColumnNames: _col0, _col1
  76. Select Operator
  77. expressions:
  78. expr: UDFToInteger(_col0)
  79. type: int
  80. expr: _col1
  81. type: string
  82. outputColumnNames: _col0, _col1
  83. File Output Operator
  84. compressed: false
  85. GlobalTableId: 1
  86. table:
  87. input format: org.apache.hadoop.mapred.TextInputFormat
  88. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  89. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  90. name: default.dest1
  91. Stage: Stage-0
  92. Move Operator
  93. tables:
  94. replace: true
  95. table:
  96. input format: org.apache.hadoop.mapred.TextInputFormat
  97. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  98. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  99. name: default.dest1
  100. Stage: Stage-2
  101. Stats-Aggr Operator
  102. PREHOOK: query: FROM (
  103. FROM src
  104. SELECT TRANSFORM(src.key, src.value)
  105. USING '/bin/cat' AS (tkey, tvalue)
  106. CLUSTER BY tkey
  107. ) tmap
  108. INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
  109. PREHOOK: type: QUERY
  110. PREHOOK: Input: default@src
  111. PREHOOK: Output: default@dest1
  112. POSTHOOK: query: FROM (
  113. FROM src
  114. SELECT TRANSFORM(src.key, src.value)
  115. USING '/bin/cat' AS (tkey, tvalue)
  116. CLUSTER BY tkey
  117. ) tmap
  118. INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
  119. POSTHOOK: type: QUERY
  120. POSTHOOK: Input: default@src
  121. POSTHOOK: Output: default@dest1
  122. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  123. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  124. PREHOOK: query: SELECT dest1.* FROM dest1
  125. PREHOOK: type: QUERY
  126. PREHOOK: Input: default@dest1
  127. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-29_559_2350793027602595084/-mr-10000
  128. POSTHOOK: query: SELECT dest1.* FROM dest1
  129. POSTHOOK: type: QUERY
  130. POSTHOOK: Input: default@dest1
  131. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-29_559_2350793027602595084/-mr-10000
  132. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  133. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
  134. 0 val_0
  135. 0 val_0
  136. 0 val_0
  137. 10 val_10
  138. 11 val_11
  139. 12 val_12
  140. 12 val_12
  141. 15 val_15
  142. 15 val_15
  143. 17 val_17
  144. 18 val_18
  145. 18 val_18
  146. 19 val_19
  147. 2 val_2
  148. 20 val_20
  149. 24 val_24
  150. 24 val_24
  151. 26 val_26
  152. 26 val_26
  153. 27 val_27
  154. 28 val_28
  155. 30 val_30
  156. 33 val_33
  157. 34 val_34
  158. 35 val_35
  159. 35 val_35
  160. 35 val_35
  161. 37 val_37
  162. 37 val_37
  163. 4 val_4
  164. 41 val_41
  165. 42 val_42
  166. 42 val_42
  167. 43 val_43
  168. 44 val_44
  169. 47 val_47
  170. 5 val_5
  171. 5 val_5
  172. 5 val_5
  173. 51 val_51
  174. 51 val_51
  175. 53 val_53
  176. 54 val_54
  177. 57 val_57
  178. 58 val_58
  179. 58 val_58
  180. 64 val_64
  181. 65 val_65
  182. 66 val_66
  183. 67 val_67
  184. 67 val_67
  185. 69 val_69
  186. 70 val_70
  187. 70 val_70
  188. 70 val_70
  189. 72 val_72
  190. 72 val_72
  191. 74 val_74
  192. 76 val_76
  193. 76 val_76
  194. 77 val_77
  195. 78 val_78
  196. 8 val_8
  197. 80 val_80
  198. 82 val_82
  199. 83 val_83
  200. 83 val_83
  201. 84 val_84
  202. 84 val_84
  203. 85 val_85
  204. 86 val_86
  205. 87 val_87
  206. 9 val_9
  207. 90 val_90
  208. 90 val_90
  209. 90 val_90
  210. 92 val_92
  211. 95 val_95
  212. 95 val_95
  213. 96 val_96
  214. 97 val_97
  215. 97 val_97
  216. 98 val_98
  217. 98 val_98