PREHOOK: query: create table exim_employee ( emp_id int comment "employee id") 	
	comment "employee table"
	partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
	stored as textfile	
	tblproperties("creator"="krishna")
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table exim_employee ( emp_id int comment "employee id") 	
	comment "employee table"
	partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
	stored as textfile	
	tblproperties("creator"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@exim_employee
PREHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="in", emp_state="tn")
PREHOOK: type: LOAD
PREHOOK: Output: default@exim_employee
POSTHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="in", emp_state="tn")
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_employee
POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=tn
PREHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="in", emp_state="ka")
PREHOOK: type: LOAD
PREHOOK: Output: default@exim_employee
POSTHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="in", emp_state="ka")
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_employee
POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=ka
PREHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="us", emp_state="tn")
PREHOOK: type: LOAD
PREHOOK: Output: default@exim_employee
POSTHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="us", emp_state="tn")
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_employee
POSTHOOK: Output: default@exim_employee@emp_country=us/emp_state=tn
PREHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="us", emp_state="ka")
PREHOOK: type: LOAD
PREHOOK: Output: default@exim_employee
POSTHOOK: query: load data local inpath "../data/files/test.dat" 
	into table exim_employee partition (emp_country="us", emp_state="ka")
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_employee
POSTHOOK: Output: default@exim_employee@emp_country=us/emp_state=ka
#### A masked pattern was here ####
PREHOOK: query: export table exim_employee partition (emp_country="in",emp_state="ka") to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
#### A masked pattern was here ####
POSTHOOK: query: export table exim_employee partition (emp_country="in",emp_state="ka") to 'ql/test/data/exports/exim_employee'
POSTHOOK: type: EXPORT
POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
#### A masked pattern was here ####
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@exim_employee
PREHOOK: Output: default@exim_employee
POSTHOOK: query: drop table exim_employee
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@exim_employee
POSTHOOK: Output: default@exim_employee
PREHOOK: query: create database importer
PREHOOK: type: CREATEDATABASE
POSTHOOK: query: create database importer
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: use importer
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: use importer
POSTHOOK: type: SWITCHDATABASE
PREHOOK: query: import from 'ql/test/data/exports/exim_employee'
PREHOOK: type: IMPORT
POSTHOOK: query: import from 'ql/test/data/exports/exim_employee'
POSTHOOK: type: IMPORT
POSTHOOK: Output: importer@exim_employee
POSTHOOK: Output: importer@exim_employee@emp_country=in/emp_state=ka
PREHOOK: query: describe extended exim_employee
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
emp_id              	int                 	employee id         
emp_country         	string              	two char iso code   
emp_state           	string              	free text           
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
emp_country         	string              	two char iso code   
emp_state           	string              	free text           
	 	 
#### A masked pattern was here ####
PREHOOK: query: show table extended like exim_employee
PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: show table extended like exim_employee
POSTHOOK: type: SHOW_TABLESTATUS
tableName:exim_employee
#### A masked pattern was here ####
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { i32 emp_id}
partitioned:true
partitionColumns:struct partition_columns { string emp_country, string emp_state}
totalNumberFiles:1
totalFileSize:11
maxFileSize:11
minFileSize:11
#### A masked pattern was here ####

#### A masked pattern was here ####
PREHOOK: query: select * from exim_employee
PREHOOK: type: QUERY
PREHOOK: Input: importer@exim_employee
PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
#### A masked pattern was here ####
POSTHOOK: query: select * from exim_employee
POSTHOOK: type: QUERY
POSTHOOK: Input: importer@exim_employee
POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
#### A masked pattern was here ####
1	in	ka
2	in	ka
3	in	ka
4	in	ka
5	in	ka
6	in	ka
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
PREHOOK: Output: importer@exim_employee
POSTHOOK: query: drop table exim_employee
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: importer@exim_employee
POSTHOOK: Output: importer@exim_employee
PREHOOK: query: drop database importer
PREHOOK: type: DROPDATABASE
POSTHOOK: query: drop database importer
POSTHOOK: type: DROPDATABASE