PageRenderTime 45ms CodeModel.GetById 13ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 1196 lines | 1191 code | 5 blank | 0 comment | 0 complexity | d50e83cba796dcebc7c11ef3ad266021 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: SHOW DATABASES
  2. PREHOOK: type: SHOWDATABASES
  3. POSTHOOK: query: SHOW DATABASES
  4. POSTHOOK: type: SHOWDATABASES
  5. default
  6. PREHOOK: query: -- CREATE with comment
  7. CREATE DATABASE test_db COMMENT 'Hive test database'
  8. PREHOOK: type: CREATEDATABASE
  9. POSTHOOK: query: -- CREATE with comment
  10. CREATE DATABASE test_db COMMENT 'Hive test database'
  11. POSTHOOK: type: CREATEDATABASE
  12. PREHOOK: query: SHOW DATABASES
  13. PREHOOK: type: SHOWDATABASES
  14. POSTHOOK: query: SHOW DATABASES
  15. POSTHOOK: type: SHOWDATABASES
  16. default
  17. test_db
  18. PREHOOK: query: -- CREATE INE already exists
  19. CREATE DATABASE IF NOT EXISTS test_db
  20. PREHOOK: type: CREATEDATABASE
  21. POSTHOOK: query: -- CREATE INE already exists
  22. CREATE DATABASE IF NOT EXISTS test_db
  23. POSTHOOK: type: CREATEDATABASE
  24. PREHOOK: query: SHOW DATABASES
  25. PREHOOK: type: SHOWDATABASES
  26. POSTHOOK: query: SHOW DATABASES
  27. POSTHOOK: type: SHOWDATABASES
  28. default
  29. test_db
  30. PREHOOK: query: -- SHOW DATABASES synonym
  31. SHOW SCHEMAS
  32. PREHOOK: type: SHOWDATABASES
  33. POSTHOOK: query: -- SHOW DATABASES synonym
  34. SHOW SCHEMAS
  35. POSTHOOK: type: SHOWDATABASES
  36. default
  37. test_db
  38. PREHOOK: query: -- DROP
  39. DROP DATABASE test_db
  40. PREHOOK: type: DROPDATABASE
  41. POSTHOOK: query: -- DROP
  42. DROP DATABASE test_db
  43. POSTHOOK: type: DROPDATABASE
  44. PREHOOK: query: SHOW DATABASES
  45. PREHOOK: type: SHOWDATABASES
  46. POSTHOOK: query: SHOW DATABASES
  47. POSTHOOK: type: SHOWDATABASES
  48. default
  49. PREHOOK: query: -- CREATE INE doesn't exist
  50. CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'
  51. PREHOOK: type: CREATEDATABASE
  52. POSTHOOK: query: -- CREATE INE doesn't exist
  53. CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'
  54. POSTHOOK: type: CREATEDATABASE
  55. PREHOOK: query: SHOW DATABASES
  56. PREHOOK: type: SHOWDATABASES
  57. POSTHOOK: query: SHOW DATABASES
  58. POSTHOOK: type: SHOWDATABASES
  59. default
  60. test_db
  61. PREHOOK: query: -- DROP IE exists
  62. DROP DATABASE IF EXISTS test_db
  63. PREHOOK: type: DROPDATABASE
  64. POSTHOOK: query: -- DROP IE exists
  65. DROP DATABASE IF EXISTS test_db
  66. POSTHOOK: type: DROPDATABASE
  67. PREHOOK: query: SHOW DATABASES
  68. PREHOOK: type: SHOWDATABASES
  69. POSTHOOK: query: SHOW DATABASES
  70. POSTHOOK: type: SHOWDATABASES
  71. default
  72. PREHOOK: query: -- DROP IE doesn't exist
  73. DROP DATABASE IF EXISTS test_db
  74. PREHOOK: type: DROPDATABASE
  75. POSTHOOK: query: -- DROP IE doesn't exist
  76. DROP DATABASE IF EXISTS test_db
  77. POSTHOOK: type: DROPDATABASE
  78. PREHOOK: query: -- SHOW
  79. CREATE DATABASE test_db
  80. PREHOOK: type: CREATEDATABASE
  81. POSTHOOK: query: -- SHOW
  82. CREATE DATABASE test_db
  83. POSTHOOK: type: CREATEDATABASE
  84. PREHOOK: query: SHOW DATABASES
  85. PREHOOK: type: SHOWDATABASES
  86. POSTHOOK: query: SHOW DATABASES
  87. POSTHOOK: type: SHOWDATABASES
  88. default
  89. test_db
  90. PREHOOK: query: -- SHOW pattern
  91. SHOW DATABASES LIKE 'test*'
  92. PREHOOK: type: SHOWDATABASES
  93. POSTHOOK: query: -- SHOW pattern
  94. SHOW DATABASES LIKE 'test*'
  95. POSTHOOK: type: SHOWDATABASES
  96. test_db
  97. PREHOOK: query: -- SHOW pattern
  98. SHOW DATABASES LIKE '*ef*'
  99. PREHOOK: type: SHOWDATABASES
  100. POSTHOOK: query: -- SHOW pattern
  101. SHOW DATABASES LIKE '*ef*'
  102. POSTHOOK: type: SHOWDATABASES
  103. default
  104. PREHOOK: query: USE test_db
  105. PREHOOK: type: SWITCHDATABASE
  106. POSTHOOK: query: USE test_db
  107. POSTHOOK: type: SWITCHDATABASE
  108. PREHOOK: query: SHOW DATABASES
  109. PREHOOK: type: SHOWDATABASES
  110. POSTHOOK: query: SHOW DATABASES
  111. POSTHOOK: type: SHOWDATABASES
  112. default
  113. test_db
  114. PREHOOK: query: -- CREATE table in non-default DB
  115. CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
  116. PREHOOK: type: CREATETABLE
  117. POSTHOOK: query: -- CREATE table in non-default DB
  118. CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
  119. POSTHOOK: type: CREATETABLE
  120. POSTHOOK: Output: test_db@test_table
  121. PREHOOK: query: SHOW TABLES
  122. PREHOOK: type: SHOWTABLES
  123. POSTHOOK: query: SHOW TABLES
  124. POSTHOOK: type: SHOWTABLES
  125. test_table
  126. PREHOOK: query: -- DESCRIBE table in non-default DB
  127. DESCRIBE test_table
  128. PREHOOK: type: DESCTABLE
  129. POSTHOOK: query: -- DESCRIBE table in non-default DB
  130. DESCRIBE test_table
  131. POSTHOOK: type: DESCTABLE
  132. col1 string
  133. PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
  134. DESCRIBE EXTENDED test_table
  135. PREHOOK: type: DESCTABLE
  136. POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
  137. DESCRIBE EXTENDED test_table
  138. POSTHOOK: type: DESCTABLE
  139. col1 string
  140. Detailed Table Information Table(tableName:test_table, dbName:test_db, owner:sdong, createTime:1297298647, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/test_db.db/test_table, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1297298647}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
  141. PREHOOK: query: -- CREATE LIKE in non-default DB
  142. CREATE TABLE test_table_like LIKE test_table
  143. PREHOOK: type: CREATETABLE
  144. POSTHOOK: query: -- CREATE LIKE in non-default DB
  145. CREATE TABLE test_table_like LIKE test_table
  146. POSTHOOK: type: CREATETABLE
  147. POSTHOOK: Output: test_db@test_table_like
  148. PREHOOK: query: SHOW TABLES
  149. PREHOOK: type: SHOWTABLES
  150. POSTHOOK: query: SHOW TABLES
  151. POSTHOOK: type: SHOWTABLES
  152. test_table
  153. test_table_like
  154. PREHOOK: query: DESCRIBE EXTENDED test_table_like
  155. PREHOOK: type: DESCTABLE
  156. POSTHOOK: query: DESCRIBE EXTENDED test_table_like
  157. POSTHOOK: type: DESCTABLE
  158. col1 string
  159. Detailed Table Information Table(tableName:test_table_like, dbName:test_db, owner:sdong, createTime:1297298647, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/test_db.db/test_table_like, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1297298647}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
  160. PREHOOK: query: -- LOAD and SELECT
  161. LOAD DATA LOCAL INPATH '../data/files/test.dat'
  162. OVERWRITE INTO TABLE test_table
  163. PREHOOK: type: LOAD
  164. POSTHOOK: query: -- LOAD and SELECT
  165. LOAD DATA LOCAL INPATH '../data/files/test.dat'
  166. OVERWRITE INTO TABLE test_table
  167. POSTHOOK: type: LOAD
  168. POSTHOOK: Output: test_db@test_table
  169. PREHOOK: query: SELECT * FROM test_table
  170. PREHOOK: type: QUERY
  171. PREHOOK: Input: test_db@test_table
  172. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-07_907_2220290854576269936/-mr-10000
  173. POSTHOOK: query: SELECT * FROM test_table
  174. POSTHOOK: type: QUERY
  175. POSTHOOK: Input: test_db@test_table
  176. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-07_907_2220290854576269936/-mr-10000
  177. 1
  178. 2
  179. 3
  180. 4
  181. 5
  182. 6
  183. PREHOOK: query: -- DROP and CREATE w/o LOAD
  184. DROP TABLE test_table
  185. PREHOOK: type: DROPTABLE
  186. PREHOOK: Input: test_db@test_table
  187. PREHOOK: Output: test_db@test_table
  188. POSTHOOK: query: -- DROP and CREATE w/o LOAD
  189. DROP TABLE test_table
  190. POSTHOOK: type: DROPTABLE
  191. POSTHOOK: Input: test_db@test_table
  192. POSTHOOK: Output: test_db@test_table
  193. PREHOOK: query: SHOW TABLES
  194. PREHOOK: type: SHOWTABLES
  195. POSTHOOK: query: SHOW TABLES
  196. POSTHOOK: type: SHOWTABLES
  197. test_table_like
  198. PREHOOK: query: CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
  199. PREHOOK: type: CREATETABLE
  200. POSTHOOK: query: CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
  201. POSTHOOK: type: CREATETABLE
  202. POSTHOOK: Output: test_db@test_table
  203. PREHOOK: query: SHOW TABLES
  204. PREHOOK: type: SHOWTABLES
  205. POSTHOOK: query: SHOW TABLES
  206. POSTHOOK: type: SHOWTABLES
  207. test_table
  208. test_table_like
  209. PREHOOK: query: SELECT * FROM test_table
  210. PREHOOK: type: QUERY
  211. PREHOOK: Input: test_db@test_table
  212. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_675_3749588003523508410/-mr-10000
  213. POSTHOOK: query: SELECT * FROM test_table
  214. POSTHOOK: type: QUERY
  215. POSTHOOK: Input: test_db@test_table
  216. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_675_3749588003523508410/-mr-10000
  217. PREHOOK: query: -- CREATE table that already exists in DEFAULT
  218. USE test_db
  219. PREHOOK: type: SWITCHDATABASE
  220. POSTHOOK: query: -- CREATE table that already exists in DEFAULT
  221. USE test_db
  222. POSTHOOK: type: SWITCHDATABASE
  223. PREHOOK: query: CREATE TABLE src (col1 STRING) STORED AS TEXTFILE
  224. PREHOOK: type: CREATETABLE
  225. POSTHOOK: query: CREATE TABLE src (col1 STRING) STORED AS TEXTFILE
  226. POSTHOOK: type: CREATETABLE
  227. POSTHOOK: Output: test_db@src
  228. PREHOOK: query: SHOW TABLES
  229. PREHOOK: type: SHOWTABLES
  230. POSTHOOK: query: SHOW TABLES
  231. POSTHOOK: type: SHOWTABLES
  232. src
  233. test_table
  234. test_table_like
  235. PREHOOK: query: SELECT * FROM src LIMIT 10
  236. PREHOOK: type: QUERY
  237. PREHOOK: Input: test_db@src
  238. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_940_1455309242143303234/-mr-10000
  239. POSTHOOK: query: SELECT * FROM src LIMIT 10
  240. POSTHOOK: type: QUERY
  241. POSTHOOK: Input: test_db@src
  242. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_940_1455309242143303234/-mr-10000
  243. PREHOOK: query: USE default
  244. PREHOOK: type: SWITCHDATABASE
  245. POSTHOOK: query: USE default
  246. POSTHOOK: type: SWITCHDATABASE
  247. PREHOOK: query: SELECT * FROM src LIMIT 10
  248. PREHOOK: type: QUERY
  249. PREHOOK: Input: default@src
  250. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-10_069_2353230500727487936/-mr-10000
  251. POSTHOOK: query: SELECT * FROM src LIMIT 10
  252. POSTHOOK: type: QUERY
  253. POSTHOOK: Input: default@src
  254. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-10_069_2353230500727487936/-mr-10000
  255. 238 val_238
  256. 86 val_86
  257. 311 val_311
  258. 27 val_27
  259. 165 val_165
  260. 409 val_409
  261. 255 val_255
  262. 278 val_278
  263. 98 val_98
  264. 484 val_484
  265. PREHOOK: query: -- DROP DATABASE
  266. USE test_db
  267. PREHOOK: type: SWITCHDATABASE
  268. POSTHOOK: query: -- DROP DATABASE
  269. USE test_db
  270. POSTHOOK: type: SWITCHDATABASE
  271. PREHOOK: query: DROP TABLE src
  272. PREHOOK: type: DROPTABLE
  273. PREHOOK: Input: test_db@src
  274. PREHOOK: Output: test_db@src
  275. POSTHOOK: query: DROP TABLE src
  276. POSTHOOK: type: DROPTABLE
  277. POSTHOOK: Input: test_db@src
  278. POSTHOOK: Output: test_db@src
  279. PREHOOK: query: DROP TABLE test_table
  280. PREHOOK: type: DROPTABLE
  281. PREHOOK: Input: test_db@test_table
  282. PREHOOK: Output: test_db@test_table
  283. POSTHOOK: query: DROP TABLE test_table
  284. POSTHOOK: type: DROPTABLE
  285. POSTHOOK: Input: test_db@test_table
  286. POSTHOOK: Output: test_db@test_table
  287. PREHOOK: query: DROP TABLE test_table_like
  288. PREHOOK: type: DROPTABLE
  289. PREHOOK: Input: test_db@test_table_like
  290. PREHOOK: Output: test_db@test_table_like
  291. POSTHOOK: query: DROP TABLE test_table_like
  292. POSTHOOK: type: DROPTABLE
  293. POSTHOOK: Input: test_db@test_table_like
  294. POSTHOOK: Output: test_db@test_table_like
  295. PREHOOK: query: SHOW TABLES
  296. PREHOOK: type: SHOWTABLES
  297. POSTHOOK: query: SHOW TABLES
  298. POSTHOOK: type: SHOWTABLES
  299. PREHOOK: query: USE default
  300. PREHOOK: type: SWITCHDATABASE
  301. POSTHOOK: query: USE default
  302. POSTHOOK: type: SWITCHDATABASE
  303. PREHOOK: query: DROP DATABASE test_db
  304. PREHOOK: type: DROPDATABASE
  305. POSTHOOK: query: DROP DATABASE test_db
  306. POSTHOOK: type: DROPDATABASE
  307. PREHOOK: query: SHOW DATABASES
  308. PREHOOK: type: SHOWDATABASES
  309. POSTHOOK: query: SHOW DATABASES
  310. POSTHOOK: type: SHOWDATABASES
  311. default
  312. PREHOOK: query: --
  313. -- Canonical Name Tests
  314. --
  315. CREATE DATABASE db1
  316. PREHOOK: type: CREATEDATABASE
  317. POSTHOOK: query: --
  318. -- Canonical Name Tests
  319. --
  320. CREATE DATABASE db1
  321. POSTHOOK: type: CREATEDATABASE
  322. PREHOOK: query: CREATE DATABASE db2
  323. PREHOOK: type: CREATEDATABASE
  324. POSTHOOK: query: CREATE DATABASE db2
  325. POSTHOOK: type: CREATEDATABASE
  326. PREHOOK: query: -- CREATE foreign table
  327. CREATE TABLE db1.src(key STRING, value STRING)
  328. STORED AS TEXTFILE
  329. PREHOOK: type: CREATETABLE
  330. POSTHOOK: query: -- CREATE foreign table
  331. CREATE TABLE db1.src(key STRING, value STRING)
  332. STORED AS TEXTFILE
  333. POSTHOOK: type: CREATETABLE
  334. POSTHOOK: Output: db1@src
  335. PREHOOK: query: -- LOAD into foreign table
  336. LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
  337. OVERWRITE INTO TABLE db1.src
  338. PREHOOK: type: LOAD
  339. POSTHOOK: query: -- LOAD into foreign table
  340. LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
  341. OVERWRITE INTO TABLE db1.src
  342. POSTHOOK: type: LOAD
  343. POSTHOOK: Output: db1@src
  344. PREHOOK: query: -- SELECT from foreign table
  345. SELECT * FROM db1.src
  346. PREHOOK: type: QUERY
  347. PREHOOK: Input: db1@src
  348. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-11_275_6905084904466384529/-mr-10000
  349. POSTHOOK: query: -- SELECT from foreign table
  350. SELECT * FROM db1.src
  351. POSTHOOK: type: QUERY
  352. POSTHOOK: Input: db1@src
  353. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-11_275_6905084904466384529/-mr-10000
  354. 238 val_238
  355. 86 val_86
  356. 311 val_311
  357. 27 val_27
  358. 165 val_165
  359. 409 val_409
  360. 255 val_255
  361. 278 val_278
  362. 98 val_98
  363. 484 val_484
  364. 265 val_265
  365. 193 val_193
  366. 401 val_401
  367. 150 val_150
  368. 273 val_273
  369. 224 val_224
  370. 369 val_369
  371. 66 val_66
  372. 128 val_128
  373. 213 val_213
  374. 146 val_146
  375. 406 val_406
  376. 429 val_429
  377. 374 val_374
  378. 152 val_152
  379. 469 val_469
  380. 145 val_145
  381. 495 val_495
  382. 37 val_37
  383. 327 val_327
  384. 281 val_281
  385. 277 val_277
  386. 209 val_209
  387. 15 val_15
  388. 82 val_82
  389. 403 val_403
  390. 166 val_166
  391. 417 val_417
  392. 430 val_430
  393. 252 val_252
  394. 292 val_292
  395. 219 val_219
  396. 287 val_287
  397. 153 val_153
  398. 193 val_193
  399. 338 val_338
  400. 446 val_446
  401. 459 val_459
  402. 394 val_394
  403. 237 val_237
  404. 482 val_482
  405. 174 val_174
  406. 413 val_413
  407. 494 val_494
  408. 207 val_207
  409. 199 val_199
  410. 466 val_466
  411. 208 val_208
  412. 174 val_174
  413. 399 val_399
  414. 396 val_396
  415. 247 val_247
  416. 417 val_417
  417. 489 val_489
  418. 162 val_162
  419. 377 val_377
  420. 397 val_397
  421. 309 val_309
  422. 365 val_365
  423. 266 val_266
  424. 439 val_439
  425. 342 val_342
  426. 367 val_367
  427. 325 val_325
  428. 167 val_167
  429. 195 val_195
  430. 475 val_475
  431. 17 val_17
  432. 113 val_113
  433. 155 val_155
  434. 203 val_203
  435. 339 val_339
  436. 0 val_0
  437. 455 val_455
  438. 128 val_128
  439. 311 val_311
  440. 316 val_316
  441. 57 val_57
  442. 302 val_302
  443. 205 val_205
  444. 149 val_149
  445. 438 val_438
  446. 345 val_345
  447. 129 val_129
  448. 170 val_170
  449. 20 val_20
  450. 489 val_489
  451. 157 val_157
  452. 378 val_378
  453. 221 val_221
  454. 92 val_92
  455. 111 val_111
  456. 47 val_47
  457. 72 val_72
  458. 4 val_4
  459. 280 val_280
  460. 35 val_35
  461. 427 val_427
  462. 277 val_277
  463. 208 val_208
  464. 356 val_356
  465. 399 val_399
  466. 169 val_169
  467. 382 val_382
  468. 498 val_498
  469. 125 val_125
  470. 386 val_386
  471. 437 val_437
  472. 469 val_469
  473. 192 val_192
  474. 286 val_286
  475. 187 val_187
  476. 176 val_176
  477. 54 val_54
  478. 459 val_459
  479. 51 val_51
  480. 138 val_138
  481. 103 val_103
  482. 239 val_239
  483. 213 val_213
  484. 216 val_216
  485. 430 val_430
  486. 278 val_278
  487. 176 val_176
  488. 289 val_289
  489. 221 val_221
  490. 65 val_65
  491. 318 val_318
  492. 332 val_332
  493. 311 val_311
  494. 275 val_275
  495. 137 val_137
  496. 241 val_241
  497. 83 val_83
  498. 333 val_333
  499. 180 val_180
  500. 284 val_284
  501. 12 val_12
  502. 230 val_230
  503. 181 val_181
  504. 67 val_67
  505. 260 val_260
  506. 404 val_404
  507. 384 val_384
  508. 489 val_489
  509. 353 val_353
  510. 373 val_373
  511. 272 val_272
  512. 138 val_138
  513. 217 val_217
  514. 84 val_84
  515. 348 val_348
  516. 466 val_466
  517. 58 val_58
  518. 8 val_8
  519. 411 val_411
  520. 230 val_230
  521. 208 val_208
  522. 348 val_348
  523. 24 val_24
  524. 463 val_463
  525. 431 val_431
  526. 179 val_179
  527. 172 val_172
  528. 42 val_42
  529. 129 val_129
  530. 158 val_158
  531. 119 val_119
  532. 496 val_496
  533. 0 val_0
  534. 322 val_322
  535. 197 val_197
  536. 468 val_468
  537. 393 val_393
  538. 454 val_454
  539. 100 val_100
  540. 298 val_298
  541. 199 val_199
  542. 191 val_191
  543. 418 val_418
  544. 96 val_96
  545. 26 val_26
  546. 165 val_165
  547. 327 val_327
  548. 230 val_230
  549. 205 val_205
  550. 120 val_120
  551. 131 val_131
  552. 51 val_51
  553. 404 val_404
  554. 43 val_43
  555. 436 val_436
  556. 156 val_156
  557. 469 val_469
  558. 468 val_468
  559. 308 val_308
  560. 95 val_95
  561. 196 val_196
  562. 288 val_288
  563. 481 val_481
  564. 457 val_457
  565. 98 val_98
  566. 282 val_282
  567. 197 val_197
  568. 187 val_187
  569. 318 val_318
  570. 318 val_318
  571. 409 val_409
  572. 470 val_470
  573. 137 val_137
  574. 369 val_369
  575. 316 val_316
  576. 169 val_169
  577. 413 val_413
  578. 85 val_85
  579. 77 val_77
  580. 0 val_0
  581. 490 val_490
  582. 87 val_87
  583. 364 val_364
  584. 179 val_179
  585. 118 val_118
  586. 134 val_134
  587. 395 val_395
  588. 282 val_282
  589. 138 val_138
  590. 238 val_238
  591. 419 val_419
  592. 15 val_15
  593. 118 val_118
  594. 72 val_72
  595. 90 val_90
  596. 307 val_307
  597. 19 val_19
  598. 435 val_435
  599. 10 val_10
  600. 277 val_277
  601. 273 val_273
  602. 306 val_306
  603. 224 val_224
  604. 309 val_309
  605. 389 val_389
  606. 327 val_327
  607. 242 val_242
  608. 369 val_369
  609. 392 val_392
  610. 272 val_272
  611. 331 val_331
  612. 401 val_401
  613. 242 val_242
  614. 452 val_452
  615. 177 val_177
  616. 226 val_226
  617. 5 val_5
  618. 497 val_497
  619. 402 val_402
  620. 396 val_396
  621. 317 val_317
  622. 395 val_395
  623. 58 val_58
  624. 35 val_35
  625. 336 val_336
  626. 95 val_95
  627. 11 val_11
  628. 168 val_168
  629. 34 val_34
  630. 229 val_229
  631. 233 val_233
  632. 143 val_143
  633. 472 val_472
  634. 322 val_322
  635. 498 val_498
  636. 160 val_160
  637. 195 val_195
  638. 42 val_42
  639. 321 val_321
  640. 430 val_430
  641. 119 val_119
  642. 489 val_489
  643. 458 val_458
  644. 78 val_78
  645. 76 val_76
  646. 41 val_41
  647. 223 val_223
  648. 492 val_492
  649. 149 val_149
  650. 449 val_449
  651. 218 val_218
  652. 228 val_228
  653. 138 val_138
  654. 453 val_453
  655. 30 val_30
  656. 209 val_209
  657. 64 val_64
  658. 468 val_468
  659. 76 val_76
  660. 74 val_74
  661. 342 val_342
  662. 69 val_69
  663. 230 val_230
  664. 33 val_33
  665. 368 val_368
  666. 103 val_103
  667. 296 val_296
  668. 113 val_113
  669. 216 val_216
  670. 367 val_367
  671. 344 val_344
  672. 167 val_167
  673. 274 val_274
  674. 219 val_219
  675. 239 val_239
  676. 485 val_485
  677. 116 val_116
  678. 223 val_223
  679. 256 val_256
  680. 263 val_263
  681. 70 val_70
  682. 487 val_487
  683. 480 val_480
  684. 401 val_401
  685. 288 val_288
  686. 191 val_191
  687. 5 val_5
  688. 244 val_244
  689. 438 val_438
  690. 128 val_128
  691. 467 val_467
  692. 432 val_432
  693. 202 val_202
  694. 316 val_316
  695. 229 val_229
  696. 469 val_469
  697. 463 val_463
  698. 280 val_280
  699. 2 val_2
  700. 35 val_35
  701. 283 val_283
  702. 331 val_331
  703. 235 val_235
  704. 80 val_80
  705. 44 val_44
  706. 193 val_193
  707. 321 val_321
  708. 335 val_335
  709. 104 val_104
  710. 466 val_466
  711. 366 val_366
  712. 175 val_175
  713. 403 val_403
  714. 483 val_483
  715. 53 val_53
  716. 105 val_105
  717. 257 val_257
  718. 406 val_406
  719. 409 val_409
  720. 190 val_190
  721. 406 val_406
  722. 401 val_401
  723. 114 val_114
  724. 258 val_258
  725. 90 val_90
  726. 203 val_203
  727. 262 val_262
  728. 348 val_348
  729. 424 val_424
  730. 12 val_12
  731. 396 val_396
  732. 201 val_201
  733. 217 val_217
  734. 164 val_164
  735. 431 val_431
  736. 454 val_454
  737. 478 val_478
  738. 298 val_298
  739. 125 val_125
  740. 431 val_431
  741. 164 val_164
  742. 424 val_424
  743. 187 val_187
  744. 382 val_382
  745. 5 val_5
  746. 70 val_70
  747. 397 val_397
  748. 480 val_480
  749. 291 val_291
  750. 24 val_24
  751. 351 val_351
  752. 255 val_255
  753. 104 val_104
  754. 70 val_70
  755. 163 val_163
  756. 438 val_438
  757. 119 val_119
  758. 414 val_414
  759. 200 val_200
  760. 491 val_491
  761. 237 val_237
  762. 439 val_439
  763. 360 val_360
  764. 248 val_248
  765. 479 val_479
  766. 305 val_305
  767. 417 val_417
  768. 199 val_199
  769. 444 val_444
  770. 120 val_120
  771. 429 val_429
  772. 169 val_169
  773. 443 val_443
  774. 323 val_323
  775. 325 val_325
  776. 277 val_277
  777. 230 val_230
  778. 478 val_478
  779. 178 val_178
  780. 468 val_468
  781. 310 val_310
  782. 317 val_317
  783. 333 val_333
  784. 493 val_493
  785. 460 val_460
  786. 207 val_207
  787. 249 val_249
  788. 265 val_265
  789. 480 val_480
  790. 83 val_83
  791. 136 val_136
  792. 353 val_353
  793. 172 val_172
  794. 214 val_214
  795. 462 val_462
  796. 233 val_233
  797. 406 val_406
  798. 133 val_133
  799. 175 val_175
  800. 189 val_189
  801. 454 val_454
  802. 375 val_375
  803. 401 val_401
  804. 421 val_421
  805. 407 val_407
  806. 384 val_384
  807. 256 val_256
  808. 26 val_26
  809. 134 val_134
  810. 67 val_67
  811. 384 val_384
  812. 379 val_379
  813. 18 val_18
  814. 462 val_462
  815. 492 val_492
  816. 100 val_100
  817. 298 val_298
  818. 9 val_9
  819. 341 val_341
  820. 498 val_498
  821. 146 val_146
  822. 458 val_458
  823. 362 val_362
  824. 186 val_186
  825. 285 val_285
  826. 348 val_348
  827. 167 val_167
  828. 18 val_18
  829. 273 val_273
  830. 183 val_183
  831. 281 val_281
  832. 344 val_344
  833. 97 val_97
  834. 469 val_469
  835. 315 val_315
  836. 84 val_84
  837. 28 val_28
  838. 37 val_37
  839. 448 val_448
  840. 152 val_152
  841. 348 val_348
  842. 307 val_307
  843. 194 val_194
  844. 414 val_414
  845. 477 val_477
  846. 222 val_222
  847. 126 val_126
  848. 90 val_90
  849. 169 val_169
  850. 403 val_403
  851. 400 val_400
  852. 200 val_200
  853. 97 val_97
  854. PREHOOK: query: -- CREATE Partitioned foreign table
  855. CREATE TABLE db1.srcpart(key STRING, value STRING)
  856. PARTITIONED BY (ds STRING, hr STRING)
  857. STORED AS TEXTFILE
  858. PREHOOK: type: CREATETABLE
  859. POSTHOOK: query: -- CREATE Partitioned foreign table
  860. CREATE TABLE db1.srcpart(key STRING, value STRING)
  861. PARTITIONED BY (ds STRING, hr STRING)
  862. STORED AS TEXTFILE
  863. POSTHOOK: type: CREATETABLE
  864. POSTHOOK: Output: db1@srcpart
  865. PREHOOK: query: -- LOAD data into Partitioned foreign table
  866. LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
  867. OVERWRITE INTO TABLE db1.srcpart
  868. PARTITION (ds='2008-04-08', hr='11')
  869. PREHOOK: type: LOAD
  870. POSTHOOK: query: -- LOAD data into Partitioned foreign table
  871. LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
  872. OVERWRITE INTO TABLE db1.srcpart
  873. PARTITION (ds='2008-04-08', hr='11')
  874. POSTHOOK: type: LOAD
  875. POSTHOOK: Output: db1@srcpart@ds=2008-04-08/hr=11
  876. PREHOOK: query: -- SELECT from Partitioned foreign table
  877. SELECT key, value FROM db1.srcpart
  878. WHERE key < 100 AND ds='2008-04-08' AND hr='11'
  879. PREHOOK: type: QUERY
  880. PREHOOK: Input: db1@srcpart@ds=2008-04-08/hr=11
  881. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-12_003_1615672453765172185/-mr-10000
  882. POSTHOOK: query: -- SELECT from Partitioned foreign table
  883. SELECT key, value FROM db1.srcpart
  884. WHERE key < 100 AND ds='2008-04-08' AND hr='11'
  885. POSTHOOK: type: QUERY
  886. POSTHOOK: Input: db1@srcpart@ds=2008-04-08/hr=11
  887. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-12_003_1615672453765172185/-mr-10000
  888. 86 val_86
  889. 27 val_27
  890. 98 val_98
  891. 66 val_66
  892. 37 val_37
  893. 15 val_15
  894. 82 val_82
  895. 17 val_17
  896. 0 val_0
  897. 57 val_57
  898. 20 val_20
  899. 92 val_92
  900. 47 val_47
  901. 72 val_72
  902. 4 val_4
  903. 35 val_35
  904. 54 val_54
  905. 51 val_51
  906. 65 val_65
  907. 83 val_83
  908. 12 val_12
  909. 67 val_67
  910. 84 val_84
  911. 58 val_58
  912. 8 val_8
  913. 24 val_24
  914. 42 val_42
  915. 0 val_0
  916. 96 val_96
  917. 26 val_26
  918. 51 val_51
  919. 43 val_43
  920. 95 val_95
  921. 98 val_98
  922. 85 val_85
  923. 77 val_77
  924. 0 val_0
  925. 87 val_87
  926. 15 val_15
  927. 72 val_72
  928. 90 val_90
  929. 19 val_19
  930. 10 val_10
  931. 5 val_5
  932. 58 val_58
  933. 35 val_35
  934. 95 val_95
  935. 11 val_11
  936. 34 val_34
  937. 42 val_42
  938. 78 val_78
  939. 76 val_76
  940. 41 val_41
  941. 30 val_30
  942. 64 val_64
  943. 76 val_76
  944. 74 val_74
  945. 69 val_69
  946. 33 val_33
  947. 70 val_70
  948. 5 val_5
  949. 2 val_2
  950. 35 val_35
  951. 80 val_80
  952. 44 val_44
  953. 53 val_53
  954. 90 val_90
  955. 12 val_12
  956. 5 val_5
  957. 70 val_70
  958. 24 val_24
  959. 70 val_70
  960. 83 val_83
  961. 26 val_26
  962. 67 val_67
  963. 18 val_18
  964. 9 val_9
  965. 18 val_18
  966. 97 val_97
  967. 84 val_84
  968. 28 val_28
  969. 37 val_37
  970. 90 val_90
  971. 97 val_97
  972. PREHOOK: query: -- SELECT JOINed product of two foreign tables
  973. USE db2
  974. PREHOOK: type: SWITCHDATABASE
  975. POSTHOOK: query: -- SELECT JOINed product of two foreign tables
  976. USE db2
  977. POSTHOOK: type: SWITCHDATABASE
  978. PREHOOK: query: SELECT a.* FROM db1.src a JOIN default.src1 b
  979. ON (a.key = b.key)
  980. PREHOOK: type: QUERY
  981. PREHOOK: Input: db1@src
  982. PREHOOK: Input: default@src1
  983. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-15_698_7511939016053492082/-mr-10000
  984. POSTHOOK: query: SELECT a.* FROM db1.src a JOIN default.src1 b
  985. ON (a.key = b.key)
  986. POSTHOOK: type: QUERY
  987. POSTHOOK: Input: db1@src
  988. POSTHOOK: Input: default@src1
  989. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-15_698_7511939016053492082/-mr-10000
  990. 128 val_128
  991. 128 val_128
  992. 128 val_128
  993. 146 val_146
  994. 146 val_146
  995. 150 val_150
  996. 213 val_213
  997. 213 val_213
  998. 224 val_224
  999. 224 val_224
  1000. 238 val_238
  1001. 238 val_238
  1002. 255 val_255
  1003. 255 val_255
  1004. 273 val_273
  1005. 273 val_273
  1006. 273 val_273
  1007. 278 val_278
  1008. 278 val_278
  1009. 311 val_311
  1010. 311 val_311
  1011. 311 val_311
  1012. 369 val_369
  1013. 369 val_369
  1014. 369 val_369
  1015. 401 val_401
  1016. 401 val_401
  1017. 401 val_401
  1018. 401 val_401
  1019. 401 val_401
  1020. 406 val_406
  1021. 406 val_406
  1022. 406 val_406
  1023. 406 val_406
  1024. 66 val_66
  1025. 98 val_98
  1026. 98 val_98
  1027. PREHOOK: query: -- CREATE TABLE AS SELECT from foreign table
  1028. CREATE TABLE conflict_name AS
  1029. SELECT value FROM default.src WHERE key = 66
  1030. PREHOOK: type: CREATETABLE_AS_SELECT
  1031. PREHOOK: Input: default@src
  1032. POSTHOOK: query: -- CREATE TABLE AS SELECT from foreign table
  1033. CREATE TABLE conflict_name AS
  1034. SELECT value FROM default.src WHERE key = 66
  1035. POSTHOOK: type: CREATETABLE_AS_SELECT
  1036. POSTHOOK: Input: default@src
  1037. POSTHOOK: Output: db2@conflict_name
  1038. PREHOOK: query: -- CREATE foreign table
  1039. CREATE TABLE db1.conflict_name AS
  1040. SELECT value FROM db1.src WHERE key = 8
  1041. PREHOOK: type: CREATETABLE_AS_SELECT
  1042. PREHOOK: Input: db1@src
  1043. POSTHOOK: query: -- CREATE foreign table
  1044. CREATE TABLE db1.conflict_name AS
  1045. SELECT value FROM db1.src WHERE key = 8
  1046. POSTHOOK: type: CREATETABLE_AS_SELECT
  1047. POSTHOOK: Input: db1@src
  1048. POSTHOOK: Output: db1@conflict_name
  1049. PREHOOK: query: -- query tables with the same names in different DBs
  1050. SELECT * FROM (
  1051. SELECT value FROM db1.conflict_name
  1052. UNION ALL
  1053. SELECT value FROM conflict_name
  1054. ) subq ORDER BY value
  1055. PREHOOK: type: QUERY
  1056. PREHOOK: Input: db1@conflict_name
  1057. PREHOOK: Input: db2@conflict_name
  1058. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-26_087_6460717989691096433/-mr-10000
  1059. POSTHOOK: query: -- query tables with the same names in different DBs
  1060. SELECT * FROM (
  1061. SELECT value FROM db1.conflict_name
  1062. UNION ALL
  1063. SELECT value FROM conflict_name
  1064. ) subq ORDER BY value
  1065. POSTHOOK: type: QUERY
  1066. POSTHOOK: Input: db1@conflict_name
  1067. POSTHOOK: Input: db2@conflict_name
  1068. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-26_087_6460717989691096433/-mr-10000
  1069. val_66
  1070. val_8
  1071. PREHOOK: query: USE default
  1072. PREHOOK: type: SWITCHDATABASE
  1073. POSTHOOK: query: USE default
  1074. POSTHOOK: type: SWITCHDATABASE
  1075. PREHOOK: query: SELECT * FROM (
  1076. SELECT value FROM db1.conflict_name
  1077. UNION ALL
  1078. SELECT value FROM db2.conflict_name
  1079. ) subq ORDER BY value
  1080. PREHOOK: type: QUERY
  1081. PREHOOK: Input: db1@conflict_name
  1082. PREHOOK: Input: db2@conflict_name
  1083. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-29_569_4760700604948844000/-mr-10000
  1084. POSTHOOK: query: SELECT * FROM (
  1085. SELECT value FROM db1.conflict_name
  1086. UNION ALL
  1087. SELECT value FROM db2.conflict_name
  1088. ) subq ORDER BY value
  1089. POSTHOOK: type: QUERY
  1090. POSTHOOK: Input: db1@conflict_name
  1091. POSTHOOK: Input: db2@conflict_name
  1092. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-29_569_4760700604948844000/-mr-10000
  1093. val_66
  1094. val_8
  1095. PREHOOK: query: -- TABLESAMPLES
  1096. CREATE TABLE bucketized_src (key INT, value STRING)
  1097. CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS
  1098. PREHOOK: type: CREATETABLE
  1099. POSTHOOK: query: -- TABLESAMPLES
  1100. CREATE TABLE bucketized_src (key INT, value STRING)
  1101. CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS
  1102. POSTHOOK: type: CREATETABLE
  1103. POSTHOOK: Output: default@bucketized_src
  1104. PREHOOK: query: INSERT OVERWRITE TABLE bucketized_src
  1105. SELECT key, value FROM src WHERE key=66
  1106. PREHOOK: type: QUERY
  1107. PREHOOK: Input: default@src
  1108. PREHOOK: Output: default@bucketized_src
  1109. POSTHOOK: query: INSERT OVERWRITE TABLE bucketized_src
  1110. SELECT key, value FROM src WHERE key=66
  1111. POSTHOOK: type: QUERY
  1112. POSTHOOK: Input: default@src
  1113. POSTHOOK: Output: default@bucketized_src
  1114. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1115. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1116. PREHOOK: query: SELECT key FROM bucketized_src TABLESAMPLE(BUCKET 1 out of 1)
  1117. PREHOOK: type: QUERY
  1118. PREHOOK: Input: default@bucketized_src
  1119. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-38_988_112069995278861989/-mr-10000
  1120. POSTHOOK: query: SELECT key FROM bucketized_src TABLESAMPLE(BUCKET 1 out of 1)
  1121. POSTHOOK: type: QUERY
  1122. POSTHOOK: Input: default@bucketized_src
  1123. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-38_988_112069995278861989/-mr-10000
  1124. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1125. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1126. 66
  1127. PREHOOK: query: -- CREATE TABLE LIKE
  1128. CREATE TABLE db2.src1 LIKE default.src
  1129. PREHOOK: type: CREATETABLE
  1130. POSTHOOK: query: -- CREATE TABLE LIKE
  1131. CREATE TABLE db2.src1 LIKE default.src
  1132. POSTHOOK: type: CREATETABLE
  1133. POSTHOOK: Output: db2@src1
  1134. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1135. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1136. PREHOOK: query: USE db2
  1137. PREHOOK: type: SWITCHDATABASE
  1138. POSTHOOK: query: USE db2
  1139. POSTHOOK: type: SWITCHDATABASE
  1140. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1141. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1142. PREHOOK: query: DESC EXTENDED src1
  1143. PREHOOK: type: DESCTABLE
  1144. POSTHOOK: query: DESC EXTENDED src1
  1145. POSTHOOK: type: DESCTABLE
  1146. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1147. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1148. key string default
  1149. value string default
  1150. Detailed Table Information Table(tableName:src1, dbName:db2, owner:null, createTime:1297298682, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/db2.db/src1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1297298682}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
  1151. PREHOOK: query: -- character escaping
  1152. SELECT key FROM `default`.src ORDER BY key LIMIT 1
  1153. PREHOOK: type: QUERY
  1154. PREHOOK: Input: default@src
  1155. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-42_440_145101011848594604/-mr-10000
  1156. POSTHOOK: query: -- character escaping
  1157. SELECT key FROM `default`.src ORDER BY key LIMIT 1
  1158. POSTHOOK: type: QUERY
  1159. POSTHOOK: Input: default@src
  1160. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-42_440_145101011848594604/-mr-10000
  1161. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1162. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1163. 0
  1164. PREHOOK: query: SELECT key FROM `default`.`src` ORDER BY key LIMIT 1
  1165. PREHOOK: type: QUERY
  1166. PREHOOK: Input: default@src
  1167. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-45_701_6560463601447490145/-mr-10000
  1168. POSTHOOK: query: SELECT key FROM `default`.`src` ORDER BY key LIMIT 1
  1169. POSTHOOK: type: QUERY
  1170. POSTHOOK: Input: default@src
  1171. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-45_701_6560463601447490145/-mr-10000
  1172. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1173. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1174. 0
  1175. PREHOOK: query: SELECT key FROM default.`src` ORDER BY key LIMIT 1
  1176. PREHOOK: type: QUERY
  1177. PREHOOK: Input: default@src
  1178. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-49_089_4523523986113613592/-mr-10000
  1179. POSTHOOK: query: SELECT key FROM default.`src` ORDER BY key LIMIT 1
  1180. POSTHOOK: type: QUERY
  1181. POSTHOOK: Input: default@src
  1182. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-49_089_4523523986113613592/-mr-10000
  1183. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1184. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  1185. 0
  1186. PREHOOK: query: USE default
  1187. PREHOOK: type: SWITCHDATABASE
  1188. POSTHOOK: query: USE default
  1189. POSTHOOK: type: SWITCHDATABASE
  1190. POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  1191. POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]