You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2011/03/23 00:05:53 UTC
svn commit: r1084403 [8/26] - in /hive/trunk:
contrib/src/test/results/clientpositive/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/org/apache/hadoop/hive/ql/
ql/src/test/org/apache/hadoop/hive/ql/hooks/
ql/src/test/queries/clientnegative/ ...
Modified: hive/trunk/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out Tue Mar 22 23:05:48 2011
@@ -9,6 +9,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -49,8 +50,10 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: importer@exim_department
PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr")
PREHOOK: type: LOAD
+PREHOOK: Output: importer@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr")
POSTHOOK: type: LOAD
+POSTHOOK: Output: importer@exim_department
POSTHOOK: Output: importer@exim_department@emp_org=hr
PREHOOK: query: import table exim_imported_dept from 'ql/test/data/exports/exim_department'
PREHOOK: type: IMPORT
@@ -63,15 +66,15 @@ POSTHOOK: query: describe extended exim_
POSTHOOK: type: DESCTABLE
dep_id int department id
-Detailed Table Information Table(tableName:exim_imported_dept, dbName:importer, owner:krishnak, createTime:1297311833, 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/warehouse/importer.db/exim_imported_dept, 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=1297311833, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:exim_imported_dept, dbName:importer, owner:krishnak, createTime:1300687478, 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/warehouse/importer.db/exim_imported_dept, 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=1300687478, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: select * from exim_imported_dept
PREHOOK: type: QUERY
PREHOOK: Input: importer@exim_imported_dept
-PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-23-53_534_7978114572288929896/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-39_058_186230401741920612/-mr-10000
POSTHOOK: query: select * from exim_imported_dept
POSTHOOK: type: QUERY
POSTHOOK: Input: importer@exim_imported_dept
-POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-23-53_534_7978114572288929896/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-39_058_186230401741920612/-mr-10000
1
2
3
Modified: hive/trunk/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -85,16 +93,20 @@ 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
+PREHOOK: Output: importer@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: importer@exim_employee
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
+PREHOOK: Output: importer@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: importer@exim_employee
POSTHOOK: Output: importer@exim_employee@emp_country=in/emp_state=ka
PREHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") from 'ql/test/data/exports/exim_employee'
PREHOOK: type: IMPORT
@@ -111,19 +123,19 @@ 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:1297311841, 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:{t
ransient_lastDdlTime=1297311841, comment=employee table, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1300687487, 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:{t
ransient_lastDdlTime=1300687487, comment=employee table, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_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-05_292_3512220822479977509/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-50_611_7580679127146676754/-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-05_292_3512220822479977509/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-50_611_7580679127146676754/-mr-10000
1 in ka
2 in ka
3 in ka
Modified: hive/trunk/ql/src/test/results/clientpositive/exim_10_external_managed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_10_external_managed.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_10_external_managed.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_10_external_managed.q.out Tue Mar 22 23:05:48 2011
@@ -11,6 +11,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -49,15 +50,15 @@ POSTHOOK: query: describe extended exim_
POSTHOOK: type: DESCTABLE
dep_id int department id
-Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1297311850, 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/warehouse/importer.db/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=1297311850, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1300687494, 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/warehouse/importer.db/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=1300687495, 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-11_046_5970786275700796779/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-55_356_1905411135769375175/-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-11_046_5970786275700796779/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-55_356_1905411135769375175/-mr-10000
1
2
3
Modified: hive/trunk/ql/src/test/results/clientpositive/exim_11_managed_external.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exim_11_managed_external.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_11_managed_external.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_11_managed_external.q.out Tue Mar 22 23:05:48 2011
@@ -9,6 +9,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -47,15 +48,15 @@ POSTHOOK: query: describe extended exim_
POSTHOOK: type: DESCTABLE
dep_id int department id
-Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1297311855, 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/exports/exim_department/data, 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=1297311855, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
+Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1300687498, 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/exports/exim_department/data, 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=1300687498, 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-15_330_6571782447593980221/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-58_567_7410710628150490263/-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-15_330_6571782447593980221/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-58_567_7410710628150490263/-mr-10000
1
2
3
@@ -65,11 +66,11 @@ POSTHOOK: Output: file:/var/folders/67/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-15_817_5011777220631967141/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-58_978_1822311369735454326/-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-15_817_5011777220631967141/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-58_978_1822311369735454326/-mr-10000
PREHOOK: query: drop table exim_department
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_department
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_12_external_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_12_external_location.q.out Tue Mar 22 23:05:48 2011
@@ -9,6 +9,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -49,15 +50,15 @@ POSTHOOK: query: describe extended exim_
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)
+Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1300687502, 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=1300687502, 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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-02_657_1576955936784944413/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-02_657_1576955936784944413/-mr-10000
1
2
3
@@ -67,11 +68,11 @@ POSTHOOK: Output: file:/var/folders/67/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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-03_041_1175787370939755977/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-03_041_1175787370939755977/-mr-10000
PREHOOK: query: drop table exim_department
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_department
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_13_managed_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_13_managed_location.q.out Tue Mar 22 23:05:48 2011
@@ -9,6 +9,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -49,15 +50,15 @@ POSTHOOK: query: describe extended exim_
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)
+Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1300687506, 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=1300687506, 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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-06_765_5973671583560359249/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-06_765_5973671583560359249/-mr-10000
1
2
3
@@ -67,11 +68,11 @@ POSTHOOK: Output: file:/var/folders/67/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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-07_167_214817465974227073/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-07_167_214817465974227073/-mr-10000
PREHOOK: query: drop table exim_department
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_department
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out Tue Mar 22 23:05:48 2011
@@ -9,6 +9,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -61,15 +62,15 @@ POSTHOOK: query: describe extended exim_
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)
+Detailed Table Information Table(tableName:exim_department, dbName:importer, owner:krishnak, createTime:1300687510, 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=1300687511, 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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-11_648_1899614072077938556/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-11_648_1899614072077938556/-mr-10000
1
2
3
@@ -79,11 +80,11 @@ POSTHOOK: Output: file:/var/folders/67/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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-12_051_8732641988387565382/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-12_051_8732641988387565382/-mr-10000
PREHOOK: query: drop table exim_department
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_department
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_15_external_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_15_external_part.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -87,16 +95,20 @@ 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
+PREHOOK: Output: importer@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: importer@exim_employee
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
+PREHOOK: Output: importer@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: importer@exim_employee
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'
@@ -115,19 +127,19 @@ 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)
+Detailed Table Information Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1300687519, 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=1300687519, 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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-21_814_44116951106898433/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-21_814_44116951106898433/-mr-10000
1 in ka
2 in ka
3 in ka
@@ -151,13 +163,13 @@ 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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-22_840_34152298807300339/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-22_840_34152298807300339/-mr-10000
1 in ka
2 in ka
3 in ka
@@ -175,13 +187,13 @@ 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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-23_605_5011311401480577512/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-23_605_5011311401480577512/-mr-10000
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_16_part_external.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_16_part_external.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -112,7 +120,7 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311896000
+lastUpdateTime:1300687531000
PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
PREHOOK: type: SHOW_TABLESTATUS
@@ -131,16 +139,16 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311896000
+lastUpdateTime:1300687531000
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-33_242_2069790469960012209/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-33_242_2069790469960012209/-mr-10000
1 us tn
2 us tn
3 us tn
@@ -150,11 +158,11 @@ POSTHOOK: Output: file:/var/folders/67/6
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-33_670_6520768883477019932/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-33_670_6520768883477019932/-mr-10000
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_17_part_managed.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_17_part_managed.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -119,7 +127,7 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311911000
+lastUpdateTime:1300687544000
PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
PREHOOK: type: SHOW_TABLESTATUS
@@ -138,7 +146,7 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311911000
+lastUpdateTime:1300687544000
PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="ap")
PREHOOK: type: SHOW_TABLESTATUS
@@ -157,18 +165,18 @@ totalFileSize:0
maxFileSize:0
minFileSize:0
lastAccessTime:0
-lastUpdateTime:1297311911000
+lastUpdateTime:1300687544000
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-45_872_2295546425332520435/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-45_872_2295546425332520435/-mr-10000
1 us tn
2 us tn
3 us tn
@@ -179,12 +187,12 @@ PREHOOK: query: select * from exim_emplo
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-46_452_3721058422540607259/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-46_452_3721058422540607259/-mr-10000
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_18_part_external.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_18_part_external.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -85,7 +93,7 @@ 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)
+Detailed Table Information Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1300687554, 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=1300687554, 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
@@ -103,7 +111,7 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311923000
+lastUpdateTime:1300687554000
PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
PREHOOK: type: SHOW_TABLESTATUS
@@ -122,16 +130,16 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311923000
+lastUpdateTime:1300687554000
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-55_767_8021001971642396943/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-55_767_8021001971642396943/-mr-10000
1 us tn
2 us tn
3 us tn
@@ -141,11 +149,11 @@ POSTHOOK: Output: file:/var/folders/67/6
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-56_596_7770446406711795282/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-05-56_596_7770446406711795282/-mr-10000
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -87,7 +95,7 @@ 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)
+Detailed Table Information Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1300687566, 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=1300687566, 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
@@ -105,7 +113,7 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311933000
+lastUpdateTime:1300687566000
PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
PREHOOK: type: SHOW_TABLESTATUS
@@ -124,16 +132,16 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311933000
+lastUpdateTime:1300687566000
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-08_034_5207279408749500952/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-08_034_5207279408749500952/-mr-10000
1 us tn
2 us tn
3 us tn
@@ -143,11 +151,11 @@ POSTHOOK: Output: file:/var/folders/67/6
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-08_473_8465103105154613288/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-08_473_8465103105154613288/-mr-10000
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out Tue Mar 22 23:05:48 2011
@@ -14,30 +14,38 @@ 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
PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -87,7 +95,7 @@ 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)
+Detailed Table Information Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1300687576, 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=1300687576, 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
@@ -105,7 +113,7 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311945000
+lastUpdateTime:1300687576000
PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn")
PREHOOK: type: SHOW_TABLESTATUS
@@ -124,16 +132,16 @@ totalFileSize:11
maxFileSize:11
minFileSize:11
lastAccessTime:0
-lastUpdateTime:1297311945000
+lastUpdateTime:1300687576000
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-18_296_2547895768154607388/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-18_296_2547895768154607388/-mr-10000
1 us tn
2 us tn
3 us tn
@@ -143,11 +151,11 @@ POSTHOOK: Output: file:/var/folders/67/6
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-18_734_6806561011489840847/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-18_734_6806561011489840847/-mr-10000
PREHOOK: query: drop table exim_employee
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_21_export_authsuccess.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_21_export_authsuccess.q.out Tue Mar 22 23:05:48 2011
@@ -5,6 +5,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_22_import_exist_authsuccess.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_22_import_exist_authsuccess.q.out Tue Mar 22 23:05:48 2011
@@ -5,6 +5,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -58,11 +59,11 @@ POSTHOOK: Output: importer@exim_departme
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-25_010_1054828341958963947/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-25_010_1054828341958963947/-mr-10000
1
2
3
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out Tue Mar 22 23:05:48 2011
@@ -14,9 +14,11 @@ 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: export table exim_employee to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
@@ -77,11 +79,11 @@ POSTHOOK: Output: importer@exim_employee
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-29_579_3101914741756010408/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-29_579_3101914741756010408/-mr-10000
1 in tn
2 in tn
3 in tn
Modified: 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=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exim_24_import_nonexist_authsuccess.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exim_24_import_nonexist_authsuccess.q.out Tue Mar 22 23:05:48 2011
@@ -5,6 +5,7 @@ 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
+PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
@@ -44,11 +45,11 @@ POSTHOOK: Output: importer@exim_departme
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
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-33_608_3825518513638087885/-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
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-33_608_3825518513638087885/-mr-10000
1
2
3
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out Tue Mar 22 23:05:48 2011
@@ -15,6 +15,7 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@INPUT
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv5.txt' INTO TABLE INPUT
PREHOOK: type: LOAD
+PREHOOK: Output: default@input
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv5.txt' INTO TABLE INPUT
POSTHOOK: type: LOAD
POSTHOOK: Output: default@input
@@ -97,7 +98,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/sdong/hive_2011-02-10_01-48-37_938_8059876075925675779/-mr-10004
+ file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-10-37_844_2784636939771236613/-mr-10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -166,7 +167,7 @@ STAGE PLANS:
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/sdong/hive_2011-02-10_01-48-37_938_8059876075925675779/-mr-10005
+ file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-10-37_844_2784636939771236613/-mr-10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -256,11 +257,11 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
PREHOOK: query: SELECT * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-48-50_240_8214998084538575911/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-11-13_750_3405393267317215329/-mr-10000
POSTHOOK: query: SELECT * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-48-50_240_8214998084538575911/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-11-13_750_3405393267317215329/-mr-10000
POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
@@ -290,11 +291,11 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
PREHOOK: query: SELECT * from dest2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-48-50_510_3820874581577425988/-mr-10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-11-14_211_4036618129486956421/-mr-10000
POSTHOOK: query: SELECT * from dest2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-48-50_510_3820874581577425988/-mr-10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-11-14_211_4036618129486956421/-mr-10000
POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/input16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input16.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input16.q.out Tue Mar 22 23:05:48 2011
@@ -11,17 +11,18 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@INPUT16
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT16
PREHOOK: type: LOAD
+PREHOOK: Output: default@input16
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT16
POSTHOOK: type: LOAD
POSTHOOK: Output: default@input16
PREHOOK: query: SELECT INPUT16.VALUE, INPUT16.KEY FROM INPUT16
PREHOOK: type: QUERY
PREHOOK: Input: default@input16
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_14-10-01_833_5335657696200375421/10000
+PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-41-31_315_1869868779617811264/-mr-10000
POSTHOOK: query: SELECT INPUT16.VALUE, INPUT16.KEY FROM INPUT16
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input16
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_14-10-01_833_5335657696200375421/10000
+POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-41-31_315_1869868779617811264/-mr-10000
val_238 238
val_86 86
val_311 311
Modified: hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out Tue Mar 22 23:05:48 2011
@@ -15,17 +15,18 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@INPUT16_CC
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1_cc.txt' INTO TABLE INPUT16_CC
PREHOOK: type: LOAD
+PREHOOK: Output: default@input16_cc
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1_cc.txt' INTO TABLE INPUT16_CC
POSTHOOK: type: LOAD
POSTHOOK: Output: default@input16_cc
PREHOOK: query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
PREHOOK: type: QUERY
PREHOOK: Input: default@input16_cc
-PREHOOK: Output: hdfs://localhost:55610/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/scratchdir/hive_2011-02-03_13-05-07_586_2987322822515306543/-mr-10000
+PREHOOK: Output: hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-59-14_261_2591774849958533018/-mr-10000
POSTHOOK: query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input16_cc
-POSTHOOK: Output: hdfs://localhost:55610/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/scratchdir/hive_2011-02-03_13-05-07_586_2987322822515306543/-mr-10000
+POSTHOOK: Output: hdfs://localhost.localdomain:48956/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-59-14_261_2591774849958533018/-mr-10000
val_238 238
val_86 86
val_311 311