PageRenderTime 52ms CodeModel.GetById 18ms app.highlight 18ms RepoModel.GetById 2ms 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
   1PREHOOK: query: SHOW DATABASES
   2PREHOOK: type: SHOWDATABASES
   3POSTHOOK: query: SHOW DATABASES
   4POSTHOOK: type: SHOWDATABASES
   5default
   6PREHOOK: query: -- CREATE with comment
   7CREATE DATABASE test_db COMMENT 'Hive test database'
   8PREHOOK: type: CREATEDATABASE
   9POSTHOOK: query: -- CREATE with comment
  10CREATE DATABASE test_db COMMENT 'Hive test database'
  11POSTHOOK: type: CREATEDATABASE
  12PREHOOK: query: SHOW DATABASES
  13PREHOOK: type: SHOWDATABASES
  14POSTHOOK: query: SHOW DATABASES
  15POSTHOOK: type: SHOWDATABASES
  16default
  17test_db
  18PREHOOK: query: -- CREATE INE already exists
  19CREATE DATABASE IF NOT EXISTS test_db
  20PREHOOK: type: CREATEDATABASE
  21POSTHOOK: query: -- CREATE INE already exists
  22CREATE DATABASE IF NOT EXISTS test_db
  23POSTHOOK: type: CREATEDATABASE
  24PREHOOK: query: SHOW DATABASES
  25PREHOOK: type: SHOWDATABASES
  26POSTHOOK: query: SHOW DATABASES
  27POSTHOOK: type: SHOWDATABASES
  28default
  29test_db
  30PREHOOK: query: -- SHOW DATABASES synonym
  31SHOW SCHEMAS
  32PREHOOK: type: SHOWDATABASES
  33POSTHOOK: query: -- SHOW DATABASES synonym
  34SHOW SCHEMAS
  35POSTHOOK: type: SHOWDATABASES
  36default
  37test_db
  38PREHOOK: query: -- DROP
  39DROP DATABASE test_db
  40PREHOOK: type: DROPDATABASE
  41POSTHOOK: query: -- DROP
  42DROP DATABASE test_db
  43POSTHOOK: type: DROPDATABASE
  44PREHOOK: query: SHOW DATABASES
  45PREHOOK: type: SHOWDATABASES
  46POSTHOOK: query: SHOW DATABASES
  47POSTHOOK: type: SHOWDATABASES
  48default
  49PREHOOK: query: -- CREATE INE doesn't exist
  50CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'
  51PREHOOK: type: CREATEDATABASE
  52POSTHOOK: query: -- CREATE INE doesn't exist
  53CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'
  54POSTHOOK: type: CREATEDATABASE
  55PREHOOK: query: SHOW DATABASES
  56PREHOOK: type: SHOWDATABASES
  57POSTHOOK: query: SHOW DATABASES
  58POSTHOOK: type: SHOWDATABASES
  59default
  60test_db
  61PREHOOK: query: -- DROP IE exists
  62DROP DATABASE IF EXISTS test_db
  63PREHOOK: type: DROPDATABASE
  64POSTHOOK: query: -- DROP IE exists
  65DROP DATABASE IF EXISTS test_db
  66POSTHOOK: type: DROPDATABASE
  67PREHOOK: query: SHOW DATABASES
  68PREHOOK: type: SHOWDATABASES
  69POSTHOOK: query: SHOW DATABASES
  70POSTHOOK: type: SHOWDATABASES
  71default
  72PREHOOK: query: -- DROP IE doesn't exist
  73DROP DATABASE IF EXISTS test_db
  74PREHOOK: type: DROPDATABASE
  75POSTHOOK: query: -- DROP IE doesn't exist
  76DROP DATABASE IF EXISTS test_db
  77POSTHOOK: type: DROPDATABASE
  78PREHOOK: query: -- SHOW
  79CREATE DATABASE test_db
  80PREHOOK: type: CREATEDATABASE
  81POSTHOOK: query: -- SHOW
  82CREATE DATABASE test_db
  83POSTHOOK: type: CREATEDATABASE
  84PREHOOK: query: SHOW DATABASES
  85PREHOOK: type: SHOWDATABASES
  86POSTHOOK: query: SHOW DATABASES
  87POSTHOOK: type: SHOWDATABASES
  88default
  89test_db
  90PREHOOK: query: -- SHOW pattern
  91SHOW DATABASES LIKE 'test*'
  92PREHOOK: type: SHOWDATABASES
  93POSTHOOK: query: -- SHOW pattern
  94SHOW DATABASES LIKE 'test*'
  95POSTHOOK: type: SHOWDATABASES
  96test_db
  97PREHOOK: query: -- SHOW pattern
  98SHOW DATABASES LIKE '*ef*'
  99PREHOOK: type: SHOWDATABASES
 100POSTHOOK: query: -- SHOW pattern
 101SHOW DATABASES LIKE '*ef*'
 102POSTHOOK: type: SHOWDATABASES
 103default
 104PREHOOK: query: USE test_db
 105PREHOOK: type: SWITCHDATABASE
 106POSTHOOK: query: USE test_db
 107POSTHOOK: type: SWITCHDATABASE
 108PREHOOK: query: SHOW DATABASES
 109PREHOOK: type: SHOWDATABASES
 110POSTHOOK: query: SHOW DATABASES
 111POSTHOOK: type: SHOWDATABASES
 112default
 113test_db
 114PREHOOK: query: -- CREATE table in non-default DB
 115CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
 116PREHOOK: type: CREATETABLE
 117POSTHOOK: query: -- CREATE table in non-default DB
 118CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
 119POSTHOOK: type: CREATETABLE
 120POSTHOOK: Output: test_db@test_table
 121PREHOOK: query: SHOW TABLES
 122PREHOOK: type: SHOWTABLES
 123POSTHOOK: query: SHOW TABLES
 124POSTHOOK: type: SHOWTABLES
 125test_table
 126PREHOOK: query: -- DESCRIBE table in non-default DB
 127DESCRIBE test_table
 128PREHOOK: type: DESCTABLE
 129POSTHOOK: query: -- DESCRIBE table in non-default DB
 130DESCRIBE test_table
 131POSTHOOK: type: DESCTABLE
 132col1	string	
 133PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 134DESCRIBE EXTENDED test_table
 135PREHOOK: type: DESCTABLE
 136POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 137DESCRIBE EXTENDED test_table
 138POSTHOOK: type: DESCTABLE
 139col1	string	
 140	 	 
 141Detailed 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)	
 142PREHOOK: query: -- CREATE LIKE in non-default DB
 143CREATE TABLE test_table_like LIKE test_table
 144PREHOOK: type: CREATETABLE
 145POSTHOOK: query: -- CREATE LIKE in non-default DB
 146CREATE TABLE test_table_like LIKE test_table
 147POSTHOOK: type: CREATETABLE
 148POSTHOOK: Output: test_db@test_table_like
 149PREHOOK: query: SHOW TABLES
 150PREHOOK: type: SHOWTABLES
 151POSTHOOK: query: SHOW TABLES
 152POSTHOOK: type: SHOWTABLES
 153test_table
 154test_table_like
 155PREHOOK: query: DESCRIBE EXTENDED test_table_like
 156PREHOOK: type: DESCTABLE
 157POSTHOOK: query: DESCRIBE EXTENDED test_table_like
 158POSTHOOK: type: DESCTABLE
 159col1	string	
 160	 	 
 161Detailed 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)	
 162PREHOOK: query: -- LOAD and SELECT
 163LOAD DATA LOCAL INPATH '../data/files/test.dat'
 164OVERWRITE INTO TABLE test_table
 165PREHOOK: type: LOAD
 166POSTHOOK: query: -- LOAD and SELECT
 167LOAD DATA LOCAL INPATH '../data/files/test.dat'
 168OVERWRITE INTO TABLE test_table
 169POSTHOOK: type: LOAD
 170POSTHOOK: Output: test_db@test_table
 171PREHOOK: query: SELECT * FROM test_table
 172PREHOOK: type: QUERY
 173PREHOOK: Input: test_db@test_table
 174PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-07_907_2220290854576269936/-mr-10000
 175POSTHOOK: query: SELECT * FROM test_table
 176POSTHOOK: type: QUERY
 177POSTHOOK: Input: test_db@test_table
 178POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-07_907_2220290854576269936/-mr-10000
 1791
 1802
 1813
 1824
 1835
 1846
 185PREHOOK: query: -- DROP and CREATE w/o LOAD
 186DROP TABLE test_table
 187PREHOOK: type: DROPTABLE
 188PREHOOK: Input: test_db@test_table
 189PREHOOK: Output: test_db@test_table
 190POSTHOOK: query: -- DROP and CREATE w/o LOAD
 191DROP TABLE test_table
 192POSTHOOK: type: DROPTABLE
 193POSTHOOK: Input: test_db@test_table
 194POSTHOOK: Output: test_db@test_table
 195PREHOOK: query: SHOW TABLES
 196PREHOOK: type: SHOWTABLES
 197POSTHOOK: query: SHOW TABLES
 198POSTHOOK: type: SHOWTABLES
 199test_table_like
 200PREHOOK: query: CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
 201PREHOOK: type: CREATETABLE
 202POSTHOOK: query: CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
 203POSTHOOK: type: CREATETABLE
 204POSTHOOK: Output: test_db@test_table
 205PREHOOK: query: SHOW TABLES
 206PREHOOK: type: SHOWTABLES
 207POSTHOOK: query: SHOW TABLES
 208POSTHOOK: type: SHOWTABLES
 209test_table
 210test_table_like
 211PREHOOK: query: SELECT * FROM test_table
 212PREHOOK: type: QUERY
 213PREHOOK: Input: test_db@test_table
 214PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_675_3749588003523508410/-mr-10000
 215POSTHOOK: query: SELECT * FROM test_table
 216POSTHOOK: type: QUERY
 217POSTHOOK: Input: test_db@test_table
 218POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_675_3749588003523508410/-mr-10000
 219PREHOOK: query: -- CREATE table that already exists in DEFAULT
 220USE test_db
 221PREHOOK: type: SWITCHDATABASE
 222POSTHOOK: query: -- CREATE table that already exists in DEFAULT
 223USE test_db
 224POSTHOOK: type: SWITCHDATABASE
 225PREHOOK: query: CREATE TABLE src (col1 STRING) STORED AS TEXTFILE
 226PREHOOK: type: CREATETABLE
 227POSTHOOK: query: CREATE TABLE src (col1 STRING) STORED AS TEXTFILE
 228POSTHOOK: type: CREATETABLE
 229POSTHOOK: Output: test_db@src
 230PREHOOK: query: SHOW TABLES
 231PREHOOK: type: SHOWTABLES
 232POSTHOOK: query: SHOW TABLES
 233POSTHOOK: type: SHOWTABLES
 234src
 235test_table
 236test_table_like
 237PREHOOK: query: SELECT * FROM src LIMIT 10
 238PREHOOK: type: QUERY
 239PREHOOK: Input: test_db@src
 240PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_940_1455309242143303234/-mr-10000
 241POSTHOOK: query: SELECT * FROM src LIMIT 10
 242POSTHOOK: type: QUERY
 243POSTHOOK: Input: test_db@src
 244POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-09_940_1455309242143303234/-mr-10000
 245PREHOOK: query: USE default
 246PREHOOK: type: SWITCHDATABASE
 247POSTHOOK: query: USE default
 248POSTHOOK: type: SWITCHDATABASE
 249PREHOOK: query: SELECT * FROM src LIMIT 10
 250PREHOOK: type: QUERY
 251PREHOOK: Input: default@src
 252PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-10_069_2353230500727487936/-mr-10000
 253POSTHOOK: query: SELECT * FROM src LIMIT 10
 254POSTHOOK: type: QUERY
 255POSTHOOK: Input: default@src
 256POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-10_069_2353230500727487936/-mr-10000
 257238	val_238
 25886	val_86
 259311	val_311
 26027	val_27
 261165	val_165
 262409	val_409
 263255	val_255
 264278	val_278
 26598	val_98
 266484	val_484
 267PREHOOK: query: -- DROP DATABASE
 268USE test_db
 269PREHOOK: type: SWITCHDATABASE
 270POSTHOOK: query: -- DROP DATABASE
 271USE test_db
 272POSTHOOK: type: SWITCHDATABASE
 273PREHOOK: query: DROP TABLE src
 274PREHOOK: type: DROPTABLE
 275PREHOOK: Input: test_db@src
 276PREHOOK: Output: test_db@src
 277POSTHOOK: query: DROP TABLE src
 278POSTHOOK: type: DROPTABLE
 279POSTHOOK: Input: test_db@src
 280POSTHOOK: Output: test_db@src
 281PREHOOK: query: DROP TABLE test_table
 282PREHOOK: type: DROPTABLE
 283PREHOOK: Input: test_db@test_table
 284PREHOOK: Output: test_db@test_table
 285POSTHOOK: query: DROP TABLE test_table
 286POSTHOOK: type: DROPTABLE
 287POSTHOOK: Input: test_db@test_table
 288POSTHOOK: Output: test_db@test_table
 289PREHOOK: query: DROP TABLE test_table_like
 290PREHOOK: type: DROPTABLE
 291PREHOOK: Input: test_db@test_table_like
 292PREHOOK: Output: test_db@test_table_like
 293POSTHOOK: query: DROP TABLE test_table_like
 294POSTHOOK: type: DROPTABLE
 295POSTHOOK: Input: test_db@test_table_like
 296POSTHOOK: Output: test_db@test_table_like
 297PREHOOK: query: SHOW TABLES
 298PREHOOK: type: SHOWTABLES
 299POSTHOOK: query: SHOW TABLES
 300POSTHOOK: type: SHOWTABLES
 301PREHOOK: query: USE default
 302PREHOOK: type: SWITCHDATABASE
 303POSTHOOK: query: USE default
 304POSTHOOK: type: SWITCHDATABASE
 305PREHOOK: query: DROP DATABASE test_db
 306PREHOOK: type: DROPDATABASE
 307POSTHOOK: query: DROP DATABASE test_db
 308POSTHOOK: type: DROPDATABASE
 309PREHOOK: query: SHOW DATABASES
 310PREHOOK: type: SHOWDATABASES
 311POSTHOOK: query: SHOW DATABASES
 312POSTHOOK: type: SHOWDATABASES
 313default
 314PREHOOK: query: --
 315-- Canonical Name Tests
 316--
 317
 318CREATE DATABASE db1
 319PREHOOK: type: CREATEDATABASE
 320POSTHOOK: query: --
 321-- Canonical Name Tests
 322--
 323
 324CREATE DATABASE db1
 325POSTHOOK: type: CREATEDATABASE
 326PREHOOK: query: CREATE DATABASE db2
 327PREHOOK: type: CREATEDATABASE
 328POSTHOOK: query: CREATE DATABASE db2
 329POSTHOOK: type: CREATEDATABASE
 330PREHOOK: query: -- CREATE foreign table
 331CREATE TABLE db1.src(key STRING, value STRING)
 332STORED AS TEXTFILE
 333PREHOOK: type: CREATETABLE
 334POSTHOOK: query: -- CREATE foreign table
 335CREATE TABLE db1.src(key STRING, value STRING)
 336STORED AS TEXTFILE
 337POSTHOOK: type: CREATETABLE
 338POSTHOOK: Output: db1@src
 339PREHOOK: query: -- LOAD into foreign table
 340LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
 341OVERWRITE INTO TABLE db1.src
 342PREHOOK: type: LOAD
 343POSTHOOK: query: -- LOAD into foreign table
 344LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
 345OVERWRITE INTO TABLE db1.src
 346POSTHOOK: type: LOAD
 347POSTHOOK: Output: db1@src
 348PREHOOK: query: -- SELECT from foreign table
 349SELECT * FROM db1.src
 350PREHOOK: type: QUERY
 351PREHOOK: Input: db1@src
 352PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-11_275_6905084904466384529/-mr-10000
 353POSTHOOK: query: -- SELECT from foreign table
 354SELECT * FROM db1.src
 355POSTHOOK: type: QUERY
 356POSTHOOK: Input: db1@src
 357POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-11_275_6905084904466384529/-mr-10000
 358238	val_238
 35986	val_86
 360311	val_311
 36127	val_27
 362165	val_165
 363409	val_409
 364255	val_255
 365278	val_278
 36698	val_98
 367484	val_484
 368265	val_265
 369193	val_193
 370401	val_401
 371150	val_150
 372273	val_273
 373224	val_224
 374369	val_369
 37566	val_66
 376128	val_128
 377213	val_213
 378146	val_146
 379406	val_406
 380429	val_429
 381374	val_374
 382152	val_152
 383469	val_469
 384145	val_145
 385495	val_495
 38637	val_37
 387327	val_327
 388281	val_281
 389277	val_277
 390209	val_209
 39115	val_15
 39282	val_82
 393403	val_403
 394166	val_166
 395417	val_417
 396430	val_430
 397252	val_252
 398292	val_292
 399219	val_219
 400287	val_287
 401153	val_153
 402193	val_193
 403338	val_338
 404446	val_446
 405459	val_459
 406394	val_394
 407237	val_237
 408482	val_482
 409174	val_174
 410413	val_413
 411494	val_494
 412207	val_207
 413199	val_199
 414466	val_466
 415208	val_208
 416174	val_174
 417399	val_399
 418396	val_396
 419247	val_247
 420417	val_417
 421489	val_489
 422162	val_162
 423377	val_377
 424397	val_397
 425309	val_309
 426365	val_365
 427266	val_266
 428439	val_439
 429342	val_342
 430367	val_367
 431325	val_325
 432167	val_167
 433195	val_195
 434475	val_475
 43517	val_17
 436113	val_113
 437155	val_155
 438203	val_203
 439339	val_339
 4400	val_0
 441455	val_455
 442128	val_128
 443311	val_311
 444316	val_316
 44557	val_57
 446302	val_302
 447205	val_205
 448149	val_149
 449438	val_438
 450345	val_345
 451129	val_129
 452170	val_170
 45320	val_20
 454489	val_489
 455157	val_157
 456378	val_378
 457221	val_221
 45892	val_92
 459111	val_111
 46047	val_47
 46172	val_72
 4624	val_4
 463280	val_280
 46435	val_35
 465427	val_427
 466277	val_277
 467208	val_208
 468356	val_356
 469399	val_399
 470169	val_169
 471382	val_382
 472498	val_498
 473125	val_125
 474386	val_386
 475437	val_437
 476469	val_469
 477192	val_192
 478286	val_286
 479187	val_187
 480176	val_176
 48154	val_54
 482459	val_459
 48351	val_51
 484138	val_138
 485103	val_103
 486239	val_239
 487213	val_213
 488216	val_216
 489430	val_430
 490278	val_278
 491176	val_176
 492289	val_289
 493221	val_221
 49465	val_65
 495318	val_318
 496332	val_332
 497311	val_311
 498275	val_275
 499137	val_137
 500241	val_241
 50183	val_83
 502333	val_333
 503180	val_180
 504284	val_284
 50512	val_12
 506230	val_230
 507181	val_181
 50867	val_67
 509260	val_260
 510404	val_404
 511384	val_384
 512489	val_489
 513353	val_353
 514373	val_373
 515272	val_272
 516138	val_138
 517217	val_217
 51884	val_84
 519348	val_348
 520466	val_466
 52158	val_58
 5228	val_8
 523411	val_411
 524230	val_230
 525208	val_208
 526348	val_348
 52724	val_24
 528463	val_463
 529431	val_431
 530179	val_179
 531172	val_172
 53242	val_42
 533129	val_129
 534158	val_158
 535119	val_119
 536496	val_496
 5370	val_0
 538322	val_322
 539197	val_197
 540468	val_468
 541393	val_393
 542454	val_454
 543100	val_100
 544298	val_298
 545199	val_199
 546191	val_191
 547418	val_418
 54896	val_96
 54926	val_26
 550165	val_165
 551327	val_327
 552230	val_230
 553205	val_205
 554120	val_120
 555131	val_131
 55651	val_51
 557404	val_404
 55843	val_43
 559436	val_436
 560156	val_156
 561469	val_469
 562468	val_468
 563308	val_308
 56495	val_95
 565196	val_196
 566288	val_288
 567481	val_481
 568457	val_457
 56998	val_98
 570282	val_282
 571197	val_197
 572187	val_187
 573318	val_318
 574318	val_318
 575409	val_409
 576470	val_470
 577137	val_137
 578369	val_369
 579316	val_316
 580169	val_169
 581413	val_413
 58285	val_85
 58377	val_77
 5840	val_0
 585490	val_490
 58687	val_87
 587364	val_364
 588179	val_179
 589118	val_118
 590134	val_134
 591395	val_395
 592282	val_282
 593138	val_138
 594238	val_238
 595419	val_419
 59615	val_15
 597118	val_118
 59872	val_72
 59990	val_90
 600307	val_307
 60119	val_19
 602435	val_435
 60310	val_10
 604277	val_277
 605273	val_273
 606306	val_306
 607224	val_224
 608309	val_309
 609389	val_389
 610327	val_327
 611242	val_242
 612369	val_369
 613392	val_392
 614272	val_272
 615331	val_331
 616401	val_401
 617242	val_242
 618452	val_452
 619177	val_177
 620226	val_226
 6215	val_5
 622497	val_497
 623402	val_402
 624396	val_396
 625317	val_317
 626395	val_395
 62758	val_58
 62835	val_35
 629336	val_336
 63095	val_95
 63111	val_11
 632168	val_168
 63334	val_34
 634229	val_229
 635233	val_233
 636143	val_143
 637472	val_472
 638322	val_322
 639498	val_498
 640160	val_160
 641195	val_195
 64242	val_42
 643321	val_321
 644430	val_430
 645119	val_119
 646489	val_489
 647458	val_458
 64878	val_78
 64976	val_76
 65041	val_41
 651223	val_223
 652492	val_492
 653149	val_149
 654449	val_449
 655218	val_218
 656228	val_228
 657138	val_138
 658453	val_453
 65930	val_30
 660209	val_209
 66164	val_64
 662468	val_468
 66376	val_76
 66474	val_74
 665342	val_342
 66669	val_69
 667230	val_230
 66833	val_33
 669368	val_368
 670103	val_103
 671296	val_296
 672113	val_113
 673216	val_216
 674367	val_367
 675344	val_344
 676167	val_167
 677274	val_274
 678219	val_219
 679239	val_239
 680485	val_485
 681116	val_116
 682223	val_223
 683256	val_256
 684263	val_263
 68570	val_70
 686487	val_487
 687480	val_480
 688401	val_401
 689288	val_288
 690191	val_191
 6915	val_5
 692244	val_244
 693438	val_438
 694128	val_128
 695467	val_467
 696432	val_432
 697202	val_202
 698316	val_316
 699229	val_229
 700469	val_469
 701463	val_463
 702280	val_280
 7032	val_2
 70435	val_35
 705283	val_283
 706331	val_331
 707235	val_235
 70880	val_80
 70944	val_44
 710193	val_193
 711321	val_321
 712335	val_335
 713104	val_104
 714466	val_466
 715366	val_366
 716175	val_175
 717403	val_403
 718483	val_483
 71953	val_53
 720105	val_105
 721257	val_257
 722406	val_406
 723409	val_409
 724190	val_190
 725406	val_406
 726401	val_401
 727114	val_114
 728258	val_258
 72990	val_90
 730203	val_203
 731262	val_262
 732348	val_348
 733424	val_424
 73412	val_12
 735396	val_396
 736201	val_201
 737217	val_217
 738164	val_164
 739431	val_431
 740454	val_454
 741478	val_478
 742298	val_298
 743125	val_125
 744431	val_431
 745164	val_164
 746424	val_424
 747187	val_187
 748382	val_382
 7495	val_5
 75070	val_70
 751397	val_397
 752480	val_480
 753291	val_291
 75424	val_24
 755351	val_351
 756255	val_255
 757104	val_104
 75870	val_70
 759163	val_163
 760438	val_438
 761119	val_119
 762414	val_414
 763200	val_200
 764491	val_491
 765237	val_237
 766439	val_439
 767360	val_360
 768248	val_248
 769479	val_479
 770305	val_305
 771417	val_417
 772199	val_199
 773444	val_444
 774120	val_120
 775429	val_429
 776169	val_169
 777443	val_443
 778323	val_323
 779325	val_325
 780277	val_277
 781230	val_230
 782478	val_478
 783178	val_178
 784468	val_468
 785310	val_310
 786317	val_317
 787333	val_333
 788493	val_493
 789460	val_460
 790207	val_207
 791249	val_249
 792265	val_265
 793480	val_480
 79483	val_83
 795136	val_136
 796353	val_353
 797172	val_172
 798214	val_214
 799462	val_462
 800233	val_233
 801406	val_406
 802133	val_133
 803175	val_175
 804189	val_189
 805454	val_454
 806375	val_375
 807401	val_401
 808421	val_421
 809407	val_407
 810384	val_384
 811256	val_256
 81226	val_26
 813134	val_134
 81467	val_67
 815384	val_384
 816379	val_379
 81718	val_18
 818462	val_462
 819492	val_492
 820100	val_100
 821298	val_298
 8229	val_9
 823341	val_341
 824498	val_498
 825146	val_146
 826458	val_458
 827362	val_362
 828186	val_186
 829285	val_285
 830348	val_348
 831167	val_167
 83218	val_18
 833273	val_273
 834183	val_183
 835281	val_281
 836344	val_344
 83797	val_97
 838469	val_469
 839315	val_315
 84084	val_84
 84128	val_28
 84237	val_37
 843448	val_448
 844152	val_152
 845348	val_348
 846307	val_307
 847194	val_194
 848414	val_414
 849477	val_477
 850222	val_222
 851126	val_126
 85290	val_90
 853169	val_169
 854403	val_403
 855400	val_400
 856200	val_200
 85797	val_97
 858PREHOOK: query: -- CREATE Partitioned foreign table
 859CREATE TABLE db1.srcpart(key STRING, value STRING)
 860PARTITIONED BY (ds STRING, hr STRING)
 861STORED AS TEXTFILE
 862PREHOOK: type: CREATETABLE
 863POSTHOOK: query: -- CREATE Partitioned foreign table
 864CREATE TABLE db1.srcpart(key STRING, value STRING)
 865PARTITIONED BY (ds STRING, hr STRING)
 866STORED AS TEXTFILE
 867POSTHOOK: type: CREATETABLE
 868POSTHOOK: Output: db1@srcpart
 869PREHOOK: query: -- LOAD data into Partitioned foreign table
 870LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
 871OVERWRITE INTO TABLE db1.srcpart
 872PARTITION (ds='2008-04-08', hr='11')
 873PREHOOK: type: LOAD
 874POSTHOOK: query: -- LOAD data into Partitioned foreign table
 875LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
 876OVERWRITE INTO TABLE db1.srcpart
 877PARTITION (ds='2008-04-08', hr='11')
 878POSTHOOK: type: LOAD
 879POSTHOOK: Output: db1@srcpart@ds=2008-04-08/hr=11
 880PREHOOK: query: -- SELECT from Partitioned foreign table
 881SELECT key, value FROM db1.srcpart
 882WHERE key < 100 AND ds='2008-04-08' AND hr='11'
 883PREHOOK: type: QUERY
 884PREHOOK: Input: db1@srcpart@ds=2008-04-08/hr=11
 885PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-12_003_1615672453765172185/-mr-10000
 886POSTHOOK: query: -- SELECT from Partitioned foreign table
 887SELECT key, value FROM db1.srcpart
 888WHERE key < 100 AND ds='2008-04-08' AND hr='11'
 889POSTHOOK: type: QUERY
 890POSTHOOK: Input: db1@srcpart@ds=2008-04-08/hr=11
 891POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-12_003_1615672453765172185/-mr-10000
 89286	val_86
 89327	val_27
 89498	val_98
 89566	val_66
 89637	val_37
 89715	val_15
 89882	val_82
 89917	val_17
 9000	val_0
 90157	val_57
 90220	val_20
 90392	val_92
 90447	val_47
 90572	val_72
 9064	val_4
 90735	val_35
 90854	val_54
 90951	val_51
 91065	val_65
 91183	val_83
 91212	val_12
 91367	val_67
 91484	val_84
 91558	val_58
 9168	val_8
 91724	val_24
 91842	val_42
 9190	val_0
 92096	val_96
 92126	val_26
 92251	val_51
 92343	val_43
 92495	val_95
 92598	val_98
 92685	val_85
 92777	val_77
 9280	val_0
 92987	val_87
 93015	val_15
 93172	val_72
 93290	val_90
 93319	val_19
 93410	val_10
 9355	val_5
 93658	val_58
 93735	val_35
 93895	val_95
 93911	val_11
 94034	val_34
 94142	val_42
 94278	val_78
 94376	val_76
 94441	val_41
 94530	val_30
 94664	val_64
 94776	val_76
 94874	val_74
 94969	val_69
 95033	val_33
 95170	val_70
 9525	val_5
 9532	val_2
 95435	val_35
 95580	val_80
 95644	val_44
 95753	val_53
 95890	val_90
 95912	val_12
 9605	val_5
 96170	val_70
 96224	val_24
 96370	val_70
 96483	val_83
 96526	val_26
 96667	val_67
 96718	val_18
 9689	val_9
 96918	val_18
 97097	val_97
 97184	val_84
 97228	val_28
 97337	val_37
 97490	val_90
 97597	val_97
 976PREHOOK: query: -- SELECT JOINed product of two foreign tables
 977USE db2
 978PREHOOK: type: SWITCHDATABASE
 979POSTHOOK: query: -- SELECT JOINed product of two foreign tables
 980USE db2
 981POSTHOOK: type: SWITCHDATABASE
 982PREHOOK: query: SELECT a.* FROM db1.src a JOIN default.src1 b
 983ON (a.key = b.key)
 984PREHOOK: type: QUERY
 985PREHOOK: Input: db1@src
 986PREHOOK: Input: default@src1
 987PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-15_698_7511939016053492082/-mr-10000
 988POSTHOOK: query: SELECT a.* FROM db1.src a JOIN default.src1 b
 989ON (a.key = b.key)
 990POSTHOOK: type: QUERY
 991POSTHOOK: Input: db1@src
 992POSTHOOK: Input: default@src1
 993POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-15_698_7511939016053492082/-mr-10000
 994128	val_128
 995128	val_128
 996128	val_128
 997146	val_146
 998146	val_146
 999150	val_150
