You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/10/13 06:26:38 UTC
svn commit: r1021992 [2/13] - in /hadoop/hive/trunk: ./
contrib/src/test/results/clientpositive/ hbase-handler/src/test/queries/
hbase-handler/src/test/results/ hwi/src/test/org/apache/hadoop/hive/hwi/
jdbc/src/test/org/apache/hadoop/hive/jdbc/ ql/src/...
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_table.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_table.q?rev=1021992&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_table.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_table.q Wed Oct 13 04:26:34 2010
@@ -0,0 +1,19 @@
+describe srcpart;
+describe srcpart.key;
+describe srcpart PARTITION(ds='2008-04-08', hr='12');
+
+describe extended srcpart;
+describe extended srcpart.key;
+describe extended srcpart PARTITION(ds='2008-04-08', hr='12');
+
+describe formatted srcpart;
+describe formatted srcpart.key;
+describe formatted srcpart PARTITION(ds='2008-04-08', hr='12');
+
+create table srcpart_serdeprops like srcpart;
+alter table srcpart_serdeprops set serdeproperties('xyz'='0');
+alter table srcpart_serdeprops set serdeproperties('pqrs'='1');
+alter table srcpart_serdeprops set serdeproperties('abcd'='2');
+alter table srcpart_serdeprops set serdeproperties('A1234'='3');
+describe formatted srcpart_serdeprops;
+drop table srcpart_serdeprops;
Modified: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out Wed Oct 13 04:26:34 2010
@@ -32,41 +32,11 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode_no_drop partition (p='p1')
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-c1 string None
-c2 string None
-
-# Partition Information
-col_name data_type comment
-
-p string None
-
-# Detailed Partition Information
-Partition Value: [p1]
-Database: default
-Table: tbl_protectmode_no_drop
-CreateTime: Tue Sep 14 08:27:42 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: NO_DROP
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl_protectmode_no_drop/p=p1
-Partition Parameters:
- last_modified_by thiruvel
- last_modified_time 1284478062
- PROTECT_MODE NO_DROP
- transient_lastDdlTime 1284478062
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+c1 string
+c2 string
+p string
+Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl_protectmode_no_drop, createTime:1286801132, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:c1, type:string, comment:null), FieldSchema(name:c2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl_protectmode_no_drop/p=p1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{last_modified_by=thiruvel, last_modified_time=1286801132, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1286801132})
PREHOOK: query: alter table tbl_protectmode_no_drop drop partition (p='p1')
PREHOOK: type: ALTERTABLE_DROPPARTS
PREHOOK: Input: default@tbl_protectmode_no_drop
Modified: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out Wed Oct 13 04:26:34 2010
@@ -46,39 +46,8 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-col string None
-
-# Partition Information
-col_name data_type comment
-
-p string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:28:04 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: OFFLINE
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl_protectmode2
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284478084
- PROTECT_MODE OFFLINE
- transient_lastDdlTime 1284478084
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col string
+p string
+Detailed Table Information Table(tableName:tbl_protectmode2, dbName:default, owner:thiruvel, createTime:1286801076, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl_protectmode2, 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:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286801077, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286801077}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode2
Modified: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out Wed Oct 13 04:26:34 2010
@@ -14,11 +14,11 @@ POSTHOOK: Output: default@tbl_protectmod
PREHOOK: query: select col from tbl_protectmode_4
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl_protectmode_4
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-28-23_139_4654751823762752374/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-49-17_303_4577482854819832625/-mr-10000
POSTHOOK: query: select col from tbl_protectmode_4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl_protectmode_4
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-28-23_139_4654751823762752374/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-49-17_303_4577482854819832625/-mr-10000
PREHOOK: query: alter table tbl_protectmode_4 enable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl_protectmode_4
@@ -31,34 +31,7 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode_4
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-col string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:28:23 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: OFFLINE
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl_protectmode_4
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284478106
- PROTECT_MODE OFFLINE
- transient_lastDdlTime 1284478106
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col string
+Detailed Table Information Table(tableName:tbl_protectmode_4, dbName:default, owner:thiruvel, createTime:1286826557, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl_protectmode_4, 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:{last_modified_by=thiruvel, last_modified_time=1286826559, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286826559}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_4
Modified: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out Wed Oct 13 04:26:34 2010
@@ -55,39 +55,8 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode_tbl4
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-col string None
-
-# Partition Information
-col_name data_type comment
-
-p string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:29:03 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: OFFLINE
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl_protectmode_tbl4
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284478143
- PROTECT_MODE OFFLINE
- transient_lastDdlTime 1284478143
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col string
+p string
+Detailed Table Information Table(tableName:tbl_protectmode_tbl4, dbName:default, owner:thiruvel, createTime:1286826591, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl_protectmode_tbl4, 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:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286826591, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286826591}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_tbl4
Modified: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out Wed Oct 13 04:26:34 2010
@@ -55,39 +55,8 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode_tbl5
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-col string None
-
-# Partition Information
-col_name data_type comment
-
-p string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:29:35 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: OFFLINE
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl_protectmode_tbl5
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284478175
- PROTECT_MODE OFFLINE
- transient_lastDdlTime 1284478175
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col string
+p string
+Detailed Table Information Table(tableName:tbl_protectmode_tbl5, dbName:default, owner:thiruvel, createTime:1286801159, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl_protectmode_tbl5, 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:p, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286801160, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1286801160}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_tbl5
Modified: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out Wed Oct 13 04:26:34 2010
@@ -14,11 +14,11 @@ POSTHOOK: Output: default@tbl_protectmod
PREHOOK: query: select * from tbl_protectmode__no_drop
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl_protectmode__no_drop
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-39-31_893_2625855232363516041/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-45-04_369_4648158927464835768/-mr-10000
POSTHOOK: query: select * from tbl_protectmode__no_drop
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl_protectmode__no_drop
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-39-31_893_2625855232363516041/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-45-04_369_4648158927464835768/-mr-10000
PREHOOK: query: alter table tbl_protectmode__no_drop enable no_drop
PREHOOK: type: ALTERTABLE_PROTECTMODE
PREHOOK: Input: default@tbl_protectmode__no_drop
@@ -31,36 +31,9 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode__no_drop
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-col string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:39:31 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: NO_DROP
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/tbl_protectmode__no_drop
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284478771
- PROTECT_MODE NO_DROP
- transient_lastDdlTime 1284478771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+col string
+Detailed Table Information Table(tableName:tbl_protectmode__no_drop, dbName:default, owner:thiruvel, createTime:1286801104, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/tbl_protectmode__no_drop, 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:{last_modified_by=thiruvel, last_modified_time=1286801104, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1286801104}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: drop table tbl_protectmode__no_drop
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@tbl_protectmode__no_drop
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out Wed Oct 13 04:26:34 2010
@@ -7,34 +7,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472770
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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=1286798957}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='3')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@alter1
@@ -47,38 +23,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- c 3
- last_modified_time 1284472770
- a 1
- transient_lastDdlTime 1284472770
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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:{last_modified_by=thiruvel, c=3, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='4', 'd'='3')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@alter1
@@ -91,39 +39,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472771
- a 1
- transient_lastDdlTime 1284472771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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:{d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='TRUE')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@alter1
@@ -136,40 +55,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472771
- a 1
- transient_lastDdlTime 1284472771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='FALSE')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@alter1
@@ -182,40 +71,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472771
- a 1
- transient_lastDdlTime 1284472771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set serdeproperties('s1'='9')
PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
PREHOOK: Input: default@alter1
@@ -228,41 +87,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472771
- a 1
- transient_lastDdlTime 1284472771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s1 9
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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:{s1=9, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set serdeproperties('s1'='10', 's2' ='20')
PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
PREHOOK: Input: default@alter1
@@ -275,42 +103,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472771
- a 1
- transient_lastDdlTime 1284472771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s2 20
- s1 10
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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:{s2=20, s1=10, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.TestSerDe' with serdeproperties('s1'='9')
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: default@alter1
@@ -323,42 +119,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string from deserializer
-b string from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472771
- a 1
- transient_lastDdlTime 1284472771
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.TestSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s2 20
- s1 9
- serialization.format 1
+a string from deserializer
+b string from deserializer
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:from deserializer), FieldSchema(name:b, type:int, comment:from deserializer)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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.TestSerDe, parameters:{s2=20, s1=9, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: default@alter1
@@ -371,42 +135,10 @@ PREHOOK: query: describe extended alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string from deserializer
-b string from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:30 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472772
- a 1
- transient_lastDdlTime 1284472772
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s2 20
- s1 9
- serialization.format 1
+a string from deserializer
+b string from deserializer
+Detailed Table Information Table(tableName:alter1, dbName:default, owner:thiruvel, createTime:1286798957, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:from deserializer), FieldSchema(name:b, type:string, comment:from deserializer)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1, 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:{s2=20, s1=9, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798958, a=1, transient_lastDdlTime=1286798958}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter1 replace columns (a int, b int, c string)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@alter1
@@ -419,11 +151,9 @@ PREHOOK: query: describe alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-c string None
+a int
+b int
+c string
PREHOOK: query: -- Cleanup
DROP TABLE alter1
PREHOOK: type: DROPTABLE
@@ -471,34 +201,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284472772
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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=1286798959}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: alter1_db@alter1
@@ -511,38 +217,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- c 3
- last_modified_time 1284472772
- a 1
- transient_lastDdlTime 1284472772
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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:{last_modified_by=thiruvel, c=3, last_modified_time=1286798959, a=1, transient_lastDdlTime=1286798959}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: alter1_db@alter1
@@ -555,39 +233,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472772
- a 1
- transient_lastDdlTime 1284472772
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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:{d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798959, a=1, transient_lastDdlTime=1286798959}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: alter1_db@alter1
@@ -600,40 +249,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472773
- a 1
- transient_lastDdlTime 1284472773
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798960, a=1, transient_lastDdlTime=1286798960}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: alter1_db@alter1
@@ -646,40 +265,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472773
- a 1
- transient_lastDdlTime 1284472773
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798960, a=1, transient_lastDdlTime=1286798960}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9')
PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
PREHOOK: Input: alter1_db@alter1
@@ -692,41 +281,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472773
- a 1
- transient_lastDdlTime 1284472773
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s1 9
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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:{s1=9, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798960, a=1, transient_lastDdlTime=1286798960}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20')
PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
PREHOOK: Input: alter1_db@alter1
@@ -739,42 +297,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472773
- a 1
- transient_lastDdlTime 1284472773
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s2 20
- s1 10
- serialization.format 1
+a int
+b int
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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:{s2=20, s1=10, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798960, a=1, transient_lastDdlTime=1286798960}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9')
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: alter1_db@alter1
@@ -787,42 +313,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string from deserializer
-b string from deserializer
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472773
- a 1
- transient_lastDdlTime 1284472773
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.TestSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s2 20
- s1 9
- serialization.format 1
+a string from deserializer
+b string from deserializer
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:from deserializer), FieldSchema(name:b, type:int, comment:from deserializer)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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.TestSerDe, parameters:{s2=20, s1=9, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798960, a=1, transient_lastDdlTime=1286798960}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: alter1_db@alter1
@@ -835,42 +329,10 @@ PREHOOK: query: DESCRIBE EXTENDED alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string from deserializer
-b string from deserializer
-
-# Detailed Table Information
-Database: alter1_db
-Owner: thiruvel
-CreateTime: Tue Sep 14 06:59:32 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/alter1_db.db/alter1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- d 3
- last_modified_by thiruvel
- c 4
- last_modified_time 1284472773
- a 1
- transient_lastDdlTime 1284472773
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- s2 20
- s1 9
- serialization.format 1
+a string from deserializer
+b string from deserializer
+Detailed Table Information Table(tableName:alter1, dbName:alter1_db, owner:thiruvel, createTime:1286798959, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:from deserializer), FieldSchema(name:b, type:string, comment:from deserializer)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter1_db.db/alter1, 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:{s2=20, s1=9, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, d=3, last_modified_by=thiruvel, c=4, last_modified_time=1286798960, a=1, transient_lastDdlTime=1286798960}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: alter1_db@alter1
@@ -883,11 +345,9 @@ PREHOOK: query: DESCRIBE alter1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE alter1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b int None
-c string None
+a int
+b int
+c string
PREHOOK: query: DROP TABLE alter1
PREHOOK: type: DROPTABLE
PREHOOK: Input: alter1_db@alter1