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

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

#
text | 546 lines | 501 code | 45 blank | 0 comment | 0 complexity | a6ba5aaea9307d8ccf70a91272ddecb8 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: EXPLAIN
  2. SELECT * FROM srcpart
  3. PREHOOK: type: QUERY
  4. POSTHOOK: query: EXPLAIN
  5. SELECT * FROM srcpart
  6. POSTHOOK: type: QUERY
  7. ABSTRACT SYNTAX TREE:
  8. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
  9. STAGE DEPENDENCIES:
  10. Stage-0 is a root stage
  11. STAGE PLANS:
  12. Stage: Stage-0
  13. Fetch Operator
  14. limit: -1
  15. PREHOOK: query: EXPLAIN
  16. SELECT `..` FROM srcpart
  17. PREHOOK: type: QUERY
  18. POSTHOOK: query: EXPLAIN
  19. SELECT `..` FROM srcpart
  20. POSTHOOK: type: QUERY
  21. ABSTRACT SYNTAX TREE:
  22. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `..`)))))
  23. STAGE DEPENDENCIES:
  24. Stage-1 is a root stage
  25. Stage-0 is a root stage
  26. STAGE PLANS:
  27. Stage: Stage-1
  28. Map Reduce
  29. Alias -> Map Operator Tree:
  30. srcpart
  31. TableScan
  32. alias: srcpart
  33. Select Operator
  34. expressions:
  35. expr: ds
  36. type: string
  37. expr: hr
  38. type: string
  39. outputColumnNames: _col0, _col1
  40. File Output Operator
  41. compressed: false
  42. GlobalTableId: 0
  43. table:
  44. input format: org.apache.hadoop.mapred.TextInputFormat
  45. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  46. Stage: Stage-0
  47. Fetch Operator
  48. limit: -1
  49. PREHOOK: query: EXPLAIN
  50. SELECT srcpart.`..` FROM srcpart
  51. PREHOOK: type: QUERY
  52. POSTHOOK: query: EXPLAIN
  53. SELECT srcpart.`..` FROM srcpart
  54. POSTHOOK: type: QUERY
  55. ABSTRACT SYNTAX TREE:
  56. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) `..`)))))
  57. STAGE DEPENDENCIES:
  58. Stage-1 is a root stage
  59. Stage-0 is a root stage
  60. STAGE PLANS:
  61. Stage: Stage-1
  62. Map Reduce
  63. Alias -> Map Operator Tree:
  64. srcpart
  65. TableScan
  66. alias: srcpart
  67. Select Operator
  68. expressions:
  69. expr: ds
  70. type: string
  71. expr: hr
  72. type: string
  73. outputColumnNames: _col0, _col1
  74. File Output Operator
  75. compressed: false
  76. GlobalTableId: 0
  77. table:
  78. input format: org.apache.hadoop.mapred.TextInputFormat
  79. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  80. Stage: Stage-0
  81. Fetch Operator
  82. limit: -1
  83. PREHOOK: query: EXPLAIN
  84. SELECT `..` FROM srcpart a JOIN srcpart b
  85. ON a.key = b.key AND a.value = b.value
  86. PREHOOK: type: QUERY
  87. POSTHOOK: query: EXPLAIN
  88. SELECT `..` FROM srcpart a JOIN srcpart b
  89. ON a.key = b.key AND a.value = b.value
  90. POSTHOOK: type: QUERY
  91. ABSTRACT SYNTAX TREE:
  92. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME srcpart) b) (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL a) value) (. (TOK_TABLE_OR_COL b) value))))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `..`)))))
  93. STAGE DEPENDENCIES:
  94. Stage-1 is a root stage
  95. Stage-0 is a root stage
  96. STAGE PLANS:
  97. Stage: Stage-1
  98. Map Reduce
  99. Alias -> Map Operator Tree:
  100. a
  101. TableScan
  102. alias: a
  103. Reduce Output Operator
  104. key expressions:
  105. expr: key
  106. type: string
  107. expr: value
  108. type: string
  109. sort order: ++
  110. Map-reduce partition columns:
  111. expr: key
  112. type: string
  113. expr: value
  114. type: string
  115. tag: 0
  116. value expressions:
  117. expr: ds
  118. type: string
  119. expr: hr
  120. type: string
  121. b
  122. TableScan
  123. alias: b
  124. Reduce Output Operator
  125. key expressions:
  126. expr: key
  127. type: string
  128. expr: value
  129. type: string
  130. sort order: ++
  131. Map-reduce partition columns:
  132. expr: key
  133. type: string
  134. expr: value
  135. type: string
  136. tag: 1
  137. value expressions:
  138. expr: ds
  139. type: string
  140. expr: hr
  141. type: string
  142. Reduce Operator Tree:
  143. Join Operator
  144. condition map:
  145. Inner Join 0 to 1
  146. condition expressions:
  147. 0 {VALUE._col2} {VALUE._col3}
  148. 1 {VALUE._col2} {VALUE._col3}
  149. handleSkewJoin: false
  150. outputColumnNames: _col2, _col3, _col8, _col9
  151. Select Operator
  152. expressions:
  153. expr: _col2
  154. type: string
  155. expr: _col3
  156. type: string
  157. expr: _col8
  158. type: string
  159. expr: _col9
  160. type: string
  161. outputColumnNames: _col0, _col1, _col2, _col3
  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: EXPLAIN
  172. SELECT b.`..` FROM srcpart a JOIN srcpart b
  173. ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
  174. ORDER BY ds, hr
  175. PREHOOK: type: QUERY
  176. POSTHOOK: query: EXPLAIN
  177. SELECT b.`..` FROM srcpart a JOIN srcpart b
  178. ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
  179. ORDER BY ds, hr
  180. POSTHOOK: type: QUERY
  181. ABSTRACT SYNTAX TREE:
  182. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME srcpart) b) (AND (AND (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL a) hr) (. (TOK_TABLE_OR_COL b) hr))) (= (. (TOK_TABLE_OR_COL a) ds) (. (TOK_TABLE_OR_COL b) ds))) (= (. (TOK_TABLE_OR_COL a) key) 103)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) `..`))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL ds)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL hr)))))
  183. STAGE DEPENDENCIES:
  184. Stage-1 is a root stage
  185. Stage-2 depends on stages: Stage-1
  186. Stage-0 is a root stage
  187. STAGE PLANS:
  188. Stage: Stage-1
  189. Map Reduce
  190. Alias -> Map Operator Tree:
  191. a
  192. TableScan
  193. alias: a
  194. Filter Operator
  195. predicate:
  196. expr: (key = 103)
  197. type: boolean
  198. Filter Operator
  199. predicate:
  200. expr: (key = 103)
  201. type: boolean
  202. Reduce Output Operator
  203. key expressions:
  204. expr: key
  205. type: string
  206. expr: hr
  207. type: string
  208. expr: ds
  209. type: string
  210. sort order: +++
  211. Map-reduce partition columns:
  212. expr: key
  213. type: string
  214. expr: hr
  215. type: string
  216. expr: ds
  217. type: string
  218. tag: 0
  219. b
  220. TableScan
  221. alias: b
  222. Reduce Output Operator
  223. key expressions:
  224. expr: key
  225. type: string
  226. expr: hr
  227. type: string
  228. expr: ds
  229. type: string
  230. sort order: +++
  231. Map-reduce partition columns:
  232. expr: key
  233. type: string
  234. expr: hr
  235. type: string
  236. expr: ds
  237. type: string
  238. tag: 1
  239. value expressions:
  240. expr: ds
  241. type: string
  242. expr: hr
  243. type: string
  244. Reduce Operator Tree:
  245. Join Operator
  246. condition map:
  247. Inner Join 0 to 1
  248. condition expressions:
  249. 0
  250. 1 {VALUE._col2} {VALUE._col3}
  251. handleSkewJoin: false
  252. outputColumnNames: _col8, _col9
  253. Select Operator
  254. expressions:
  255. expr: _col8
  256. type: string
  257. expr: _col9
  258. type: string
  259. outputColumnNames: _col0, _col1
  260. File Output Operator
  261. compressed: false
  262. GlobalTableId: 0
  263. table:
  264. input format: org.apache.hadoop.mapred.SequenceFileInputFormat
  265. output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
  266. Stage: Stage-2
  267. Map Reduce
  268. Alias -> Map Operator Tree:
  269. file:/tmp/sdong/hive_2011-02-10_17-01-27_356_3093621423795045358/-mr-10002
  270. Reduce Output Operator
  271. key expressions:
  272. expr: _col0
  273. type: string
  274. expr: _col1
  275. type: string
  276. sort order: ++
  277. tag: -1
  278. value expressions:
  279. expr: _col0
  280. type: string
  281. expr: _col1
  282. type: string
  283. Reduce Operator Tree:
  284. Extract
  285. File Output Operator
  286. compressed: false
  287. GlobalTableId: 0
  288. table:
  289. input format: org.apache.hadoop.mapred.TextInputFormat
  290. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  291. Stage: Stage-0
  292. Fetch Operator
  293. limit: -1
  294. PREHOOK: query: SELECT b.`..` FROM srcpart a JOIN srcpart b
  295. ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
  296. ORDER BY ds, hr
  297. PREHOOK: type: QUERY
  298. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  299. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  300. PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  301. PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  302. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-27_548_6653931489088427144/-mr-10000
  303. POSTHOOK: query: SELECT b.`..` FROM srcpart a JOIN srcpart b
  304. ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
  305. ORDER BY ds, hr
  306. POSTHOOK: type: QUERY
  307. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  308. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  309. POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  310. POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  311. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-27_548_6653931489088427144/-mr-10000
  312. 2008-04-08 11
  313. 2008-04-08 11
  314. 2008-04-08 11
  315. 2008-04-08 11
  316. 2008-04-08 12
  317. 2008-04-08 12
  318. 2008-04-08 12
  319. 2008-04-08 12
  320. 2008-04-09 11
  321. 2008-04-09 11
  322. 2008-04-09 11
  323. 2008-04-09 11
  324. 2008-04-09 12
  325. 2008-04-09 12
  326. 2008-04-09 12
  327. 2008-04-09 12
  328. PREHOOK: query: EXPLAIN
  329. SELECT `.e.` FROM srcpart
  330. PREHOOK: type: QUERY
  331. POSTHOOK: query: EXPLAIN
  332. SELECT `.e.` FROM srcpart
  333. POSTHOOK: type: QUERY
  334. ABSTRACT SYNTAX TREE:
  335. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `.e.`)))))
  336. STAGE DEPENDENCIES:
  337. Stage-1 is a root stage
  338. Stage-0 is a root stage
  339. STAGE PLANS:
  340. Stage: Stage-1
  341. Map Reduce
  342. Alias -> Map Operator Tree:
  343. srcpart
  344. TableScan
  345. alias: srcpart
  346. Select Operator
  347. expressions:
  348. expr: key
  349. type: string
  350. outputColumnNames: _col0
  351. File Output Operator
  352. compressed: false
  353. GlobalTableId: 0
  354. table:
  355. input format: org.apache.hadoop.mapred.TextInputFormat
  356. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  357. Stage: Stage-0
  358. Fetch Operator
  359. limit: -1
  360. PREHOOK: query: EXPLAIN
  361. SELECT `d.*` FROM srcpart
  362. PREHOOK: type: QUERY
  363. POSTHOOK: query: EXPLAIN
  364. SELECT `d.*` FROM srcpart
  365. POSTHOOK: type: QUERY
  366. ABSTRACT SYNTAX TREE:
  367. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `d.*`)))))
  368. STAGE DEPENDENCIES:
  369. Stage-1 is a root stage
  370. Stage-0 is a root stage
  371. STAGE PLANS:
  372. Stage: Stage-1
  373. Map Reduce
  374. Alias -> Map Operator Tree:
  375. srcpart
  376. TableScan
  377. alias: srcpart
  378. Select Operator
  379. expressions:
  380. expr: ds
  381. type: string
  382. outputColumnNames: _col0
  383. File Output Operator
  384. compressed: false
  385. GlobalTableId: 0
  386. table:
  387. input format: org.apache.hadoop.mapred.TextInputFormat
  388. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  389. Stage: Stage-0
  390. Fetch Operator
  391. limit: -1
  392. PREHOOK: query: EXPLAIN
  393. SELECT `(ds)?+.+` FROM srcpart
  394. PREHOOK: type: QUERY
  395. POSTHOOK: query: EXPLAIN
  396. SELECT `(ds)?+.+` FROM srcpart
  397. POSTHOOK: type: QUERY
  398. ABSTRACT SYNTAX TREE:
  399. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `(ds)?+.+`)))))
  400. STAGE DEPENDENCIES:
  401. Stage-1 is a root stage
  402. Stage-0 is a root stage
  403. STAGE PLANS:
  404. Stage: Stage-1
  405. Map Reduce
  406. Alias -> Map Operator Tree:
  407. srcpart
  408. TableScan
  409. alias: srcpart
  410. Select Operator
  411. expressions:
  412. expr: key
  413. type: string
  414. expr: value
  415. type: string
  416. expr: hr
  417. type: string
  418. outputColumnNames: _col0, _col1, _col2
  419. File Output Operator
  420. compressed: false
  421. GlobalTableId: 0
  422. table:
  423. input format: org.apache.hadoop.mapred.TextInputFormat
  424. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  425. Stage: Stage-0
  426. Fetch Operator
  427. limit: -1
  428. PREHOOK: query: EXPLAIN
  429. SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
  430. PREHOOK: type: QUERY
  431. POSTHOOK: query: EXPLAIN
  432. SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
  433. POSTHOOK: type: QUERY
  434. ABSTRACT SYNTAX TREE:
  435. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `(ds|hr)?+.+`))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))) (TOK_LIMIT 10)))
  436. STAGE DEPENDENCIES:
  437. Stage-1 is a root stage
  438. Stage-0 is a root stage
  439. STAGE PLANS:
  440. Stage: Stage-1
  441. Map Reduce
  442. Alias -> Map Operator Tree:
  443. srcpart
  444. TableScan
  445. alias: srcpart
  446. Select Operator
  447. expressions:
  448. expr: key
  449. type: string
  450. expr: value
  451. type: string
  452. outputColumnNames: _col0, _col1
  453. Reduce Output Operator
  454. key expressions:
  455. expr: _col0
  456. type: string
  457. expr: _col1
  458. type: string
  459. sort order: ++
  460. tag: -1
  461. value expressions:
  462. expr: _col0
  463. type: string
  464. expr: _col1
  465. type: string
  466. Reduce Operator Tree:
  467. Extract
  468. Limit
  469. File Output Operator
  470. compressed: false
  471. GlobalTableId: 0
  472. table:
  473. input format: org.apache.hadoop.mapred.TextInputFormat
  474. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  475. Stage: Stage-0
  476. Fetch Operator
  477. limit: 10
  478. PREHOOK: query: SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
  479. PREHOOK: type: QUERY
  480. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  481. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  482. PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  483. PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  484. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-35_406_5771693391982309464/-mr-10000
  485. POSTHOOK: query: SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
  486. POSTHOOK: type: QUERY
  487. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  488. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  489. POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  490. POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  491. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-35_406_5771693391982309464/-mr-10000
  492. 0 val_0
  493. 0 val_0
  494. 0 val_0
  495. 0 val_0
  496. 0 val_0
  497. 0 val_0
  498. 0 val_0
  499. 0 val_0
  500. 0 val_0
  501. 0 val_0