1000213	val_213
1001213	val_213
1002224	val_224
1003224	val_224
1004238	val_238
1005238	val_238
1006255	val_255
1007255	val_255
1008273	val_273
1009273	val_273
1010273	val_273
1011278	val_278
1012278	val_278
1013311	val_311
1014311	val_311
1015311	val_311
1016369	val_369
1017369	val_369
1018369	val_369
1019401	val_401
1020401	val_401
1021401	val_401
1022401	val_401
1023401	val_401
1024406	val_406
1025406	val_406
1026406	val_406
1027406	val_406
102866	val_66
102998	val_98
103098	val_98
1031PREHOOK: query: -- CREATE TABLE AS SELECT from foreign table
1032CREATE TABLE conflict_name AS
1033SELECT value FROM default.src WHERE key = 66
1034PREHOOK: type: CREATETABLE_AS_SELECT
1035PREHOOK: Input: default@src
1036POSTHOOK: query: -- CREATE TABLE AS SELECT from foreign table
1037CREATE TABLE conflict_name AS
1038SELECT value FROM default.src WHERE key = 66
1039POSTHOOK: type: CREATETABLE_AS_SELECT
1040POSTHOOK: Input: default@src
1041POSTHOOK: Output: db2@conflict_name
1042PREHOOK: query: -- CREATE foreign table
1043CREATE TABLE db1.conflict_name AS
1044SELECT value FROM db1.src WHERE key = 8
1045PREHOOK: type: CREATETABLE_AS_SELECT
1046PREHOOK: Input: db1@src
1047POSTHOOK: query: -- CREATE foreign table
1048CREATE TABLE db1.conflict_name AS
1049SELECT value FROM db1.src WHERE key = 8
1050POSTHOOK: type: CREATETABLE_AS_SELECT
1051POSTHOOK: Input: db1@src
1052POSTHOOK: Output: db1@conflict_name
1053PREHOOK: query: -- query tables with the same names in different DBs
1054SELECT * FROM (
1055  SELECT value FROM db1.conflict_name
1056UNION ALL
1057  SELECT value FROM conflict_name
1058) subq ORDER BY value
1059PREHOOK: type: QUERY
1060PREHOOK: Input: db1@conflict_name
1061PREHOOK: Input: db2@conflict_name
1062PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-26_087_6460717989691096433/-mr-10000
1063POSTHOOK: query: -- query tables with the same names in different DBs
1064SELECT * FROM (
1065  SELECT value FROM db1.conflict_name
1066UNION ALL
1067  SELECT value FROM conflict_name
1068) subq ORDER BY value
1069POSTHOOK: type: QUERY
1070POSTHOOK: Input: db1@conflict_name
1071POSTHOOK: Input: db2@conflict_name
1072POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-26_087_6460717989691096433/-mr-10000
1073val_66
1074val_8
1075PREHOOK: query: USE default
1076PREHOOK: type: SWITCHDATABASE
1077POSTHOOK: query: USE default
1078POSTHOOK: type: SWITCHDATABASE
1079PREHOOK: query: SELECT * FROM (
1080  SELECT value FROM db1.conflict_name
1081UNION ALL
1082  SELECT value FROM db2.conflict_name
1083) subq ORDER BY value
1084PREHOOK: type: QUERY
1085PREHOOK: Input: db1@conflict_name
1086PREHOOK: Input: db2@conflict_name
1087PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-29_569_4760700604948844000/-mr-10000
1088POSTHOOK: query: SELECT * FROM (
1089  SELECT value FROM db1.conflict_name
1090UNION ALL
1091  SELECT value FROM db2.conflict_name
1092) subq ORDER BY value
1093POSTHOOK: type: QUERY
1094POSTHOOK: Input: db1@conflict_name
1095POSTHOOK: Input: db2@conflict_name
1096POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-29_569_4760700604948844000/-mr-10000
1097val_66
1098val_8
1099PREHOOK: query: -- TABLESAMPLES
1100CREATE TABLE bucketized_src (key INT, value STRING)
1101CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS
1102PREHOOK: type: CREATETABLE
1103POSTHOOK: query: -- TABLESAMPLES
1104CREATE TABLE bucketized_src (key INT, value STRING)
1105CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS
1106POSTHOOK: type: CREATETABLE
1107POSTHOOK: Output: default@bucketized_src
1108PREHOOK: query: INSERT OVERWRITE TABLE bucketized_src
1109SELECT key, value FROM src WHERE key=66
1110PREHOOK: type: QUERY
1111PREHOOK: Input: default@src
1112PREHOOK: Output: default@bucketized_src
1113POSTHOOK: query: INSERT OVERWRITE TABLE bucketized_src
1114SELECT key, value FROM src WHERE key=66
1115POSTHOOK: type: QUERY
1116POSTHOOK: Input: default@src
1117POSTHOOK: Output: default@bucketized_src
1118POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1119POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1120PREHOOK: query: SELECT key FROM bucketized_src TABLESAMPLE(BUCKET 1 out of 1)
1121PREHOOK: type: QUERY
1122PREHOOK: Input: default@bucketized_src
1123PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-38_988_112069995278861989/-mr-10000
1124POSTHOOK: query: SELECT key FROM bucketized_src TABLESAMPLE(BUCKET 1 out of 1)
1125POSTHOOK: type: QUERY
1126POSTHOOK: Input: default@bucketized_src
1127POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-38_988_112069995278861989/-mr-10000
1128POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1129POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
113066
1131PREHOOK: query: -- CREATE TABLE LIKE
1132CREATE TABLE db2.src1 LIKE default.src
1133PREHOOK: type: CREATETABLE
1134POSTHOOK: query: -- CREATE TABLE LIKE
1135CREATE TABLE db2.src1 LIKE default.src
1136POSTHOOK: type: CREATETABLE
1137POSTHOOK: Output: db2@src1
1138POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1139POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1140PREHOOK: query: USE db2
1141PREHOOK: type: SWITCHDATABASE
1142POSTHOOK: query: USE db2
1143POSTHOOK: type: SWITCHDATABASE
1144POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1145POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1146PREHOOK: query: DESC EXTENDED src1
1147PREHOOK: type: DESCTABLE
1148POSTHOOK: query: DESC EXTENDED src1
1149POSTHOOK: type: DESCTABLE
1150POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1151POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1152key	string	default
1153value	string	default
1154	 	 
1155Detailed 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)	
1156PREHOOK: query: -- character escaping
1157SELECT key FROM `default`.src ORDER BY key LIMIT 1
1158PREHOOK: type: QUERY
1159PREHOOK: Input: default@src
1160PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-42_440_145101011848594604/-mr-10000
1161POSTHOOK: query: -- character escaping
1162SELECT key FROM `default`.src ORDER BY key LIMIT 1
1163POSTHOOK: type: QUERY
1164POSTHOOK: Input: default@src
1165POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-42_440_145101011848594604/-mr-10000
1166POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1167POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
11680
1169PREHOOK: query: SELECT key FROM `default`.`src` ORDER BY key LIMIT 1
1170PREHOOK: type: QUERY
1171PREHOOK: Input: default@src
1172PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-45_701_6560463601447490145/-mr-10000
1173POSTHOOK: query: SELECT key FROM `default`.`src` ORDER BY key LIMIT 1
1174POSTHOOK: type: QUERY
1175POSTHOOK: Input: default@src
1176POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-45_701_6560463601447490145/-mr-10000
1177POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1178POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
11790
1180PREHOOK: query: SELECT key FROM default.`src` ORDER BY key LIMIT 1
1181PREHOOK: type: QUERY
1182PREHOOK: Input: default@src
1183PREHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-49_089_4523523986113613592/-mr-10000
1184POSTHOOK: query: SELECT key FROM default.`src` ORDER BY key LIMIT 1
1185POSTHOOK: type: QUERY
1186POSTHOOK: Input: default@src
1187POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-09_16-44-49_089_4523523986113613592/-mr-10000
1188POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1189POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
11900
1191PREHOOK: query: USE default
1192PREHOOK: type: SWITCHDATABASE
1193POSTHOOK: query: USE default
1194POSTHOOK: type: SWITCHDATABASE
1195POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1196POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]