PREHOOK: query: --
-- Added to validate the fix for HIVE-2117 - explicit partition location
--

create table alter5_src ( col1 string ) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: --
-- Added to validate the fix for HIVE-2117 - explicit partition location
--

create table alter5_src ( col1 string ) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter5_src
PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter5_src
PREHOOK: type: LOAD
PREHOOK: Output: default@alter5_src
POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter5_src
POSTHOOK: type: LOAD
POSTHOOK: Output: default@alter5_src
PREHOOK: query: create table alter5 ( col1 string ) partitioned by (dt string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table alter5 ( col1 string ) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter5
PREHOOK: query: --
-- Here's the interesting bit for HIVE-2117 - partition subdir should be
-- named "parta".
--
alter table alter5 add partition (dt='a') location 'parta'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@alter5
POSTHOOK: query: --
-- Here's the interesting bit for HIVE-2117 - partition subdir should be
-- named "parta".
--
alter table alter5 add partition (dt='a') location 'parta'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@alter5
POSTHOOK: Output: default@alter5@dt=a
PREHOOK: query: describe extended alter5 partition (dt='a')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter5 partition (dt='a')
POSTHOOK: type: DESCTABLE
col1	string	
dt	string	
	 	 
Detailed Partition Information	Partition(values:[a], dbName:default, tableName:alter5, createTime:1304626469, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/home/phunt/dev/hive/build/ql/test/data/warehouse/alter5/parta, 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:{}), parameters:{transient_lastDdlTime=1304626469})	
PREHOOK: query: insert overwrite table alter5 partition (dt='a') select col1 from alter5_src
PREHOOK: type: QUERY
PREHOOK: Input: default@alter5_src
PREHOOK: Output: default@alter5@dt=a
POSTHOOK: query: insert overwrite table alter5 partition (dt='a') select col1 from alter5_src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter5_src
POSTHOOK: Output: default@alter5@dt=a
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from alter5 where dt='a'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter5@dt=a
PREHOOK: Output: file:/tmp/phunt/hive_2011-05-05_13-14-37_578_1796477555405644183/-mr-10000
POSTHOOK: query: select * from alter5 where dt='a'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter5@dt=a
POSTHOOK: Output: file:/tmp/phunt/hive_2011-05-05_13-14-37_578_1796477555405644183/-mr-10000
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
1	a
2	a
3	a
4	a
5	a
6	a
PREHOOK: query: describe extended alter5 partition (dt='a')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter5 partition (dt='a')
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
col1	string	
dt	string	
	 	 
Detailed Partition Information	Partition(values:[a], dbName:default, tableName:alter5, createTime:1304626469, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/home/phunt/dev/hive/build/ql/test/data/warehouse/alter5/parta, 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:{}), parameters:{numFiles=1, transient_lastDdlTime=1304626476, numRows=6, totalSize=12})	
PREHOOK: query: -- Cleanup
DROP TABLE alter5_src
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter5_src
PREHOOK: Output: default@alter5_src
POSTHOOK: query: -- Cleanup
DROP TABLE alter5_src
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter5_src
POSTHOOK: Output: default@alter5_src
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: DROP TABLE alter5
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter5
PREHOOK: Output: default@alter5
POSTHOOK: query: DROP TABLE alter5
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter5
POSTHOOK: Output: default@alter5
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_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 alter5_db
PREHOOK: type: CREATEDATABASE
POSTHOOK: query: -- With non-default Database

CREATE DATABASE alter5_db
POSTHOOK: type: CREATEDATABASE
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: USE alter5_db
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: USE alter5_db
POSTHOOK: type: SWITCHDATABASE
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: create table alter5_src ( col1 string ) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table alter5_src ( col1 string ) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: alter5_db@alter5_src
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter5_src
PREHOOK: type: LOAD
PREHOOK: Output: alter5_db@alter5_src
POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter5_src
POSTHOOK: type: LOAD
POSTHOOK: Output: alter5_db@alter5_src
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: create table alter5 ( col1 string ) partitioned by (dt string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table alter5 ( col1 string ) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: alter5_db@alter5
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: alter table alter5 add partition (dt='a') location 'parta'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: alter5_db@alter5
POSTHOOK: query: alter table alter5 add partition (dt='a') location 'parta'
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: alter5_db@alter5
POSTHOOK: Output: alter5_db@alter5@dt=a
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: describe extended alter5 partition (dt='a')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter5 partition (dt='a')
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
col1	string	
dt	string	
	 	 
Detailed Partition Information	Partition(values:[a], dbName:alter5_db, tableName:alter5, createTime:1304626483, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/home/phunt/dev/hive/build/ql/test/data/warehouse/alter5_db.db/alter5/parta, 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:{}), parameters:{transient_lastDdlTime=1304626483})	
PREHOOK: query: insert overwrite table alter5 partition (dt='a') select col1 from alter5_src
PREHOOK: type: QUERY
PREHOOK: Input: alter5_db@alter5_src
PREHOOK: Output: alter5_db@alter5@dt=a
POSTHOOK: query: insert overwrite table alter5 partition (dt='a') select col1 from alter5_src
POSTHOOK: type: QUERY
POSTHOOK: Input: alter5_db@alter5_src
POSTHOOK: Output: alter5_db@alter5@dt=a
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from alter5 where dt='a'
PREHOOK: type: QUERY
PREHOOK: Input: alter5_db@alter5@dt=a
PREHOOK: Output: file:/tmp/phunt/hive_2011-05-05_13-14-49_883_4190579771388965111/-mr-10000
POSTHOOK: query: select * from alter5 where dt='a'
POSTHOOK: type: QUERY
POSTHOOK: Input: alter5_db@alter5@dt=a
POSTHOOK: Output: file:/tmp/phunt/hive_2011-05-05_13-14-49_883_4190579771388965111/-mr-10000
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
1	a
2	a
3	a
4	a
5	a
6	a
PREHOOK: query: describe extended alter5 partition (dt='a')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter5 partition (dt='a')
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
col1	string	
dt	string	
	 	 
Detailed Partition Information	Partition(values:[a], dbName:alter5_db, tableName:alter5, createTime:1304626483, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/home/phunt/dev/hive/build/ql/test/data/warehouse/alter5_db.db/alter5/parta, 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:{}), parameters:{numFiles=1, transient_lastDdlTime=1304626489, numRows=6, totalSize=12})