hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pa...@apache.org
Subject svn commit: r1081930 [5/5] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/conf/ conf/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/org/apache/ha...
Date Tue, 15 Mar 2011 20:29:05 GMT
Added: hive/trunk/ql/src/test/results/clientpositive/exim_12_external_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_12_external_location.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_12_external_location.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_12_external_location.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,86 @@
+PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile	
+	tblproperties("creator"="krishna")
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile	
+	tblproperties("creator"="krishna")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: type: LOAD
+POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: default@exim_department
+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 external table exim_department from 'ql/test/data/exports/exim_department' 
+	location 'ql/test/data/tablestore/exim_department'
+PREHOOK: type: IMPORT
+POSTHOOK: query: import external table exim_department from 'ql/test/data/exports/exim_department' 
+	location 'ql/test/data/tablestore/exim_department'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: describe extended exim_department
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended exim_department
+POSTHOOK: type: DESCTABLE
+dep_id	int	department id
+	 	 
+Detailed Table Information	Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1297311859, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:dep_id, type:int, comment:department id)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_department, 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=TRUE, transient_lastDdlTime=1297311859, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-20_068_3309861788122881126/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-20_068_3309861788122881126/-mr-10000
+1
+2
+3
+4
+5
+6
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-20_696_7670739579941498207/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-20_696_7670739579941498207/-mr-10000
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: drop database importer
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: drop database importer
+POSTHOOK: type: DROPDATABASE

Added: hive/trunk/ql/src/test/results/clientpositive/exim_13_managed_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_13_managed_location.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_13_managed_location.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_13_managed_location.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,86 @@
+PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile	
+	tblproperties("creator"="krishna")
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile	
+	tblproperties("creator"="krishna")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: type: LOAD
+POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: default@exim_department
+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 table exim_department from 'ql/test/data/exports/exim_department' 
+	location 'ql/test/data/tablestore/exim_department'
+PREHOOK: type: IMPORT
+POSTHOOK: query: import table exim_department from 'ql/test/data/exports/exim_department' 
+	location 'ql/test/data/tablestore/exim_department'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: describe extended exim_department
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended exim_department
+POSTHOOK: type: DESCTABLE
+dep_id	int	department id
+	 	 
+Detailed Table Information	Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1297311864, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:dep_id, type:int, comment:department id)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_department, 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=1297311864, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-25_145_588196874535196225/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-25_145_588196874535196225/-mr-10000
+1
+2
+3
+4
+5
+6
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-25_647_5856867800290486149/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-25_647_5856867800290486149/-mr-10000
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: drop database importer
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: drop database importer
+POSTHOOK: type: DROPDATABASE

Added: hive/trunk/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,98 @@
+PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile	
+	tblproperties("creator"="krishna")
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile	
+	tblproperties("creator"="krishna")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: type: LOAD
+POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: default@exim_department
+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: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile
+	location 'ql/test/data/tablestore/exim_department'
+	tblproperties("creator"="krishna")
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
+	stored as textfile
+	location 'ql/test/data/tablestore/exim_department'
+	tblproperties("creator"="krishna")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: import table exim_department from 'ql/test/data/exports/exim_department'
+	location 'ql/test/data/tablestore/exim_department'
+PREHOOK: type: IMPORT
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: import table exim_department from 'ql/test/data/exports/exim_department'
+	location 'ql/test/data/tablestore/exim_department'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: describe extended exim_department
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended exim_department
+POSTHOOK: type: DESCTABLE
+dep_id	int	department id
+	 	 
+Detailed Table Information	Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1297311869, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:dep_id, type:int, comment:department id)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_department, 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=1297311870, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-31_166_6776181430161725461/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-31_166_6776181430161725461/-mr-10000
+1
+2
+3
+4
+5
+6
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-31_850_7212760938753686826/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-31_850_7212760938753686826/-mr-10000
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: drop database importer
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: drop database importer
+POSTHOOK: type: DROPDATABASE

