You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/08/27 07:41:45 UTC
svn commit: r990026 [10/10] - in /hadoop/hive/trunk: ./ eclipse-templates/
metastore/if/ metastore/src/gen-cpp/
metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/
metastore/src/gen-php/ metastore/src/gen-py/hive_metastore/
metastore/src/j...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out?rev=990026&r1=990025&r2=990026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out Fri Aug 27 05:41:43 2010
@@ -30,11 +30,11 @@ POSTHOOK: Lineage: alter3 PARTITION(pcol
PREHOOK: query: select * from alter3 where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter3@pcol1=test_part/pcol2=test_part
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-16_23-23-57_980_3959366436597643277/-mr-10000
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-21_932_3372743948578297998/-mr-10000
POSTHOOK: query: select * from alter3 where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter3@pcol1=test_part/pcol2=test_part
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-16_23-23-57_980_3959366436597643277/-mr-10000
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-21_932_3372743948578297998/-mr-10000
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_part
2 test_part test_part
@@ -61,7 +61,7 @@ col1 string
pcol1 string
pcol2 string
-Detailed Table Information Table(tableName:alter3_renamed, dbName:default, owner:njain, createTime:1282026233, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{last_modified_by=njain, last_modified_time=1282026238, transient_lastDdlTime=1282026238}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:alter3_renamed, dbName:default, owner:carl, createTime:1282710015, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{last_modified_by=carl, last_modified_time=1282710022, transient_lastDdlTime=1282710022}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: describe extended alter3_renamed partition (pCol1='test_part', pcol2='test_part')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter3_renamed partition (pCol1='test_part', pcol2='test_part')
@@ -71,15 +71,15 @@ col1 string
pcol1 string
pcol2 string
-Detailed Partition Information Partition(values:[test_part, test_part], dbName:default, tableName:alter3_renamed, createTime:1282026237, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/alter3_renamed/pcol1=test_part/pcol2=test_part, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1282026237})
+Detailed Partition Information Partition(values:[test_part, test_part], dbName:default, tableName:alter3_renamed, createTime:1282710021, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter3_renamed/pcol1=test_part/pcol2=test_part, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1282710021})
PREHOOK: query: select * from alter3_renamed where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter3_renamed@pcol1=test_part/pcol2=test_part
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-16_23-23-58_985_8799413873165106617/-mr-10000
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-22_594_4220539088907093497/-mr-10000
POSTHOOK: query: select * from alter3_renamed where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter3_renamed@pcol1=test_part/pcol2=test_part
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-16_23-23-58_985_8799413873165106617/-mr-10000
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-22_594_4220539088907093497/-mr-10000
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_part
2 test_part test_part
@@ -122,4 +122,223 @@ col1 string
pcol1 string
pcol2 string
-Detailed Table Information Table(tableName:alter3_like_renamed, dbName:default, owner:njain, createTime:1282026233, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{EXTERNAL=FALSE, last_modified_by=njain, last_modified_time=1282026243, transient_lastDdlTime=1282026243}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TAB
LE)
+Detailed Table Information Table(tableName:alter3_like_renamed, dbName:default, owner:carl, createTime:1282710015, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{EXTERNAL=FALSE, last_modified_by=carl, last_modified_time=1282710028, transient_lastDdlTime=1282710028}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: -- Cleanup
+DROP TABLE alter3_src
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@alter3_src
+PREHOOK: Output: default@alter3_src
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter3_src
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@alter3_src
+POSTHOOK: Output: default@alter3_src
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: DROP TABLE alter3_renamed
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@alter3_renamed
+PREHOOK: Output: default@alter3_renamed
+POSTHOOK: query: DROP TABLE alter3_renamed
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@alter3_renamed
+POSTHOOK: Output: default@alter3_renamed
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: DROP TABLE alter3_like_renamed
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@alter3_like_renamed
+PREHOOK: Output: default@alter3_like_renamed
+POSTHOOK: query: DROP TABLE alter3_like_renamed
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@alter3_like_renamed
+POSTHOOK: Output: default@alter3_like_renamed
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+src
+src1
+src_json
+src_sequencefile
+src_thrift
+srcbucket
+srcbucket2
+srcpart
+PREHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter3_db
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter3_db
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: USE alter3_db
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE alter3_db
+POSTHOOK: type: SWITCHDATABASE
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: CREATE TABLE alter3_src (col1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE alter3_src (col1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: alter3_db@alter3_src
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE alter3_src
+PREHOOK: type: LOAD
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE alter3_src
+POSTHOOK: type: LOAD
+POSTHOOK: Output: alter3_db@alter3_src
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: CREATE TABLE alter3 (col1 STRING) PARTITIONED BY (pcol1 STRING, pcol2 STRING) STORED AS SEQUENCEFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE alter3 (col1 STRING) PARTITIONED BY (pcol1 STRING, pcol2 STRING) STORED AS SEQUENCEFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: alter3_db@alter3
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: CREATE TABLE alter3_like LIKE alter3
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE alter3_like LIKE alter3
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: alter3_db@alter3_like
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: INSERT OVERWRITE TABLE alter3 PARTITION (pCol1='test_part', pcol2='test_part') SELECT col1 FROM alter3_src
+PREHOOK: type: QUERY
+PREHOOK: Input: alter3_db@alter3_src
+PREHOOK: Output: alter3_db@alter3@pcol1=test_part/pcol2=test_part
+POSTHOOK: query: INSERT OVERWRITE TABLE alter3 PARTITION (pCol1='test_part', pcol2='test_part') SELECT col1 FROM alter3_src
+POSTHOOK: type: QUERY
+POSTHOOK: Input: alter3_db@alter3_src
+POSTHOOK: Output: alter3_db@alter3@pcol1=test_part/pcol2=test_part
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part' AND pcol2='test_part'
+PREHOOK: type: QUERY
+PREHOOK: Input: alter3_db@alter3@pcol1=test_part/pcol2=test_part
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-37_655_2638711537174977246/-mr-10000
+POSTHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part' AND pcol2='test_part'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: alter3_db@alter3@pcol1=test_part/pcol2=test_part
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-37_655_2638711537174977246/-mr-10000
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+1 test_part test_part
+2 test_part test_part
+3 test_part test_part
+4 test_part test_part
+5 test_part test_part
+6 test_part test_part
+PREHOOK: query: ALTER TABLE alter3 RENAME TO alter3_renamed
+PREHOOK: type: ALTERTABLE_RENAME
+PREHOOK: Input: alter3_db@alter3
+PREHOOK: Output: alter3_db@alter3
+POSTHOOK: query: ALTER TABLE alter3 RENAME TO alter3_renamed
+POSTHOOK: type: ALTERTABLE_RENAME
+POSTHOOK: Input: alter3_db@alter3
+POSTHOOK: Output: alter3_db@alter3
+POSTHOOK: Output: alter3_db@alter3_renamed
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: DESCRIBE EXTENDED alter3_renamed
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+col1 string
+pcol1 string
+pcol2 string
+
+Detailed Table Information Table(tableName:alter3_renamed, dbName:alter3_db, owner:carl, createTime:1282710029, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{last_modified_by=carl, last_modified_time=1282710037, transient_lastDdlTime=1282710037}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part', pcol2='test_part')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part', pcol2='test_part')
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+col1 string
+pcol1 string
+pcol2 string
+
+Detailed Partition Information Partition(values:[test_part, test_part], dbName:alter3_db, tableName:alter3_renamed, createTime:1282710037, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed/pcol1=test_part/pcol2=test_part, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1282710037})
+PREHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part' AND pcol2='test_part'
+PREHOOK: type: QUERY
+PREHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part/pcol2=test_part
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-38_226_752504330069771446/-mr-10000
+POSTHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part' AND pcol2='test_part'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part/pcol2=test_part
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_21-20-38_226_752504330069771446/-mr-10000
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+1 test_part test_part
+2 test_part test_part
+3 test_part test_part
+4 test_part test_part
+5 test_part test_part
+6 test_part test_part
+PREHOOK: query: INSERT OVERWRITE TABLE alter3_like
+PARTITION (pCol1='test_part', pcol2='test_part')
+SELECT col1 FROM alter3_src
+PREHOOK: type: QUERY
+PREHOOK: Input: alter3_db@alter3_src
+PREHOOK: Output: alter3_db@alter3_like@pcol1=test_part/pcol2=test_part
+POSTHOOK: query: INSERT OVERWRITE TABLE alter3_like
+PARTITION (pCol1='test_part', pcol2='test_part')
+SELECT col1 FROM alter3_src
+POSTHOOK: type: QUERY
+POSTHOOK: Input: alter3_db@alter3_src
+POSTHOOK: Output: alter3_db@alter3_like@pcol1=test_part/pcol2=test_part
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: ALTER TABLE alter3_like RENAME TO alter3_like_renamed
+PREHOOK: type: ALTERTABLE_RENAME
+PREHOOK: Input: alter3_db@alter3_like
+PREHOOK: Output: alter3_db@alter3_like
+POSTHOOK: query: ALTER TABLE alter3_like RENAME TO alter3_like_renamed
+POSTHOOK: type: ALTERTABLE_RENAME
+POSTHOOK: Input: alter3_db@alter3_like
+POSTHOOK: Output: alter3_db@alter3_like
+POSTHOOK: Output: alter3_db@alter3_like_renamed
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+PREHOOK: query: DESCRIBE EXTENDED alter3_like_renamed
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED alter3_like_renamed
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part,pcol2=test_part).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
+col1 string
+pcol1 string
+pcol2 string
+
+Detailed Table Information Table(tableName:alter3_like_renamed, dbName:alter3_db, owner:carl, createTime:1282710029, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter3_db.db/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{EXTERNAL=FALSE, last_modified_by=carl, last_modified_time=1282710044, transient_lastDdlTime=1282710044}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out?rev=990026&r1=990025&r2=990026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out Fri Aug 27 05:41:43 2010
@@ -10,7 +10,7 @@ POSTHOOK: type: DESCTABLE
key int
value string
-Detailed Table Information Table(tableName:set_bucketing_test, dbName:default, owner:njain, createTime:1282026244, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/set_bucketing_test, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:10, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[key], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1282026244}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:default, owner:carl, createTime:1282710046, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/set_bucketing_test, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:10, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[key], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1282710046}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE set_bucketing_test NOT CLUSTERED
PREHOOK: type: null
PREHOOK: Input: default@set_bucketing_test
@@ -26,4 +26,92 @@ POSTHOOK: type: DESCTABLE
key int
value string
-Detailed Table Information Table(tableName:set_bucketing_test, dbName:default, owner:njain, createTime:1282026244, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/set_bucketing_test, 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:{last_modified_by=njain, last_modified_time=1282026244, transient_lastDdlTime=1282026244}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:default, owner:carl, createTime:1282710046, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/set_bucketing_test, 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:{last_modified_by=carl, last_modified_time=1282710046, transient_lastDdlTime=1282710046}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: -- Cleanup
+DROP TABLE set_bucketing_test
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@set_bucketing_test
+PREHOOK: Output: default@set_bucketing_test
+POSTHOOK: query: -- Cleanup
+DROP TABLE set_bucketing_test
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@set_bucketing_test
+POSTHOOK: Output: default@set_bucketing_test
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+src
+src1
+src_json
+src_sequencefile
+src_thrift
+srcbucket
+srcbucket2
+srcpart
+PREHOOK: query: -- with non-default Database
+
+CREATE DATABASE alter4_db
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- with non-default Database
+
+CREATE DATABASE alter4_db
+POSTHOOK: type: CREATEDATABASE
+PREHOOK: query: USE alter4_db
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE alter4_db
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+PREHOOK: query: CREATE TABLE set_bucketing_test (key INT, value STRING) CLUSTERED BY (key) INTO 10 BUCKETS
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE set_bucketing_test (key INT, value STRING) CLUSTERED BY (key) INTO 10 BUCKETS
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: alter4_db@set_bucketing_test
+PREHOOK: query: DESCRIBE EXTENDED set_bucketing_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED set_bucketing_test
+POSTHOOK: type: DESCTABLE
+key int
+value string
+
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:alter4_db, owner:carl, createTime:1282710046, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter4_db.db/set_bucketing_test, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:10, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[key], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1282710046}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: ALTER TABLE set_bucketing_test NOT CLUSTERED
+PREHOOK: type: null
+PREHOOK: Input: alter4_db@set_bucketing_test
+PREHOOK: Output: alter4_db@set_bucketing_test
+POSTHOOK: query: ALTER TABLE set_bucketing_test NOT CLUSTERED
+POSTHOOK: type: null
+POSTHOOK: Input: alter4_db@set_bucketing_test
+POSTHOOK: Output: alter4_db@set_bucketing_test
+PREHOOK: query: DESCRIBE EXTENDED set_bucketing_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED set_bucketing_test
+POSTHOOK: type: DESCTABLE
+key int
+value string
+
+Detailed Table Information Table(tableName:set_bucketing_test, dbName:alter4_db, owner:carl, createTime:1282710046, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/build/ql/test/data/warehouse/alter4_db.db/set_bucketing_test, 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:{last_modified_by=carl, last_modified_time=1282710046, transient_lastDdlTime=1282710046}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: DROP TABLE set_bucketing_test
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: alter4_db@set_bucketing_test
+PREHOOK: Output: alter4_db@set_bucketing_test
+POSTHOOK: query: DROP TABLE set_bucketing_test
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: alter4_db@set_bucketing_test
+POSTHOOK: Output: alter4_db@set_bucketing_test
+PREHOOK: query: USE default
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE default
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: DROP DATABASE alter4_db
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: DROP DATABASE alter4_db
+POSTHOOK: type: DROPDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/database.q.out?rev=990026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/database.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/database.q.out Fri Aug 27 05:41:43 2010
@@ -0,0 +1,311 @@
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+PREHOOK: query: -- CREATE with comment
+CREATE DATABASE test_db COMMENT 'Hive test database'
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- CREATE with comment
+CREATE DATABASE test_db COMMENT 'Hive test database'
+POSTHOOK: type: CREATEDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+test_db
+PREHOOK: query: -- CREATE INE already exists
+CREATE DATABASE IF NOT EXISTS test_db
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- CREATE INE already exists
+CREATE DATABASE IF NOT EXISTS test_db
+POSTHOOK: type: CREATEDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+test_db
+PREHOOK: query: -- SHOW DATABASES synonym
+SHOW SCHEMAS
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: -- SHOW DATABASES synonym
+SHOW SCHEMAS
+POSTHOOK: type: SHOWDATABASES
+default
+test_db
+PREHOOK: query: -- DROP
+DROP DATABASE test_db
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: -- DROP
+DROP DATABASE test_db
+POSTHOOK: type: DROPDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+PREHOOK: query: -- CREATE INE doesn't exist
+CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- CREATE INE doesn't exist
+CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'
+POSTHOOK: type: CREATEDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+test_db
+PREHOOK: query: -- DROP IE exists
+DROP DATABASE IF EXISTS test_db
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: -- DROP IE exists
+DROP DATABASE IF EXISTS test_db
+POSTHOOK: type: DROPDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+PREHOOK: query: -- DROP IE doesn't exist
+DROP DATABASE IF EXISTS test_db
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: -- DROP IE doesn't exist
+DROP DATABASE IF EXISTS test_db
+POSTHOOK: type: DROPDATABASE
+PREHOOK: query: -- SHOW
+CREATE DATABASE test_db
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- SHOW
+CREATE DATABASE test_db
+POSTHOOK: type: CREATEDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+test_db
+PREHOOK: query: -- SHOW pattern
+SHOW DATABASES LIKE 'test*'
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: -- SHOW pattern
+SHOW DATABASES LIKE 'test*'
+POSTHOOK: type: SHOWDATABASES
+test_db
+PREHOOK: query: -- SHOW pattern
+SHOW DATABASES LIKE '*ef*'
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: -- SHOW pattern
+SHOW DATABASES LIKE '*ef*'
+POSTHOOK: type: SHOWDATABASES
+default
+PREHOOK: query: USE test_db
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE test_db
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
+test_db
+PREHOOK: query: -- CREATE table in non-default DB
+CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- CREATE table in non-default DB
+CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: test_db@test_table
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+test_table
+PREHOOK: query: -- DESCRIBE table in non-default DB
+DESCRIBE test_table
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- DESCRIBE table in non-default DB
+DESCRIBE test_table
+POSTHOOK: type: DESCTABLE
+col1 string
+PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
+DESCRIBE EXTENDED test_table
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
+DESCRIBE EXTENDED test_table
+POSTHOOK: type: DESCTABLE
+col1 string
+
+Detailed Table Information Table(tableName:test_table, dbName:test_db, owner:carl, createTime:1282718578, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/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=1282718578}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: -- CREATE LIKE in non-default DB
+CREATE TABLE test_table_like LIKE test_table
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- CREATE LIKE in non-default DB
+CREATE TABLE test_table_like LIKE test_table
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: test_db@test_table_like
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+test_table
+test_table_like
+PREHOOK: query: DESCRIBE EXTENDED test_table_like
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED test_table_like
+POSTHOOK: type: DESCTABLE
+col1 string
+
+Detailed Table Information Table(tableName:test_table_like, dbName:test_db, owner:carl, createTime:1282718578, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/Users/carl/Projects/hive/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:{EXTERNAL=FALSE, transient_lastDdlTime=1282718578}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: -- LOAD and SELECT
+LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE test_table
+PREHOOK: type: LOAD
+POSTHOOK: query: -- LOAD and SELECT
+LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE test_table
+POSTHOOK: type: LOAD
+POSTHOOK: Output: test_db@test_table
+PREHOOK: query: SELECT * FROM test_table
+PREHOOK: type: QUERY
+PREHOOK: Input: test_db@test_table
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-42-59_567_2461111790069590361/-mr-10000
+POSTHOOK: query: SELECT * FROM test_table
+POSTHOOK: type: QUERY
+POSTHOOK: Input: test_db@test_table
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-42-59_567_2461111790069590361/-mr-10000
+1
+2
+3
+4
+5
+6
+PREHOOK: query: -- DROP and CREATE w/o LOAD
+DROP TABLE test_table
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: test_db@test_table
+PREHOOK: Output: test_db@test_table
+POSTHOOK: query: -- DROP and CREATE w/o LOAD
+DROP TABLE test_table
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: test_db@test_table
+POSTHOOK: Output: test_db@test_table
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+test_table_like
+PREHOOK: query: CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE test_table (col1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: test_db@test_table
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+test_table
+test_table_like
+PREHOOK: query: SELECT * FROM test_table
+PREHOOK: type: QUERY
+PREHOOK: Input: test_db@test_table
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-43-00_940_5138756558646274720/-mr-10000
+POSTHOOK: query: SELECT * FROM test_table
+POSTHOOK: type: QUERY
+POSTHOOK: Input: test_db@test_table
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-43-00_940_5138756558646274720/-mr-10000
+PREHOOK: query: -- CREATE table that already exists in DEFAULT
+USE test_db
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: -- CREATE table that already exists in DEFAULT
+USE test_db
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: CREATE TABLE src (col1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE src (col1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: test_db@src
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+src
+test_table
+test_table_like
+PREHOOK: query: SELECT * FROM src LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: test_db@src
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-43-01_221_2875743952247647479/-mr-10000
+POSTHOOK: query: SELECT * FROM src LIMIT 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: test_db@src
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-43-01_221_2875743952247647479/-mr-10000
+PREHOOK: query: USE default
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE default
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: SELECT * FROM src LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-43-01_337_7970214163805278546/-mr-10000
+POSTHOOK: query: SELECT * FROM src LIMIT 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2010-08-24_23-43-01_337_7970214163805278546/-mr-10000
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+PREHOOK: query: -- DROP DATABASE
+USE test_db
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: -- DROP DATABASE
+USE test_db
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: DROP TABLE src
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: test_db@src
+PREHOOK: Output: test_db@src
+POSTHOOK: query: DROP TABLE src
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: test_db@src
+POSTHOOK: Output: test_db@src
+PREHOOK: query: DROP TABLE test_table
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: test_db@test_table
+PREHOOK: Output: test_db@test_table
+POSTHOOK: query: DROP TABLE test_table
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: test_db@test_table
+POSTHOOK: Output: test_db@test_table
+PREHOOK: query: DROP TABLE test_table_like
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: test_db@test_table_like
+PREHOOK: Output: test_db@test_table_like
+POSTHOOK: query: DROP TABLE test_table_like
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: test_db@test_table_like
+POSTHOOK: Output: test_db@test_table_like
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+PREHOOK: query: USE default
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE default
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: DROP DATABASE test_db
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: DROP DATABASE test_db
+POSTHOOK: type: DROPDATABASE
+PREHOOK: query: SHOW DATABASES
+PREHOOK: type: SHOWDATABASES
+POSTHOOK: query: SHOW DATABASES
+POSTHOOK: type: SHOWDATABASES
+default
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out?rev=990026&r1=990025&r2=990026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out Fri Aug 27 05:41:43 2010
@@ -115,3 +115,162 @@ POSTHOOK: type: DESCTABLE
b int
a int test comment2
c int
+PREHOOK: query: DROP TABLE kv_rename_test
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
+POSTHOOK: query: DROP TABLE kv_rename_test
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@kv_rename_test
+POSTHOOK: Output: default@kv_rename_test
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES
+src
+src1
+src_json
+src_sequencefile
+src_thrift
+srcbucket
+srcbucket2
+srcpart
+PREHOOK: query: -- Using non-default Database
+CREATE DATABASE kv_rename_test_db
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: -- Using non-default Database
+CREATE DATABASE kv_rename_test_db
+POSTHOOK: type: CREATEDATABASE
+PREHOOK: query: USE kv_rename_test_db
+PREHOOK: type: SWITCHDATABASE
+POSTHOOK: query: USE kv_rename_test_db
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: CREATE TABLE kv_rename_test(a int, b int, c int)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE kv_rename_test(a int, b int, c int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+a int
+b int
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a STRING
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a a STRING
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+a string
+b int
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+a1 int
+b int
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+a2 int
+b int
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+b int
+a int
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1'
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1'
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+b int
+a1 int test comment1
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+a2 int test comment2
+b int
+c int
+PREHOOK: query: ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: DESCRIBE kv_rename_test
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE kv_rename_test
+POSTHOOK: type: DESCTABLE
+b int
+a int test comment2
+c int
+PREHOOK: query: DROP TABLE kv_rename_test
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: kv_rename_test_db@kv_rename_test
+PREHOOK: Output: kv_rename_test_db@kv_rename_test
+POSTHOOK: query: DROP TABLE kv_rename_test
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: kv_rename_test_db@kv_rename_test
+POSTHOOK: Output: kv_rename_test_db@kv_rename_test
+PREHOOK: query: SHOW TABLES
+PREHOOK: type: SHOWTABLES
+POSTHOOK: query: SHOW TABLES
+POSTHOOK: type: SHOWTABLES