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

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

#
text | 209 lines | 199 code | 10 blank | 0 comment | 0 complexity | 31c98968031ebb28892cfd6b7d1bf993 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING, val2 STRING) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING, val2 STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest_j1
  6. PREHOOK: query: EXPLAIN
  7. INSERT OVERWRITE TABLE dest_j1
  8. SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
  9. FROM src1 x JOIN src y ON (x.value = y.value)
  10. PREHOOK: type: QUERY
  11. POSTHOOK: query: EXPLAIN
  12. INSERT OVERWRITE TABLE dest_j1
  13. SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
  14. FROM src1 x JOIN src y ON (x.value = y.value)
  15. POSTHOOK: type: QUERY
  16. ABSTRACT SYNTAX TREE:
  17. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (= (. (TOK_TABLE_OR_COL x) value) (. (TOK_TABLE_OR_COL y) value)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_j1))) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value)))))
  18. STAGE DEPENDENCIES:
  19. Stage-7 is a root stage
  20. Stage-1 depends on stages: Stage-7
  21. Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
  22. Stage-4
  23. Stage-0 depends on stages: Stage-4, Stage-3
  24. Stage-2 depends on stages: Stage-0
  25. Stage-3
  26. STAGE PLANS:
  27. Stage: Stage-7
  28. Map Reduce Local Work
  29. Alias -> Map Local Tables:
  30. x
  31. Fetch Operator
  32. limit: -1
  33. Alias -> Map Local Operator Tree:
  34. x
  35. TableScan
  36. alias: x
  37. HashTable Sink Operator
  38. condition expressions:
  39. 0 {key} {value}
  40. 1 {value}
  41. handleSkewJoin: false
  42. keys:
  43. 0 [Column[value]]
  44. 1 [Column[value]]
  45. Position of Big Table: 1
  46. Stage: Stage-1
  47. Map Reduce
  48. Alias -> Map Operator Tree:
  49. y
  50. TableScan
  51. alias: y
  52. Map Join Operator
  53. condition map:
  54. Inner Join 0 to 1
  55. condition expressions:
  56. 0 {key} {value}
  57. 1 {value}
  58. handleSkewJoin: false
  59. keys:
  60. 0 [Column[value]]
  61. 1 [Column[value]]
  62. outputColumnNames: _col0, _col1, _col5
  63. Position of Big Table: 1
  64. Select Operator
  65. expressions:
  66. expr: _col0
  67. type: string
  68. expr: _col1
  69. type: string
  70. expr: _col5
  71. type: string
  72. outputColumnNames: _col0, _col1, _col5
  73. Select Operator
  74. expressions:
  75. expr: _col0
  76. type: string
  77. expr: _col1
  78. type: string
  79. expr: _col5
  80. type: string
  81. outputColumnNames: _col0, _col1, _col2
  82. Select Operator
  83. expressions:
  84. expr: UDFToInteger(_col0)
  85. type: int
  86. expr: _col1
  87. type: string
  88. expr: _col2
  89. type: string
  90. outputColumnNames: _col0, _col1, _col2
  91. File Output Operator
  92. compressed: false
  93. GlobalTableId: 1
  94. table:
  95. input format: org.apache.hadoop.mapred.TextInputFormat
  96. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  97. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  98. name: default.dest_j1
  99. Local Work:
  100. Map Reduce Local Work
  101. Stage: Stage-5
  102. Conditional Operator
  103. Stage: Stage-4
  104. Move Operator
  105. files:
  106. hdfs directory: true
  107. destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-08_290_5231941166795202890/-ext-10000
  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.dest_j1
  117. Stage: Stage-2
  118. Stats-Aggr Operator
  119. Stage: Stage-3
  120. Map Reduce
  121. Alias -> Map Operator Tree:
  122. pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-08_290_5231941166795202890/-ext-10002
  123. File Output Operator
  124. compressed: false
  125. GlobalTableId: 0
  126. table:
  127. input format: org.apache.hadoop.mapred.TextInputFormat
  128. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  129. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  130. name: default.dest_j1
  131. PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
  132. SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
  133. FROM src1 x JOIN src y ON (x.value = y.value)
  134. PREHOOK: type: QUERY
  135. PREHOOK: Input: default@src
  136. PREHOOK: Input: default@src1
  137. PREHOOK: Output: default@dest_j1
  138. POSTHOOK: query: INSERT OVERWRITE TABLE dest_j1
  139. SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
  140. FROM src1 x JOIN src y ON (x.value = y.value)
  141. POSTHOOK: type: QUERY
  142. POSTHOOK: Input: default@src
  143. POSTHOOK: Input: default@src1
  144. POSTHOOK: Output: default@dest_j1
  145. POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
  146. POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
  147. POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
  148. PREHOOK: query: select * from dest_j1 x order by x.key, x.value
  149. PREHOOK: type: QUERY
  150. PREHOOK: Input: default@dest_j1
  151. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-15_076_7667701666661422377/-mr-10000
  152. POSTHOOK: query: select * from dest_j1 x order by x.key, x.value
  153. POSTHOOK: type: QUERY
  154. POSTHOOK: Input: default@dest_j1
  155. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-15_076_7667701666661422377/-mr-10000
  156. POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
  157. POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
  158. POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
  159. NULL val_165 val_165
  160. NULL val_165 val_165
  161. NULL val_193 val_193
  162. NULL val_193 val_193
  163. NULL val_193 val_193
  164. NULL val_265 val_265
  165. NULL val_265 val_265
  166. NULL val_27 val_27
  167. NULL val_409 val_409
  168. NULL val_409 val_409
  169. NULL val_409 val_409
  170. NULL val_484 val_484
  171. 66 val_66 val_66
  172. 98 val_98 val_98
  173. 98 val_98 val_98
  174. 146 val_146 val_146
  175. 146 val_146 val_146
  176. 150 val_150 val_150
  177. 213 val_213 val_213
  178. 213 val_213 val_213
  179. 238 val_238 val_238
  180. 238 val_238 val_238
  181. 255 val_255 val_255
  182. 255 val_255 val_255
  183. 273 val_273 val_273
  184. 273 val_273 val_273
  185. 273 val_273 val_273
  186. 278 val_278 val_278
  187. 278 val_278 val_278
  188. 311 val_311 val_311
  189. 311 val_311 val_311
  190. 311 val_311 val_311
  191. 401 val_401 val_401
  192. 401 val_401 val_401
  193. 401 val_401 val_401
  194. 401 val_401 val_401
  195. 401 val_401 val_401
  196. 406 val_406 val_406
  197. 406 val_406 val_406
  198. 406 val_406 val_406
  199. 406 val_406 val_406