Added: hive/trunk/ql/src/test/results/clientpositive/exim_15_external_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_15_external_part.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_15_external_part.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_15_external_part.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,196 @@
+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
+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@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
+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@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
+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@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
+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@emp_country=us/emp_state=ka
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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: create external 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	
+	location 'ql/test/data/tablestore/exim_employee'
+	tblproperties("creator"="krishna")
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create external 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	
+	location 'ql/test/data/tablestore/exim_employee'
+	tblproperties("creator"="krishna")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: importer@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
+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: importer@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
+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: importer@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: query: import external table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+PREHOOK: type: IMPORT
+PREHOOK: Output: importer@exim_employee
+POSTHOOK: query: import external table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn
+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
+	 	 
+Detailed Table Information	Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1297311881, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:employee id), FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee, 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:[FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], parameters:{EXTERNAL=TRU
 E, transient_lastDdlTime=1297311881, comment=employee table, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-45_059_6909209042781624867/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-45_059_6909209042781624867/-mr-10000
+1	in	ka
+2	in	ka
+3	in	ka
+4	in	ka
+5	in	ka
+6	in	ka
+1	in	tn
+2	in	tn
+3	in	tn
+4	in	tn
+5	in	tn
+6	in	tn
+1	us	tn
+2	us	tn
+3	us	tn
+4	us	tn
+5	us	tn
+6	us	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-46_471_675401264716053845/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-46_471_675401264716053845/-mr-10000
+1	in	ka
+2	in	ka
+3	in	ka
+4	in	ka
+5	in	ka
+6	in	ka
+1	in	tn
+2	in	tn
+3	in	tn
+4	in	tn
+5	in	tn
+6	in	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-47_544_5706887558517343236/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-47_544_5706887558517343236/-mr-10000
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_16_part_external.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_16_part_external.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_16_part_external.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_16_part_external.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,169 @@
+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
+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@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
+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@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
+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@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
+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@emp_country=us/emp_state=ka
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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: create external 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	
+	location 'ql/test/data/tablestore2/exim_employee'
+	tblproperties("creator"="krishna")
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create external 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	
+	location 'ql/test/data/tablestore2/exim_employee'
+	tblproperties("creator"="krishna")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: importer@exim_employee
+PREHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+PREHOOK: type: IMPORT
+PREHOOK: Output: importer@exim_employee
+POSTHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn
+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
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore2/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311896000
+
+PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+PREHOOK: type: SHOW_TABLESTATUS
+POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+POSTHOOK: type: SHOW_TABLESTATUS
+tableName:exim_employee
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311896000
+
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-58_589_355277141333267470/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-58_589_355277141333267470/-mr-10000
+1	us	tn
+2	us	tn
+3	us	tn
+4	us	tn
+5	us	tn
+6	us	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-59_272_2192731616826734311/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-24-59_272_2192731616826734311/-mr-10000
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_17_part_managed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_17_part_managed.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_17_part_managed.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_17_part_managed.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,199 @@
+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
+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@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
+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@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
+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@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
+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@emp_country=us/emp_state=ka
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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: 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: importer@exim_employee
+PREHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+PREHOOK: type: IMPORT
+PREHOOK: Output: importer@exim_employee
+POSTHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: query: alter table exim_employee add partition	(emp_country="us", emp_state="ap")
+	location 'ql/test/data/tablestore2/exim_employee'
+PREHOOK: type: ALTERTABLE_ADDPARTS
+PREHOOK: Input: importer@exim_employee
+POSTHOOK: query: alter table exim_employee add partition	(emp_country="us", emp_state="ap")
+	location 'ql/test/data/tablestore2/exim_employee'
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Input: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=ap
+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
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311911000
+
+PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+PREHOOK: type: SHOW_TABLESTATUS
+POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+POSTHOOK: type: SHOW_TABLESTATUS
+tableName:exim_employee
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311911000
+
+PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="ap")
+PREHOOK: type: SHOW_TABLESTATUS
+POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="ap")
+POSTHOOK: type: SHOW_TABLESTATUS
+tableName:exim_employee
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee/ql/test/data/tablestore2/exim_employee
+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:0
+totalFileSize:0
+maxFileSize:0
+minFileSize:0
+lastAccessTime:0
+lastUpdateTime:1297311911000
+
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=ap
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-12_789_5115444616399592267/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=ap
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-12_789_5115444616399592267/-mr-10000
+1	us	tn
+2	us	tn
+3	us	tn
+4	us	tn
+5	us	tn
+6	us	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=ap
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-13_470_2748845658685044224/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=ap
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-13_470_2748845658685044224/-mr-10000
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_18_part_external.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_18_part_external.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_18_part_external.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_18_part_external.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,160 @@
+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
+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@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
+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@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
+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@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
+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@emp_country=us/emp_state=ka
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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 external table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+PREHOOK: type: IMPORT
+POSTHOOK: query: import external table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn
+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
+	 	 
+Detailed Table Information	Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1297311923, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:employee id), FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee, 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:[FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], parameters:{E
 XTERNAL=TRUE, transient_lastDdlTime=1297311923, comment=employee table, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
+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
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311923000
+
+PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+PREHOOK: type: SHOW_TABLESTATUS
+POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+POSTHOOK: type: SHOW_TABLESTATUS
+tableName:exim_employee
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee/emp_country=us/emp_state=tn
+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
+lastAccessTime:0
+lastUpdateTime:1297311923000
+
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-24_388_5054260398157668246/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-24_388_5054260398157668246/-mr-10000
+1	us	tn
+2	us	tn
+3	us	tn
+4	us	tn
+5	us	tn
+6	us	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-24_961_9069601697155977172/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-24_961_9069601697155977172/-mr-10000
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,162 @@
+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
+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@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
+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@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
+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@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
+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@emp_country=us/emp_state=ka
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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 external table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+PREHOOK: type: IMPORT
+POSTHOOK: query: import external table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn
+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
+	 	 
+Detailed Table Information	Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1297311933, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:employee id), FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee, 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:[FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], parameters:{EXTERNAL=TRU
 E, transient_lastDdlTime=1297311933, comment=employee table, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
+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
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311933000
+
+PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+PREHOOK: type: SHOW_TABLESTATUS
+POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+POSTHOOK: type: SHOW_TABLESTATUS
+tableName:exim_employee
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311933000
+
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-35_573_8990889008893531903/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-35_573_8990889008893531903/-mr-10000
+1	us	tn
+2	us	tn
+3	us	tn
+4	us	tn
+5	us	tn
+6	us	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-36_437_6556963932456314165/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-36_437_6556963932456314165/-mr-10000
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,162 @@
+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
+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@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
+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@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
+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@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
+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@emp_country=us/emp_state=ka
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka
+POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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 table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+PREHOOK: type: IMPORT
+POSTHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") 
+	from 'ql/test/data/exports/exim_employee'
+	location 'ql/test/data/tablestore/exim_employee'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_employee
+POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn
+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
+	 	 
+Detailed Table Information	Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1297311945, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:employee id), FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee, 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:[FieldSchema(name:emp_country, type:string, comment:two char iso code), FieldSchema(name:emp_state, type:string, comment:free text)], parameters:{transient_la
 stDdlTime=1297311945, comment=employee table, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
+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
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311945000
+
+PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+PREHOOK: type: SHOW_TABLESTATUS
+POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
+POSTHOOK: type: SHOW_TABLESTATUS
+tableName:exim_employee
+owner:krishnak
+location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/tablestore/exim_employee
+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
+lastAccessTime:0
+lastUpdateTime:1297311945000
+
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-47_558_2187446760557934156/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-47_558_2187446760557934156/-mr-10000
+1	us	tn
+2	us	tn
+3	us	tn
+4	us	tn
+5	us	tn
+6	us	tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-48_125_7485872489976729005/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-25-48_125_7485872489976729005/-mr-10000
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_21_export_authsuccess.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_21_export_authsuccess.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_21_export_authsuccess.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_21_export_authsuccess.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,32 @@
+PREHOOK: query: create table exim_department ( dep_id int) stored as textfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int) stored as textfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: type: LOAD
+POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: grant Select on table exim_department to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: grant Select on table exim_department to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: default@exim_department

