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	
	 	 
#### A masked pattern was here ####
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
#### A masked pattern was here ####
POSTHOOK: query: select * from alter5 where dt='a'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter5@dt=a
#### A masked pattern was here ####
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	
	 	 
#### A masked pattern was here ####
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	
	 	 
#### A masked pattern was here ####
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
#### A masked pattern was here ####
POSTHOOK: query: select * from alter5 where dt='a'
POSTHOOK: type: QUERY
POSTHOOK: Input: alter5_db@alter5@dt=a
#### A masked pattern was here ####
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	
	 	 
#### A masked pattern was here ####