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

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

#
text | 790 lines | 779 code | 11 blank | 0 comment | 0 complexity | 74841d6850fd640660a63542cfc00e58 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, dt STRING, hr STRING) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING, dt STRING, hr STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest1
  6. PREHOOK: query: -- no input pruning, no sample filter
  7. EXPLAIN EXTENDED
  8. INSERT OVERWRITE TABLE dest1 SELECT s.*
  9. FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
  10. WHERE s.ds='2008-04-08' and s.hr='11'
  11. PREHOOK: type: QUERY
  12. POSTHOOK: query: -- no input pruning, no sample filter
  13. EXPLAIN EXTENDED
  14. INSERT OVERWRITE TABLE dest1 SELECT s.*
  15. FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
  16. WHERE s.ds='2008-04-08' and s.hr='11'
  17. POSTHOOK: type: QUERY
  18. ABSTRACT SYNTAX TREE:
  19. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) (TOK_TABLESAMPLE 1 1 (TOK_FUNCTION rand)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME s)))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL s) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL s) hr) '11')))))
  20. STAGE DEPENDENCIES:
  21. Stage-1 is a root stage
  22. Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
  23. Stage-4
  24. Stage-0 depends on stages: Stage-4, Stage-3
  25. Stage-2 depends on stages: Stage-0
  26. Stage-3
  27. STAGE PLANS:
  28. Stage: Stage-1
  29. Map Reduce
  30. Alias -> Map Operator Tree:
  31. s
  32. TableScan
  33. alias: s
  34. GatherStats: false
  35. Filter Operator
  36. isSamplingPred: true
  37. predicate:
  38. expr: (((hash(rand()) & 2147483647) % 1) = 0)
  39. type: boolean
  40. Filter Operator
  41. isSamplingPred: false
  42. predicate:
  43. expr: ((ds = '2008-04-08') and (hr = '11'))
  44. type: boolean
  45. Select Operator
  46. expressions:
  47. expr: key
  48. type: string
  49. expr: value
  50. type: string
  51. expr: ds
  52. type: string
  53. expr: hr
  54. type: string
  55. outputColumnNames: _col0, _col1, _col2, _col3
  56. Select Operator
  57. expressions:
  58. expr: UDFToInteger(_col0)
  59. type: int
  60. expr: _col1
  61. type: string
  62. expr: _col2
  63. type: string
  64. expr: _col3
  65. type: string
  66. outputColumnNames: _col0, _col1, _col2, _col3
  67. File Output Operator
  68. compressed: false
  69. GlobalTableId: 1
  70. directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002
  71. NumFilesPerFileSink: 1
  72. Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000/
  73. table:
  74. input format: org.apache.hadoop.mapred.TextInputFormat
  75. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  76. properties:
  77. bucket_count -1
  78. columns key,value,dt,hr
  79. columns.types int:string:string:string
  80. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  81. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  82. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
  83. name default.dest1
  84. serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
  85. serialization.format 1
  86. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  87. transient_lastDdlTime 1297386131
  88. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  89. name: default.dest1
  90. TotalFiles: 1
  91. GatherStats: true
  92. MultiFileSpray: false
  93. Needs Tagging: false
  94. Path -> Alias:
  95. pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [s]
  96. Path -> Partition:
  97. pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
  98. Partition
  99. base file name: hr=11
  100. input format: org.apache.hadoop.mapred.TextInputFormat
  101. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  102. partition values:
  103. ds 2008-04-08
  104. hr 11
  105. properties:
  106. bucket_count -1
  107. columns key,value
  108. columns.types string:string
  109. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  110. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  111. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
  112. name default.srcpart
  113. partition_columns ds/hr
  114. serialization.ddl struct srcpart { string key, string value}
  115. serialization.format 1
  116. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  117. transient_lastDdlTime 1297378962
  118. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  119. input format: org.apache.hadoop.mapred.TextInputFormat
  120. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  121. properties:
  122. bucket_count -1
  123. columns key,value
  124. columns.types string:string
  125. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  126. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  127. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
  128. name default.srcpart
  129. partition_columns ds/hr
  130. serialization.ddl struct srcpart { string key, string value}
  131. serialization.format 1
  132. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  133. transient_lastDdlTime 1297378962
  134. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  135. name: default.srcpart
  136. name: default.srcpart
  137. Stage: Stage-5
  138. Conditional Operator
  139. Stage: Stage-4
  140. Move Operator
  141. files:
  142. hdfs directory: true
  143. source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002
  144. destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000
  145. Stage: Stage-0
  146. Move Operator
  147. tables:
  148. replace: true
  149. source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000
  150. table:
  151. input format: org.apache.hadoop.mapred.TextInputFormat
  152. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  153. properties:
  154. bucket_count -1
  155. columns key,value,dt,hr
  156. columns.types int:string:string:string
  157. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  158. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  159. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
  160. name default.dest1
  161. serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
  162. serialization.format 1
  163. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  164. transient_lastDdlTime 1297386131
  165. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  166. name: default.dest1
  167. tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10001
  168. Stage: Stage-2
  169. Stats-Aggr Operator
  170. Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000/
  171. Stage: Stage-3
  172. Map Reduce
  173. Alias -> Map Operator Tree:
  174. pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002
  175. File Output Operator
  176. compressed: false
  177. GlobalTableId: 0
  178. directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000
  179. NumFilesPerFileSink: 1
  180. table:
  181. input format: org.apache.hadoop.mapred.TextInputFormat
  182. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  183. properties:
  184. bucket_count -1
  185. columns key,value,dt,hr
  186. columns.types int:string:string:string
  187. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  188. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  189. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
  190. name default.dest1
  191. serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
  192. serialization.format 1
  193. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  194. transient_lastDdlTime 1297386131
  195. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  196. name: default.dest1
  197. TotalFiles: 1
  198. GatherStats: false
  199. MultiFileSpray: false
  200. Needs Tagging: false
  201. Path -> Alias:
  202. pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002]
  203. Path -> Partition:
  204. pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002
  205. Partition
  206. base file name: -ext-10002
  207. input format: org.apache.hadoop.mapred.TextInputFormat
  208. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  209. properties:
  210. bucket_count -1
  211. columns key,value,dt,hr
  212. columns.types int:string:string:string
  213. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  214. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  215. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
  216. name default.dest1
  217. serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
  218. serialization.format 1
  219. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  220. transient_lastDdlTime 1297386131
  221. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  222. input format: org.apache.hadoop.mapred.TextInputFormat
  223. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  224. properties:
  225. bucket_count -1
  226. columns key,value,dt,hr
  227. columns.types int:string:string:string
  228. file.inputformat org.apache.hadoop.mapred.TextInputFormat
  229. file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  230. location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
  231. name default.dest1
  232. serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
  233. serialization.format 1
  234. serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  235. transient_lastDdlTime 1297386131
  236. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  237. name: default.dest1
  238. name: default.dest1
  239. PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
  240. FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
  241. WHERE s.ds='2008-04-08' and s.hr='11'
  242. PREHOOK: type: QUERY
  243. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  244. PREHOOK: Output: default@dest1
  245. POSTHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
  246. FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
  247. WHERE s.ds='2008-04-08' and s.hr='11'
  248. POSTHOOK: type: QUERY
  249. POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  250. POSTHOOK: Output: default@dest1
  251. POSTHOOK: Lineage: dest1.dt SIMPLE [(srcpart)s.FieldSchema(name:ds, type:string, comment:null), ]
  252. POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)s.FieldSchema(name:hr, type:string, comment:null), ]
  253. POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)s.FieldSchema(name:key, type:string, comment:default), ]
  254. POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)s.FieldSchema(name:value, type:string, comment:default), ]
  255. PREHOOK: query: SELECT dest1.* FROM dest1
  256. PREHOOK: type: QUERY
  257. PREHOOK: Input: default@dest1
  258. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_189_533486943106456838/-mr-10000
  259. POSTHOOK: query: SELECT dest1.* FROM dest1
  260. POSTHOOK: type: QUERY
  261. POSTHOOK: Input: default@dest1
  262. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_189_533486943106456838/-mr-10000
  263. POSTHOOK: Lineage: dest1.dt SIMPLE [(srcpart)s.FieldSchema(name:ds, type:string, comment:null), ]
  264. POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)s.FieldSchema(name:hr, type:string, comment:null), ]
  265. POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)s.FieldSchema(name:key, type:string, comment:default), ]
  266. POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)s.FieldSchema(name:value, type:string, comment:default), ]
  267. 238 val_238 2008-04-08 11
  268. 86 val_86 2008-04-08 11
  269. 311 val_311 2008-04-08 11
  270. 27 val_27 2008-04-08 11
  271. 165 val_165 2008-04-08 11
  272. 409 val_409 2008-04-08 11
  273. 255 val_255 2008-04-08 11
  274. 278 val_278 2008-04-08 11
  275. 98 val_98 2008-04-08 11
  276. 484 val_484 2008-04-08 11
  277. 265 val_265 2008-04-08 11
  278. 193 val_193 2008-04-08 11
  279. 401 val_401 2008-04-08 11
  280. 150 val_150 2008-04-08 11
  281. 273 val_273 2008-04-08 11
  282. 224 val_224 2008-04-08 11
  283. 369 val_369 2008-04-08 11
  284. 66 val_66 2008-04-08 11
  285. 128 val_128 2008-04-08 11
  286. 213 val_213 2008-04-08 11
  287. 146 val_146 2008-04-08 11
  288. 406 val_406 2008-04-08 11
  289. 429 val_429 2008-04-08 11
  290. 374 val_374 2008-04-08 11
  291. 152 val_152 2008-04-08 11
  292. 469 val_469 2008-04-08 11
  293. 145 val_145 2008-04-08 11
  294. 495 val_495 2008-04-08 11
  295. 37 val_37 2008-04-08 11
  296. 327 val_327 2008-04-08 11
  297. 281 val_281 2008-04-08 11
  298. 277 val_277 2008-04-08 11
  299. 209 val_209 2008-04-08 11
  300. 15 val_15 2008-04-08 11
  301. 82 val_82 2008-04-08 11
  302. 403 val_403 2008-04-08 11
  303. 166 val_166 2008-04-08 11
  304. 417 val_417 2008-04-08 11
  305. 430 val_430 2008-04-08 11
  306. 252 val_252 2008-04-08 11
  307. 292 val_292 2008-04-08 11
  308. 219 val_219 2008-04-08 11
  309. 287 val_287 2008-04-08 11
  310. 153 val_153 2008-04-08 11
  311. 193 val_193 2008-04-08 11
  312. 338 val_338 2008-04-08 11
  313. 446 val_446 2008-04-08 11
  314. 459 val_459 2008-04-08 11
  315. 394 val_394 2008-04-08 11
  316. 237 val_237 2008-04-08 11
  317. 482 val_482 2008-04-08 11
  318. 174 val_174 2008-04-08 11
  319. 413 val_413 2008-04-08 11
  320. 494 val_494 2008-04-08 11
  321. 207 val_207 2008-04-08 11
  322. 199 val_199 2008-04-08 11
  323. 466 val_466 2008-04-08 11
  324. 208 val_208 2008-04-08 11
  325. 174 val_174 2008-04-08 11
  326. 399 val_399 2008-04-08 11
  327. 396 val_396 2008-04-08 11
  328. 247 val_247 2008-04-08 11
  329. 417 val_417 2008-04-08 11
  330. 489 val_489 2008-04-08 11
  331. 162 val_162 2008-04-08 11
  332. 377 val_377 2008-04-08 11
  333. 397 val_397 2008-04-08 11
  334. 309 val_309 2008-04-08 11
  335. 365 val_365 2008-04-08 11
  336. 266 val_266 2008-04-08 11
  337. 439 val_439 2008-04-08 11
  338. 342 val_342 2008-04-08 11
  339. 367 val_367 2008-04-08 11
  340. 325 val_325 2008-04-08 11
  341. 167 val_167 2008-04-08 11
  342. 195 val_195 2008-04-08 11
  343. 475 val_475 2008-04-08 11
  344. 17 val_17 2008-04-08 11
  345. 113 val_113 2008-04-08 11
  346. 155 val_155 2008-04-08 11
  347. 203 val_203 2008-04-08 11
  348. 339 val_339 2008-04-08 11
  349. 0 val_0 2008-04-08 11
  350. 455 val_455 2008-04-08 11
  351. 128 val_128 2008-04-08 11
  352. 311 val_311 2008-04-08 11
  353. 316 val_316 2008-04-08 11
  354. 57 val_57 2008-04-08 11
  355. 302 val_302 2008-04-08 11
  356. 205 val_205 2008-04-08 11
  357. 149 val_149 2008-04-08 11
  358. 438 val_438 2008-04-08 11
  359. 345 val_345 2008-04-08 11
  360. 129 val_129 2008-04-08 11
  361. 170 val_170 2008-04-08 11
  362. 20 val_20 2008-04-08 11
  363. 489 val_489 2008-04-08 11
  364. 157 val_157 2008-04-08 11
  365. 378 val_378 2008-04-08 11
  366. 221 val_221 2008-04-08 11
  367. 92 val_92 2008-04-08 11
  368. 111 val_111 2008-04-08 11
  369. 47 val_47 2008-04-08 11
  370. 72 val_72 2008-04-08 11
  371. 4 val_4 2008-04-08 11
  372. 280 val_280 2008-04-08 11
  373. 35 val_35 2008-04-08 11
  374. 427 val_427 2008-04-08 11
  375. 277 val_277 2008-04-08 11
  376. 208 val_208 2008-04-08 11
  377. 356 val_356 2008-04-08 11
  378. 399 val_399 2008-04-08 11
  379. 169 val_169 2008-04-08 11
  380. 382 val_382 2008-04-08 11
  381. 498 val_498 2008-04-08 11
  382. 125 val_125 2008-04-08 11
  383. 386 val_386 2008-04-08 11
  384. 437 val_437 2008-04-08 11
  385. 469 val_469 2008-04-08 11
  386. 192 val_192 2008-04-08 11
  387. 286 val_286 2008-04-08 11
  388. 187 val_187 2008-04-08 11
  389. 176 val_176 2008-04-08 11
  390. 54 val_54 2008-04-08 11
  391. 459 val_459 2008-04-08 11
  392. 51 val_51 2008-04-08 11
  393. 138 val_138 2008-04-08 11
  394. 103 val_103 2008-04-08 11
  395. 239 val_239 2008-04-08 11
  396. 213 val_213 2008-04-08 11
  397. 216 val_216 2008-04-08 11
  398. 430 val_430 2008-04-08 11
  399. 278 val_278 2008-04-08 11
  400. 176 val_176 2008-04-08 11
  401. 289 val_289 2008-04-08 11
  402. 221 val_221 2008-04-08 11
  403. 65 val_65 2008-04-08 11
  404. 318 val_318 2008-04-08 11
  405. 332 val_332 2008-04-08 11
  406. 311 val_311 2008-04-08 11
  407. 275 val_275 2008-04-08 11
  408. 137 val_137 2008-04-08 11
  409. 241 val_241 2008-04-08 11
  410. 83 val_83 2008-04-08 11
  411. 333 val_333 2008-04-08 11
  412. 180 val_180 2008-04-08 11
  413. 284 val_284 2008-04-08 11
  414. 12 val_12 2008-04-08 11
  415. 230 val_230 2008-04-08 11
  416. 181 val_181 2008-04-08 11
  417. 67 val_67 2008-04-08 11
  418. 260 val_260 2008-04-08 11
  419. 404 val_404 2008-04-08 11
  420. 384 val_384 2008-04-08 11
  421. 489 val_489 2008-04-08 11
  422. 353 val_353 2008-04-08 11
  423. 373 val_373 2008-04-08 11
  424. 272 val_272 2008-04-08 11
  425. 138 val_138 2008-04-08 11
  426. 217 val_217 2008-04-08 11
  427. 84 val_84 2008-04-08 11
  428. 348 val_348 2008-04-08 11
  429. 466 val_466 2008-04-08 11
  430. 58 val_58 2008-04-08 11
  431. 8 val_8 2008-04-08 11
  432. 411 val_411 2008-04-08 11
  433. 230 val_230 2008-04-08 11
  434. 208 val_208 2008-04-08 11
  435. 348 val_348 2008-04-08 11
  436. 24 val_24 2008-04-08 11
  437. 463 val_463 2008-04-08 11
  438. 431 val_431 2008-04-08 11
  439. 179 val_179 2008-04-08 11
  440. 172 val_172 2008-04-08 11
  441. 42 val_42 2008-04-08 11
  442. 129 val_129 2008-04-08 11
  443. 158 val_158 2008-04-08 11
  444. 119 val_119 2008-04-08 11
  445. 496 val_496 2008-04-08 11
  446. 0 val_0 2008-04-08 11
  447. 322 val_322 2008-04-08 11
  448. 197 val_197 2008-04-08 11
  449. 468 val_468 2008-04-08 11
  450. 393 val_393 2008-04-08 11
  451. 454 val_454 2008-04-08 11
  452. 100 val_100 2008-04-08 11
  453. 298 val_298 2008-04-08 11
  454. 199 val_199 2008-04-08 11
  455. 191 val_191 2008-04-08 11
  456. 418 val_418 2008-04-08 11
  457. 96 val_96 2008-04-08 11
  458. 26 val_26 2008-04-08 11
  459. 165 val_165 2008-04-08 11
  460. 327 val_327 2008-04-08 11
  461. 230 val_230 2008-04-08 11
  462. 205 val_205 2008-04-08 11
  463. 120 val_120 2008-04-08 11
  464. 131 val_131 2008-04-08 11
  465. 51 val_51 2008-04-08 11
  466. 404 val_404 2008-04-08 11
  467. 43 val_43 2008-04-08 11
  468. 436 val_436 2008-04-08 11
  469. 156 val_156 2008-04-08 11
  470. 469 val_469 2008-04-08 11
  471. 468 val_468 2008-04-08 11
  472. 308 val_308 2008-04-08 11
  473. 95 val_95 2008-04-08 11
  474. 196 val_196 2008-04-08 11
  475. 288 val_288 2008-04-08 11
  476. 481 val_481 2008-04-08 11
  477. 457 val_457 2008-04-08 11
  478. 98 val_98 2008-04-08 11
  479. 282 val_282 2008-04-08 11
  480. 197 val_197 2008-04-08 11
  481. 187 val_187 2008-04-08 11
  482. 318 val_318 2008-04-08 11
  483. 318 val_318 2008-04-08 11
  484. 409 val_409 2008-04-08 11
  485. 470 val_470 2008-04-08 11
  486. 137 val_137 2008-04-08 11
  487. 369 val_369 2008-04-08 11
  488. 316 val_316 2008-04-08 11
  489. 169 val_169 2008-04-08 11
  490. 413 val_413 2008-04-08 11
  491. 85 val_85 2008-04-08 11
  492. 77 val_77 2008-04-08 11
  493. 0 val_0 2008-04-08 11
  494. 490 val_490 2008-04-08 11
  495. 87 val_87 2008-04-08 11
  496. 364 val_364 2008-04-08 11
  497. 179 val_179 2008-04-08 11
  498. 118 val_118 2008-04-08 11
  499. 134 val_134 2008-04-08 11
  500. 395 val_395 2008-04-08 11
  501. 282 val_282 2008-04-08 11
  502. 138 val_138 2008-04-08 11
  503. 238 val_238 2008-04-08 11
  504. 419 val_419 2008-04-08 11
  505. 15 val_15 2008-04-08 11
  506. 118 val_118 2008-04-08 11
  507. 72 val_72 2008-04-08 11
  508. 90 val_90 2008-04-08 11
  509. 307 val_307 2008-04-08 11
  510. 19 val_19 2008-04-08 11
  511. 435 val_435 2008-04-08 11
  512. 10 val_10 2008-04-08 11
  513. 277 val_277 2008-04-08 11
  514. 273 val_273 2008-04-08 11
  515. 306 val_306 2008-04-08 11
  516. 224 val_224 2008-04-08 11
  517. 309 val_309 2008-04-08 11
  518. 389 val_389 2008-04-08 11
  519. 327 val_327 2008-04-08 11
  520. 242 val_242 2008-04-08 11
  521. 369 val_369 2008-04-08 11
  522. 392 val_392 2008-04-08 11
  523. 272 val_272 2008-04-08 11
  524. 331 val_331 2008-04-08 11
  525. 401 val_401 2008-04-08 11
  526. 242 val_242 2008-04-08 11
  527. 452 val_452 2008-04-08 11
  528. 177 val_177 2008-04-08 11
  529. 226 val_226 2008-04-08 11
  530. 5 val_5 2008-04-08 11
  531. 497 val_497 2008-04-08 11
  532. 402 val_402 2008-04-08 11
  533. 396 val_396 2008-04-08 11
  534. 317 val_317 2008-04-08 11
  535. 395 val_395 2008-04-08 11
  536. 58 val_58 2008-04-08 11
  537. 35 val_35 2008-04-08 11
  538. 336 val_336 2008-04-08 11
  539. 95 val_95 2008-04-08 11
  540. 11 val_11 2008-04-08 11
  541. 168 val_168 2008-04-08 11
  542. 34 val_34 2008-04-08 11
  543. 229 val_229 2008-04-08 11
  544. 233 val_233 2008-04-08 11
  545. 143 val_143 2008-04-08 11
  546. 472 val_472 2008-04-08 11
  547. 322 val_322 2008-04-08 11
  548. 498 val_498 2008-04-08 11
  549. 160 val_160 2008-04-08 11
  550. 195 val_195 2008-04-08 11
  551. 42 val_42 2008-04-08 11
  552. 321 val_321 2008-04-08 11
  553. 430 val_430 2008-04-08 11
  554. 119 val_119 2008-04-08 11
  555. 489 val_489 2008-04-08 11
  556. 458 val_458 2008-04-08 11
  557. 78 val_78 2008-04-08 11
  558. 76 val_76 2008-04-08 11
  559. 41 val_41 2008-04-08 11
  560. 223 val_223 2008-04-08 11
  561. 492 val_492 2008-04-08 11
  562. 149 val_149 2008-04-08 11
  563. 449 val_449 2008-04-08 11
  564. 218 val_218 2008-04-08 11
  565. 228 val_228 2008-04-08 11
  566. 138 val_138 2008-04-08 11
  567. 453 val_453 2008-04-08 11
  568. 30 val_30 2008-04-08 11
  569. 209 val_209 2008-04-08 11
  570. 64 val_64 2008-04-08 11
  571. 468 val_468 2008-04-08 11
  572. 76 val_76 2008-04-08 11
  573. 74 val_74 2008-04-08 11
  574. 342 val_342 2008-04-08 11
  575. 69 val_69 2008-04-08 11
  576. 230 val_230 2008-04-08 11
  577. 33 val_33 2008-04-08 11
  578. 368 val_368 2008-04-08 11
  579. 103 val_103 2008-04-08 11
  580. 296 val_296 2008-04-08 11
  581. 113 val_113 2008-04-08 11
  582. 216 val_216 2008-04-08 11
  583. 367 val_367 2008-04-08 11
  584. 344 val_344 2008-04-08 11
  585. 167 val_167 2008-04-08 11
  586. 274 val_274 2008-04-08 11
  587. 219 val_219 2008-04-08 11
  588. 239 val_239 2008-04-08 11
  589. 485 val_485 2008-04-08 11
  590. 116 val_116 2008-04-08 11
  591. 223 val_223 2008-04-08 11
  592. 256 val_256 2008-04-08 11
  593. 263 val_263 2008-04-08 11
  594. 70 val_70 2008-04-08 11
  595. 487 val_487 2008-04-08 11
  596. 480 val_480 2008-04-08 11
  597. 401 val_401 2008-04-08 11
  598. 288 val_288 2008-04-08 11
  599. 191 val_191 2008-04-08 11
  600. 5 val_5 2008-04-08 11
  601. 244 val_244 2008-04-08 11
  602. 438 val_438 2008-04-08 11
  603. 128 val_128 2008-04-08 11
  604. 467 val_467 2008-04-08 11
  605. 432 val_432 2008-04-08 11
  606. 202 val_202 2008-04-08 11
  607. 316 val_316 2008-04-08 11
  608. 229 val_229 2008-04-08 11
  609. 469 val_469 2008-04-08 11
  610. 463 val_463 2008-04-08 11
  611. 280 val_280 2008-04-08 11
  612. 2 val_2 2008-04-08 11
  613. 35 val_35 2008-04-08 11
  614. 283 val_283 2008-04-08 11
  615. 331 val_331 2008-04-08 11
  616. 235 val_235 2008-04-08 11
  617. 80 val_80 2008-04-08 11
  618. 44 val_44 2008-04-08 11
  619. 193 val_193 2008-04-08 11
  620. 321 val_321 2008-04-08 11
  621. 335 val_335 2008-04-08 11
  622. 104 val_104 2008-04-08 11
  623. 466 val_466 2008-04-08 11
  624. 366 val_366 2008-04-08 11
  625. 175 val_175 2008-04-08 11
  626. 403 val_403 2008-04-08 11
  627. 483 val_483 2008-04-08 11
  628. 53 val_53 2008-04-08 11
  629. 105 val_105 2008-04-08 11
  630. 257 val_257 2008-04-08 11
  631. 406 val_406 2008-04-08 11
  632. 409 val_409 2008-04-08 11
  633. 190 val_190 2008-04-08 11
  634. 406 val_406 2008-04-08 11
  635. 401 val_401 2008-04-08 11
  636. 114 val_114 2008-04-08 11
  637. 258 val_258 2008-04-08 11
  638. 90 val_90 2008-04-08 11
  639. 203 val_203 2008-04-08 11
  640. 262 val_262 2008-04-08 11
  641. 348 val_348 2008-04-08 11
  642. 424 val_424 2008-04-08 11
  643. 12 val_12 2008-04-08 11
  644. 396 val_396 2008-04-08 11
  645. 201 val_201 2008-04-08 11
  646. 217 val_217 2008-04-08 11
  647. 164 val_164 2008-04-08 11
  648. 431 val_431 2008-04-08 11
  649. 454 val_454 2008-04-08 11
  650. 478 val_478 2008-04-08 11
  651. 298 val_298 2008-04-08 11
  652. 125 val_125 2008-04-08 11
  653. 431 val_431 2008-04-08 11
  654. 164 val_164 2008-04-08 11
  655. 424 val_424 2008-04-08 11
  656. 187 val_187 2008-04-08 11
  657. 382 val_382 2008-04-08 11
  658. 5 val_5 2008-04-08 11
  659. 70 val_70 2008-04-08 11
  660. 397 val_397 2008-04-08 11
  661. 480 val_480 2008-04-08 11
  662. 291 val_291 2008-04-08 11
  663. 24 val_24 2008-04-08 11
  664. 351 val_351 2008-04-08 11
  665. 255 val_255 2008-04-08 11
  666. 104 val_104 2008-04-08 11
  667. 70 val_70 2008-04-08 11
  668. 163 val_163 2008-04-08 11
  669. 438 val_438 2008-04-08 11
  670. 119 val_119 2008-04-08 11
  671. 414 val_414 2008-04-08 11
  672. 200 val_200 2008-04-08 11
  673. 491 val_491 2008-04-08 11
  674. 237 val_237 2008-04-08 11
  675. 439 val_439 2008-04-08 11
  676. 360 val_360 2008-04-08 11
  677. 248 val_248 2008-04-08 11
  678. 479 val_479 2008-04-08 11
  679. 305 val_305 2008-04-08 11
  680. 417 val_417 2008-04-08 11
  681. 199 val_199 2008-04-08 11
  682. 444 val_444 2008-04-08 11
  683. 120 val_120 2008-04-08 11
  684. 429 val_429 2008-04-08 11
  685. 169 val_169 2008-04-08 11
  686. 443 val_443 2008-04-08 11
  687. 323 val_323 2008-04-08 11
  688. 325 val_325 2008-04-08 11
  689. 277 val_277 2008-04-08 11
  690. 230 val_230 2008-04-08 11
  691. 478 val_478 2008-04-08 11
  692. 178 val_178 2008-04-08 11
  693. 468 val_468 2008-04-08 11
  694. 310 val_310 2008-04-08 11
  695. 317 val_317 2008-04-08 11
  696. 333 val_333 2008-04-08 11
  697. 493 val_493 2008-04-08 11
  698. 460 val_460 2008-04-08 11
  699. 207 val_207 2008-04-08 11
  700. 249 val_249 2008-04-08 11
  701. 265 val_265 2008-04-08 11
  702. 480 val_480 2008-04-08 11
  703. 83 val_83 2008-04-08 11
  704. 136 val_136 2008-04-08 11
  705. 353 val_353 2008-04-08 11
  706. 172 val_172 2008-04-08 11
  707. 214 val_214 2008-04-08 11
  708. 462 val_462 2008-04-08 11
  709. 233 val_233 2008-04-08 11
  710. 406 val_406 2008-04-08 11
  711. 133 val_133 2008-04-08 11
  712. 175 val_175 2008-04-08 11
  713. 189 val_189 2008-04-08 11
  714. 454 val_454 2008-04-08 11
  715. 375 val_375 2008-04-08 11
  716. 401 val_401 2008-04-08 11
  717. 421 val_421 2008-04-08 11
  718. 407 val_407 2008-04-08 11
  719. 384 val_384 2008-04-08 11
  720. 256 val_256 2008-04-08 11
  721. 26 val_26 2008-04-08 11
  722. 134 val_134 2008-04-08 11
  723. 67 val_67 2008-04-08 11
  724. 384 val_384 2008-04-08 11
  725. 379 val_379 2008-04-08 11
  726. 18 val_18 2008-04-08 11
  727. 462 val_462 2008-04-08 11
  728. 492 val_492 2008-04-08 11
  729. 100 val_100 2008-04-08 11
  730. 298 val_298 2008-04-08 11
  731. 9 val_9 2008-04-08 11
  732. 341 val_341 2008-04-08 11
  733. 498 val_498 2008-04-08 11
  734. 146 val_146 2008-04-08 11
  735. 458 val_458 2008-04-08 11
  736. 362 val_362 2008-04-08 11
  737. 186 val_186 2008-04-08 11
  738. 285 val_285 2008-04-08 11
  739. 348 val_348 2008-04-08 11
  740. 167 val_167 2008-04-08 11
  741. 18 val_18 2008-04-08 11
  742. 273 val_273 2008-04-08 11
  743. 183 val_183 2008-04-08 11
  744. 281 val_281 2008-04-08 11
  745. 344 val_344 2008-04-08 11
  746. 97 val_97 2008-04-08 11
  747. 469 val_469 2008-04-08 11
  748. 315 val_315 2008-04-08 11
  749. 84 val_84 2008-04-08 11
  750. 28 val_28 2008-04-08 11
  751. 37 val_37 2008-04-08 11
  752. 448 val_448 2008-04-08 11
  753. 152 val_152 2008-04-08 11
  754. 348 val_348 2008-04-08 11
  755. 307 val_307 2008-04-08 11
  756. 194 val_194 2008-04-08 11
  757. 414 val_414 2008-04-08 11
  758. 477 val_477 2008-04-08 11
  759. 222 val_222 2008-04-08 11
  760. 126 val_126 2008-04-08 11
  761. 90 val_90 2008-04-08 11
  762. 169 val_169 2008-04-08 11
  763. 403 val_403 2008-04-08 11
  764. 400 val_400 2008-04-08 11
  765. 200 val_200 2008-04-08 11
  766. 97 val_97 2008-04-08 11
  767. PREHOOK: query: select count(1) from srcbucket
  768. PREHOOK: type: QUERY
  769. PREHOOK: Input: default@srcbucket
  770. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_473_5957122419697785928/-mr-10000
  771. POSTHOOK: query: select count(1) from srcbucket
  772. POSTHOOK: type: QUERY
  773. POSTHOOK: Input: default@srcbucket
  774. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_473_5957122419697785928/-mr-10000
  775. POSTHOOK: Lineage: dest1.dt SIMPLE [(srcpart)s.FieldSchema(name:ds, type:string, comment:null), ]
  776. POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)s.FieldSchema(name:hr, type:string, comment:null), ]
  777. POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)s.FieldSchema(name:key, type:string, comment:default), ]
  778. POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)s.FieldSchema(name:value, type:string, comment:default), ]
  779. 1000