Added: hive/trunk/ql/src/test/results/clientpositive/exim_22_import_exist_authsuccess.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_22_import_exist_authsuccess.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_22_import_exist_authsuccess.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_22_import_exist_authsuccess.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,83 @@
+PREHOOK: query: create table exim_department ( dep_id int) stored as textfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int) stored as textfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: type: LOAD
+POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: default@exim_department
+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: create table exim_department ( dep_id int) stored as textfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int) stored as textfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: grant Alter on table exim_department to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: grant Alter on table exim_department to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: grant Update on table exim_department to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: grant Update on table exim_department to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: import from 'ql/test/data/exports/exim_department'
+PREHOOK: type: IMPORT
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: import from 'ql/test/data/exports/exim_department'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-14_00-00-07_365_6010706614552343080/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-14_00-00-07_365_6010706614552343080/-mr-10000
+1
+2
+3
+4
+5
+6
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: drop database importer
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: drop database importer
+POSTHOOK: type: DROPDATABASE

Added: hive/trunk/ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,102 @@
+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
+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@emp_country=in/emp_state=tn
+PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee
+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: 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: importer@exim_employee
+PREHOOK: query: grant Alter on table exim_employee to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: importer@exim_employee
+POSTHOOK: query: grant Alter on table exim_employee to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: importer@exim_employee
+PREHOOK: query: grant Update on table exim_employee to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: importer@exim_employee
+POSTHOOK: query: grant Update on table exim_employee to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: importer@exim_employee
+PREHOOK: query: import from 'ql/test/data/exports/exim_employee'
+PREHOOK: type: IMPORT
+PREHOOK: Output: importer@exim_employee
+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=tn
+PREHOOK: query: select * from exim_employee
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-14_00-03-17_283_5671350203057752690/-mr-10000
+POSTHOOK: query: select * from exim_employee
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-14_00-03-17_283_5671350203057752690/-mr-10000
+1	in	tn
+2	in	tn
+3	in	tn
+4	in	tn
+5	in	tn
+6	in	tn
+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

