PageRenderTime 41ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 429 lines | 418 code | 11 blank | 0 comment | 0 complexity | edab9d2181dc9d78ad0072d356bd6fa7 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@T1
  6. PREHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
  7. PREHOOK: type: CREATETABLE
  8. POSTHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
  9. POSTHOOK: type: CREATETABLE
  10. POSTHOOK: Output: default@T2
  11. PREHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
  12. PREHOOK: type: CREATETABLE
  13. POSTHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
  14. POSTHOOK: type: CREATETABLE
  15. POSTHOOK: Output: default@T3
  16. PREHOOK: query: CREATE TABLE T4(key STRING, val STRING) STORED AS TEXTFILE
  17. PREHOOK: type: CREATETABLE
  18. POSTHOOK: query: CREATE TABLE T4(key STRING, val STRING) STORED AS TEXTFILE
  19. POSTHOOK: type: CREATETABLE
  20. POSTHOOK: Output: default@T4
  21. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
  22. PREHOOK: type: LOAD
  23. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
  24. POSTHOOK: type: LOAD
  25. POSTHOOK: Output: default@t1
  26. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
  27. PREHOOK: type: LOAD
  28. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
  29. POSTHOOK: type: LOAD
  30. POSTHOOK: Output: default@t2
  31. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
  32. PREHOOK: type: LOAD
  33. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
  34. POSTHOOK: type: LOAD
  35. POSTHOOK: Output: default@t3
  36. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T4
  37. PREHOOK: type: LOAD
  38. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T4
  39. POSTHOOK: type: LOAD
  40. POSTHOOK: Output: default@t4
  41. PREHOOK: query: EXPLAIN
  42. SELECT /*+ STREAMTABLE(a) */ *
  43. FROM T1 a JOIN T2 b ON a.key = b.key
  44. JOIN T3 c ON b.key = c.key
  45. JOIN T4 d ON c.key = d.key
  46. PREHOOK: type: QUERY
  47. POSTHOOK: query: EXPLAIN
  48. SELECT /*+ STREAMTABLE(a) */ *
  49. FROM T1 a JOIN T2 b ON a.key = b.key
  50. JOIN T3 c ON b.key = c.key
  51. JOIN T4 d ON c.key = d.key
  52. POSTHOOK: type: QUERY
  53. ABSTRACT SYNTAX TREE:
  54. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME T2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME T3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key))) (TOK_TABREF (TOK_TABNAME T4) d) (= (. (TOK_TABLE_OR_COL c) key) (. (TOK_TABLE_OR_COL d) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
  55. STAGE DEPENDENCIES:
  56. Stage-1 is a root stage
  57. Stage-0 is a root stage
  58. STAGE PLANS:
  59. Stage: Stage-1
  60. Map Reduce
  61. Alias -> Map Operator Tree:
  62. a
  63. TableScan
  64. alias: a
  65. Reduce Output Operator
  66. key expressions:
  67. expr: key
  68. type: string
  69. sort order: +
  70. Map-reduce partition columns:
  71. expr: key
  72. type: string
  73. tag: 3
  74. value expressions:
  75. expr: key
  76. type: string
  77. expr: val
  78. type: string
  79. b
  80. TableScan
  81. alias: b
  82. Reduce Output Operator
  83. key expressions:
  84. expr: key
  85. type: string
  86. sort order: +
  87. Map-reduce partition columns:
  88. expr: key
  89. type: string
  90. tag: 1
  91. value expressions:
  92. expr: key
  93. type: string
  94. expr: val
  95. type: string
  96. c
  97. TableScan
  98. alias: c
  99. Reduce Output Operator
  100. key expressions:
  101. expr: key
  102. type: string
  103. sort order: +
  104. Map-reduce partition columns:
  105. expr: key
  106. type: string
  107. tag: 2
  108. value expressions:
  109. expr: key
  110. type: string
  111. expr: val
  112. type: string
  113. d
  114. TableScan
  115. alias: d
  116. Reduce Output Operator
  117. key expressions:
  118. expr: key
  119. type: string
  120. sort order: +
  121. Map-reduce partition columns:
  122. expr: key
  123. type: string
  124. tag: 0
  125. value expressions:
  126. expr: key
  127. type: string
  128. expr: val
  129. type: string
  130. Reduce Operator Tree:
  131. Join Operator
  132. condition map:
  133. Inner Join 0 to 1
  134. Inner Join 1 to 2
  135. Inner Join 2 to 3
  136. condition expressions:
  137. 0 {VALUE._col0} {VALUE._col1}
  138. 1 {VALUE._col0} {VALUE._col1}
  139. 2 {VALUE._col0} {VALUE._col1}
  140. 3 {VALUE._col0} {VALUE._col1}
  141. handleSkewJoin: false
  142. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
  143. Select Operator
  144. expressions:
  145. expr: _col0
  146. type: string
  147. expr: _col1
  148. type: string
  149. expr: _col4
  150. type: string
  151. expr: _col5
  152. type: string
  153. expr: _col8
  154. type: string
  155. expr: _col9
  156. type: string
  157. expr: _col12
  158. type: string
  159. expr: _col13
  160. type: string
  161. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
  162. File Output Operator
  163. compressed: false
  164. GlobalTableId: 0
  165. table:
  166. input format: org.apache.hadoop.mapred.TextInputFormat
  167. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  168. Stage: Stage-0
  169. Fetch Operator
  170. limit: -1
  171. PREHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
  172. FROM T1 a JOIN T2 b ON a.key = b.key
  173. JOIN T3 c ON b.key = c.key
  174. JOIN T4 d ON c.key = d.key
  175. PREHOOK: type: QUERY
  176. PREHOOK: Input: default@t1
  177. PREHOOK: Input: default@t2
  178. PREHOOK: Input: default@t3
  179. PREHOOK: Input: default@t4
  180. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-17_595_7754652804655964686/-mr-10000
  181. POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
  182. FROM T1 a JOIN T2 b ON a.key = b.key
  183. JOIN T3 c ON b.key = c.key
  184. JOIN T4 d ON c.key = d.key
  185. POSTHOOK: type: QUERY
  186. POSTHOOK: Input: default@t1
  187. POSTHOOK: Input: default@t2
  188. POSTHOOK: Input: default@t3
  189. POSTHOOK: Input: default@t4
  190. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-17_595_7754652804655964686/-mr-10000
  191. 2 12 2 22 2 12 2 12
  192. PREHOOK: query: EXPLAIN
  193. SELECT /*+ STREAMTABLE(a) */ *
  194. FROM T1 a JOIN T2 b ON a.key = b.key
  195. JOIN T3 c ON a.val = c.val
  196. JOIN T4 d ON a.key + 1 = d.key + 1
  197. PREHOOK: type: QUERY
  198. POSTHOOK: query: EXPLAIN
  199. SELECT /*+ STREAMTABLE(a) */ *
  200. FROM T1 a JOIN T2 b ON a.key = b.key
  201. JOIN T3 c ON a.val = c.val
  202. JOIN T4 d ON a.key + 1 = d.key + 1
  203. POSTHOOK: type: QUERY
  204. ABSTRACT SYNTAX TREE:
  205. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME T2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME T3) c) (= (. (TOK_TABLE_OR_COL a) val) (. (TOK_TABLE_OR_COL c) val))) (TOK_TABREF (TOK_TABNAME T4) d) (= (+ (. (TOK_TABLE_OR_COL a) key) 1) (+ (. (TOK_TABLE_OR_COL d) key) 1)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
  206. STAGE DEPENDENCIES:
  207. Stage-2 is a root stage
  208. Stage-3 depends on stages: Stage-2
  209. Stage-1 depends on stages: Stage-3
  210. Stage-0 is a root stage
  211. STAGE PLANS:
  212. Stage: Stage-2
  213. Map Reduce
  214. Alias -> Map Operator Tree:
  215. a
  216. TableScan
  217. alias: a
  218. Reduce Output Operator
  219. key expressions:
  220. expr: key
  221. type: string
  222. sort order: +
  223. Map-reduce partition columns:
  224. expr: key
  225. type: string
  226. tag: 1
  227. value expressions:
  228. expr: key
  229. type: string
  230. expr: val
  231. type: string
  232. b
  233. TableScan
  234. alias: b
  235. Reduce Output Operator
  236. key expressions:
  237. expr: key
  238. type: string
  239. sort order: +
  240. Map-reduce partition columns:
  241. expr: key
  242. type: string
  243. tag: 0
  244. value expressions:
  245. expr: key
  246. type: string
  247. expr: val
  248. type: string
  249. Reduce Operator Tree:
  250. Join Operator
  251. condition map:
  252. Inner Join 0 to 1
  253. condition expressions:
  254. 0 {VALUE._col0} {VALUE._col1}
  255. 1 {VALUE._col0} {VALUE._col1}
  256. handleSkewJoin: false
  257. outputColumnNames: _col0, _col1, _col4, _col5
  258. File Output Operator
  259. compressed: false
  260. GlobalTableId: 0
  261. table:
  262. input format: org.apache.hadoop.mapred.SequenceFileInputFormat
  263. output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
  264. Stage: Stage-3
  265. Map Reduce
  266. Alias -> Map Operator Tree:
  267. $INTNAME
  268. Reduce Output Operator
  269. key expressions:
  270. expr: _col1
  271. type: string
  272. sort order: +
  273. Map-reduce partition columns:
  274. expr: _col1
  275. type: string
  276. tag: 1
  277. value expressions:
  278. expr: _col4
  279. type: string
  280. expr: _col5
  281. type: string
  282. expr: _col0
  283. type: string
  284. expr: _col1
  285. type: string
  286. c
  287. TableScan
  288. alias: c
  289. Reduce Output Operator
  290. key expressions:
  291. expr: val
  292. type: string
  293. sort order: +
  294. Map-reduce partition columns:
  295. expr: val
  296. type: string
  297. tag: 0
  298. value expressions:
  299. expr: key
  300. type: string
  301. expr: val
  302. type: string
  303. Reduce Operator Tree:
  304. Join Operator
  305. condition map:
  306. Inner Join 0 to 1
  307. condition expressions:
  308. 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
  309. 1 {VALUE._col0} {VALUE._col1}
  310. handleSkewJoin: false
  311. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  312. File Output Operator
  313. compressed: false
  314. GlobalTableId: 0
  315. table:
  316. input format: org.apache.hadoop.mapred.SequenceFileInputFormat
  317. output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
  318. Stage: Stage-1
  319. Map Reduce
  320. Alias -> Map Operator Tree:
  321. $INTNAME
  322. Reduce Output Operator
  323. key expressions:
  324. expr: (_col4 + 1)
  325. type: double
  326. sort order: +
  327. Map-reduce partition columns:
  328. expr: (_col4 + 1)
  329. type: double
  330. tag: 1
  331. value expressions:
  332. expr: _col0
  333. type: string
  334. expr: _col1
  335. type: string
  336. expr: _col8
  337. type: string
  338. expr: _col9
  339. type: string
  340. expr: _col4
  341. type: string
  342. expr: _col5
  343. type: string
  344. d
  345. TableScan
  346. alias: d
  347. Reduce Output Operator
  348. key expressions:
  349. expr: (key + 1)
  350. type: double
  351. sort order: +
  352. Map-reduce partition columns:
  353. expr: (key + 1)
  354. type: double
  355. tag: 0
  356. value expressions:
  357. expr: key
  358. type: string
  359. expr: val
  360. type: string
  361. Reduce Operator Tree:
  362. Join Operator
  363. condition map:
  364. Inner Join 0 to 1
  365. condition expressions:
  366. 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
  367. 1 {VALUE._col0} {VALUE._col1}
  368. handleSkewJoin: false
  369. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
  370. Select Operator
  371. expressions:
  372. expr: _col8
  373. type: string
  374. expr: _col9
  375. type: string
  376. expr: _col0
  377. type: string
  378. expr: _col1
  379. type: string
  380. expr: _col4
  381. type: string
  382. expr: _col5
  383. type: string
  384. expr: _col12
  385. type: string
  386. expr: _col13
  387. type: string
  388. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
  389. File Output Operator
  390. compressed: false
  391. GlobalTableId: 0
  392. table:
  393. input format: org.apache.hadoop.mapred.TextInputFormat
  394. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  395. Stage: Stage-0
  396. Fetch Operator
  397. limit: -1
  398. PREHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
  399. FROM T1 a JOIN T2 b ON a.key = b.key
  400. JOIN T3 c ON a.val = c.val
  401. JOIN T4 d ON a.key + 1 = d.key + 1
  402. PREHOOK: type: QUERY
  403. PREHOOK: Input: default@t1
  404. PREHOOK: Input: default@t2
  405. PREHOOK: Input: default@t3
  406. PREHOOK: Input: default@t4
  407. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-23_174_5401036993230810041/-mr-10000
  408. POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
  409. FROM T1 a JOIN T2 b ON a.key = b.key
  410. JOIN T3 c ON a.val = c.val
  411. JOIN T4 d ON a.key + 1 = d.key + 1
  412. POSTHOOK: type: QUERY
  413. POSTHOOK: Input: default@t1
  414. POSTHOOK: Input: default@t2
  415. POSTHOOK: Input: default@t3
  416. POSTHOOK: Input: default@t4
  417. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-23_174_5401036993230810041/-mr-10000
  418. 2 12 2 22 2 12 2 12