Added: hive/trunk/ql/src/test/results/clientpositive/exim_24_import_nonexist_authsuccess.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_24_import_nonexist_authsuccess.q.out?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_24_import_nonexist_authsuccess.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_24_import_nonexist_authsuccess.q.out Tue Mar 15 20:29:02 2011
@@ -0,0 +1,69 @@
+PREHOOK: query: create table exim_department ( dep_id int) stored as textfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table exim_department ( dep_id int) stored as textfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: type: LOAD
+POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@exim_department
+PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@exim_department
+PREHOOK: Output: default@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@exim_department
+POSTHOOK: Output: default@exim_department
+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: grant Create on database importer to user hive_test_user
+PREHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: query: grant Create on database importer to user hive_test_user
+POSTHOOK: type: GRANT_PRIVILEGE
+PREHOOK: query: import from 'ql/test/data/exports/exim_department'
+PREHOOK: type: IMPORT
+POSTHOOK: query: import from 'ql/test/data/exports/exim_department'
+POSTHOOK: type: IMPORT
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: select * from exim_department
+PREHOOK: type: QUERY
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-28_03-23-10_804_4500507731598816674/-mr-10000
+POSTHOOK: query: select * from exim_department
+POSTHOOK: type: QUERY
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-28_03-23-10_804_4500507731598816674/-mr-10000
+1
+2
+3
+4
+5
+6
+PREHOOK: query: drop table exim_department
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: importer@exim_department
+PREHOOK: Output: importer@exim_department
+POSTHOOK: query: drop table exim_department
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: importer@exim_department
+POSTHOOK: Output: importer@exim_department
+PREHOOK: query: drop database importer
+PREHOOK: type: DROPDATABASE
+POSTHOOK: query: drop database importer
+POSTHOOK: type: DROPDATABASE



Mime
View raw message