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 2010/09/20 22:22:25 UTC
svn commit: r999101 [6/9] - in /hadoop/hive/trunk: ./
contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/
hwi/src/test/org/apache/hadoop/hive/hwi/
jdbc/src/test/org/apache/hadoop/hive/jdbc/
ql/src/java/org/apache/hadoop/hive/ql/exe...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out Mon Sep 20 20:22:22 2010
@@ -7,10 +7,35 @@ PREHOOK: query: desc extended T1
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended T1
POSTHOOK: type: DESCTABLE
-key string default
-value string default
+col_name data_type comment
+
+key string default
+value string default
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:14:46 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/t1
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284477286
+
+# 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
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, 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, transient_lastDdlTime=1279736455}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -27,10 +52,35 @@ POSTHOOK: query: desc extended T1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
+col_name data_type comment
+
+key string default
+value string default
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:14:46 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/t1
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284477290
+
+# 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
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, 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, transient_lastDdlTime=1279736459}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select /*+ HOLD_DDLTIME*/ * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -51,10 +101,35 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
+col_name data_type comment
+
+key string default
+value string default
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:14:46 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/t1
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284477290
+
+# 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
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, 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, transient_lastDdlTime=1279736459}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -79,10 +154,35 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
+col_name data_type comment
+
+key string default
+value string default
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:14:46 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/t1
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284477296
+
+# 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
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, 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, transient_lastDdlTime=1279736467}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: create table if not exists T2 like srcpart
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table if not exists T2 like srcpart
@@ -104,12 +204,41 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
-ds string
-hr string
+col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:14:57 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/t2
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ transient_lastDdlTime 1284477297
+
+# 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
-Detailed Table Information Table(tableName:t2, dbName:default, owner:null, createTime:1279736467, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2, 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:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1279736467}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T2 partition (ds = '2010-06-21', hr = '1') select key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -138,12 +267,39 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
-ds string
-hr string
+col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Partition Information
+Partition Value: [2010-06-21, 1]
+Database: default
+Table: t2
+CreateTime: Tue Sep 14 08:15:00 PDT 2010
+LastAccessTime: Wed Dec 31 16:00:00 PST 1969
+Protect Mode: None
+Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1
+Partition Parameters:
+ transient_lastDdlTime 1284477300
+
+# 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
-Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1279736471, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, 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:{transient_lastDdlTime=1279736471})
PREHOOK: query: insert overwrite table T2 partition (ds = '2010-06-21', hr='1') select /*+ HOLD_DDLTIME */ key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -176,12 +332,39 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
-ds string
-hr string
+col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Partition Information
+Partition Value: [2010-06-21, 1]
+Database: default
+Table: t2
+CreateTime: Tue Sep 14 08:15:00 PDT 2010
+LastAccessTime: Wed Dec 31 16:00:00 PST 1969
+Protect Mode: None
+Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1
+Partition Parameters:
+ transient_lastDdlTime 1284477300
+
+# 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
-Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1279736471, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, 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:{transient_lastDdlTime=1279736471})
PREHOOK: query: insert overwrite table T2 partition (ds='2010-06-01', hr='1') select key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -218,9 +401,36 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-key string default
-value string default
-ds string
-hr string
+col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Partition Information
+Partition Value: [2010-06-01, 1]
+Database: default
+Table: t2
+CreateTime: Tue Sep 14 08:15:08 PDT 2010
+LastAccessTime: Wed Dec 31 16:00:00 PST 1969
+Protect Mode: None
+Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/t2/ds=2010-06-01/hr=1
+Partition Parameters:
+ transient_lastDdlTime 1284477308
+
+# 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
-Detailed Partition Information Partition(values:[2010-06-01, 1], dbName:default, tableName:t2, createTime:1279736478, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2/ds=2010-06-01/hr=1, 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:{transient_lastDdlTime=1279736478})
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out Mon Sep 20 20:22:22 2010
@@ -4,41 +4,53 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a list structure in a thrift table
describe src_thrift.lint
POSTHOOK: type: DESCTABLE
-lint array<int> from deserializer
+col_name data_type comment
+
+lint array<int> from deserializer
PREHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
POSTHOOK: type: DESCTABLE
-$elem$ int from deserializer
+col_name data_type comment
+
+$elem$ int from deserializer
PREHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
POSTHOOK: type: DESCTABLE
-$key$ string from deserializer
+col_name data_type comment
+
+$key$ string from deserializer
PREHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
POSTHOOK: type: DESCTABLE
-$value$ string from deserializer
+col_name data_type comment
+
+$value$ string from deserializer
PREHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
POSTHOOK: type: DESCTABLE
-myint int from deserializer
-mystring string from deserializer
-underscore_int int from deserializer
+col_name data_type comment
+
+myint int from deserializer
+mystring string from deserializer
+underscore_int int from deserializer
PREHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
POSTHOOK: type: DESCTABLE
-myint int from deserializer
+col_name data_type comment
+
+myint int from deserializer
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Mon Sep 20 20:22:22 2010
@@ -40,10 +40,34 @@ PREHOOK: query: DESCRIBE EXTENDED dest1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED dest1
POSTHOOK: type: DESCTABLE
-key int
-value string
+col_name data_type comment
+
+key int None
+value string None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:16:05 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/dest1
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477365
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
-Detailed Table Information Table(tableName:dest1, dbName:default, owner:jssarma, createTime:1279736511, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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=1279736511}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
@@ -59,11 +83,11 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-53_917_3907368248535068834/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-08_426_1865933645353720968/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-53_917_3907368248535068834/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-08_426_1865933645353720968/-mr-10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out Mon Sep 20 20:22:22 2010
@@ -40,10 +40,34 @@ PREHOOK: query: DESCRIBE EXTENDED dest1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED dest1
POSTHOOK: type: DESCTABLE
-key int
-value string
+col_name data_type comment
+
+key int None
+value string None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:16:51 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/dest1
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477411
+
+# 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
-Detailed Table Information Table(tableName:dest1, dbName:default, owner:jssarma, createTime:1279736514, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/dest1, 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=1279736514}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
@@ -59,11 +83,11 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-57_089_3981013039375138901/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-54_460_1149384812640316385/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-57_089_3981013039375138901/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-54_460_1149384812640316385/-mr-10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out Mon Sep 20 20:22:22 2010
@@ -30,11 +30,35 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_2__
POSTHOOK: type: DESCTABLE
-key string default
-_bucketname string
-_offsets array<bigint>
+col_name data_type comment
+
+key string default
+_bucketname string
+_offsets array<bigint>
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:20:33 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/default__src_src_index_2__
+Table Type: INDEX_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477633
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: [Order(col:key, order:1)]
+Storage Desc Params:
+ serialization.format 1
-Detailed Table Information Table(tableName:default__src_src_index_2__, dbName:default, owner:null, createTime:1280432672, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/default__src_src_index_2__, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1280432672}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: create index src_index_3 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_3
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_3 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_3
@@ -43,11 +67,35 @@ PREHOOK: query: desc extended src_idx_sr
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended src_idx_src_index_3
POSTHOOK: type: DESCTABLE
-key string default
-_bucketname string
-_offsets array<bigint>
+col_name data_type comment
+
+key string default
+_bucketname string
+_offsets array<bigint>
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:20:33 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/src_idx_src_index_3
+Table Type: INDEX_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477633
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: [Order(col:key, order:1)]
+Storage Desc Params:
+ serialization.format 1
-Detailed Table Information Table(tableName:src_idx_src_index_3, dbName:default, owner:null, createTime:1280432673, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/src_idx_src_index_3, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1280432673}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: create index src_index_4 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_4 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
@@ -56,11 +104,36 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_4__
POSTHOOK: type: DESCTABLE
-key string default
-_bucketname string
-_offsets array<bigint>
+col_name data_type comment
+
+key string default
+_bucketname string
+_offsets array<bigint>
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:20:33 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/default__src_src_index_4__
+Table Type: INDEX_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477633
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: [Order(col:key, order:1)]
+Storage Desc Params:
+ serialization.format \t
+ field.delim \t
-Detailed Table Information Table(tableName:default__src_src_index_4__, dbName:default, owner:null, createTime:1280432673, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/default__src_src_index_4__, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format= , field.delim=
PREHOOK: query: create index src_index_5 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\'
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_5 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\'
@@ -69,11 +142,37 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_5__
POSTHOOK: type: DESCTABLE
-key string default
-_bucketname string
-_offsets array<bigint>
+col_name data_type comment
+
+key string default
+_bucketname string
+_offsets array<bigint>
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:20:33 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/default__src_src_index_5__
+Table Type: INDEX_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477633
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: [Order(col:key, order:1)]
+Storage Desc Params:
+ escape.delim \\
+ serialization.format \t
+ field.delim \t
-Detailed Table Information Table(tableName:default__src_src_index_5__, dbName:default, owner:null, createTime:1280432673, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/default__src_src_index_5__, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{escape.delim=\, serialization.format= , field.delim=
PREHOOK: query: create index src_index_6 on table src(key) as 'compact' WITH DEFERRED REBUILD STORED AS RCFILE
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_6 on table src(key) as 'compact' WITH DEFERRED REBUILD STORED AS RCFILE
@@ -82,11 +181,35 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_6__
POSTHOOK: type: DESCTABLE
-key string from deserializer
-_bucketname string from deserializer
-_offsets array<bigint> from deserializer
+col_name data_type comment
+
+key string from deserializer
+_bucketname string from deserializer
+_offsets array<bigint> from deserializer
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:20:34 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/default__src_src_index_6__
+Table Type: INDEX_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477634
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: [Order(col:key, order:1)]
+Storage Desc Params:
+ serialization.format 1
-Detailed Table Information Table(tableName:default__src_src_index_6__, dbName:default, owner:null, createTime:1280432673, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/default__src_src_index_6__, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1280432673}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: create index src_index_7 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_7 STORED AS RCFILE
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_7 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_7 STORED AS RCFILE
@@ -95,11 +218,35 @@ PREHOOK: query: desc extended src_idx_sr
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended src_idx_src_index_7
POSTHOOK: type: DESCTABLE
-key string from deserializer
-_bucketname string from deserializer
-_offsets array<bigint> from deserializer
+col_name data_type comment
+
+key string from deserializer
+_bucketname string from deserializer
+_offsets array<bigint> from deserializer
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Sep 14 08:20:34 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/src_idx_src_index_7
+Table Type: INDEX_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477634
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: [Order(col:key, order:1)]
+Storage Desc Params:
+ serialization.format 1
-Detailed Table Information Table(tableName:src_idx_src_index_7, dbName:default, owner:null, createTime:1280432673, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/src_idx_src_index_7, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1280432673}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: drop index src_index_2 on src
PREHOOK: type: DROPINDEX
POSTHOOK: query: drop index src_index_2 on src
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out Mon Sep 20 20:22:22 2010
@@ -31,5 +31,7 @@ PREHOOK: query: DESCRIBE TEST1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST1
POSTHOOK: type: DESCTABLE
-a int
-b double
+col_name data_type comment
+
+a int None
+b double None
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out Mon Sep 20 20:22:22 2010
@@ -31,7 +31,13 @@ PREHOOK: query: DESCRIBE TEST10
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST10
POSTHOOK: type: DESCTABLE
-key int
-value string
-ds string
-hr string
+col_name data_type comment
+
+key int None
+value string None
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+hr string None
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out Mon Sep 20 20:22:22 2010
@@ -33,5 +33,7 @@ PREHOOK: query: DESCRIBE TEST15
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST15
POSTHOOK: type: DESCTABLE
-key int
-value string
+col_name data_type comment
+
+key int None
+value string None
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out Mon Sep 20 20:22:22 2010
@@ -7,14 +7,18 @@ PREHOOK: query: DESCRIBE TEST2a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST2a
POSTHOOK: type: DESCTABLE
-a int
-b double
+col_name data_type comment
+
+a int None
+b double None
PREHOOK: query: DESC TEST2a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESC TEST2a
POSTHOOK: type: DESCTABLE
-a int
-b double
+col_name data_type comment
+
+a int None
+b double None
PREHOOK: query: CREATE TABLE TEST2b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE TEST2b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
@@ -24,9 +28,11 @@ PREHOOK: query: DESCRIBE TEST2b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST2b
POSTHOOK: type: DESCTABLE
-a array<int>
-b double
-c map<double,int>
+col_name data_type comment
+
+a array<int> None
+b double None
+c map<double,int> None
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out Mon Sep 20 20:22:22 2010
@@ -7,8 +7,10 @@ PREHOOK: query: DESCRIBE TEST3a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3a
POSTHOOK: type: DESCTABLE
-a int
-b double
+col_name data_type comment
+
+a int None
+b double None
PREHOOK: query: CREATE TABLE TEST3b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE TEST3b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
@@ -18,9 +20,11 @@ PREHOOK: query: DESCRIBE TEST3b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3b
POSTHOOK: type: DESCTABLE
-a array<int>
-b double
-c map<double,int>
+col_name data_type comment
+
+a array<int> None
+b double None
+c map<double,int> None
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
@@ -68,10 +72,12 @@ PREHOOK: query: DESCRIBE TEST3b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3b
POSTHOOK: type: DESCTABLE
-a array<int>
-b double
-c map<double,int>
-x double
+col_name data_type comment
+
+a array<int> None
+b double None
+c map<double,int> None
+x double None
PREHOOK: query: EXPLAIN
ALTER TABLE TEST3b RENAME TO TEST3c
PREHOOK: type: ALTERTABLE_RENAME
@@ -106,10 +112,12 @@ PREHOOK: query: DESCRIBE TEST3c
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3c
POSTHOOK: type: DESCTABLE
-a array<int>
-b double
-c map<double,int>
-x double
+col_name data_type comment
+
+a array<int> None
+b double None
+c map<double,int> None
+x double None
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
@@ -157,7 +165,33 @@ PREHOOK: query: DESCRIBE EXTENDED TEST3c
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED TEST3c
POSTHOOK: type: DESCTABLE
-r1 int
-r2 double
+col_name data_type comment
+
+r1 int None
+r2 double None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:23:52 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/test3c
+Table Type: MANAGED_TABLE
+Table Parameters:
+ last_modified_by thiruvel
+ last_modified_time 1284477832
+ transient_lastDdlTime 1284477832
+
+# 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
-Detailed Table Information Table(tableName:test3c, dbName:default, owner:jsichi, createTime:1282863111, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:r1, type:int, comment:null), FieldSchema(name:r2, type:double, comment:null)], location:pfile:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/test3c, 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=jsichi, last_modified_time=1282863112, transient_lastDdlTime=1282863112}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out Mon Sep 20 20:22:22 2010
@@ -97,20 +97,47 @@ POSTHOOK: query: DESCRIBE EXTENDED part_
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).a SIMPLE []
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).b SIMPLE []
-a string
-b string
-ds string
-ts string
+col_name data_type comment
+
+a string None
+b string None
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+ts string None
+
+# Detailed Partition Information
+Partition Value: [2008 04 08, 10:11:12=455]
+Database: default
+Table: part_special
+CreateTime: Tue Sep 14 08:24:14 PDT 2010
+LastAccessTime: Wed Dec 31 16:00:00 PST 1969
+Protect Mode: None
+Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/part_special/ds=2008 04 08/ts=10%3A11%3A12%3D455
+Partition Parameters:
+ transient_lastDdlTime 1284477854
+
+# 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
-Detailed Partition Information Partition(values:[2008 04 08, 10:11:12=455], dbName:default, tableName:part_special, createTime:1279737004, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/part_special/ds=2008 04 08/ts=10%3A11%3A12%3D455, 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:{transient_lastDdlTime=1279737004})
PREHOOK: query: SELECT * FROM part_special WHERE ds='2008 04 08' AND ts = '10:11:12=455'
PREHOOK: type: QUERY
PREHOOK: Input: default@part_special@ds=2008 04 08/ts=10%3A11%3A12%3D455
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-30-04_674_1957557010167845537/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-24-14_529_9115667855216344763/-mr-10000
POSTHOOK: query: SELECT * FROM part_special WHERE ds='2008 04 08' AND ts = '10:11:12=455'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part_special@ds=2008 04 08/ts=10%3A11%3A12%3D455
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-30-04_674_1957557010167845537/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-24-14_529_9115667855216344763/-mr-10000
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).a SIMPLE []
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).b SIMPLE []
1 2 2008 04 08 10:11:12=455
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out Mon Sep 20 20:22:22 2010
@@ -33,7 +33,13 @@ PREHOOK: query: DESCRIBE INPUTDDL2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL2
POSTHOOK: type: DESCTABLE
-key int
-value string
-ds string
-country string
+col_name data_type comment
+
+key int None
+value string None
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+country string None
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out Mon Sep 20 20:22:22 2010
@@ -33,5 +33,7 @@ PREHOOK: query: DESCRIBE INPUTDDL3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL3
POSTHOOK: type: DESCTABLE
-key int
-value string
+col_name data_type comment
+
+key int None
+value string None
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out Mon Sep 20 20:22:22 2010
@@ -23,27 +23,62 @@ PREHOOK: query: DESCRIBE INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL4
POSTHOOK: type: DESCTABLE
-viewtime string
-userid int
-page_url string
-referrer_url string
-friends array<bigint>
-properties map<string,string>
-ip string IP Address of the User
-ds string
-country string
+col_name data_type comment
+
+viewtime string None
+userid int None
+page_url string None
+referrer_url string None
+friends array<bigint> None
+properties map<string,string> None
+ip string IP Address of the User
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+country string None
PREHOOK: query: DESCRIBE EXTENDED INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4
POSTHOOK: type: DESCTABLE
-viewtime string
-userid int
-page_url string
-referrer_url string
-friends array<bigint>
-properties map<string,string>
-ip string IP Address of the User
-ds string
-country string
+col_name data_type comment
+
+viewtime string None
+userid int None
+page_url string None
+referrer_url string None
+friends array<bigint> None
+properties map<string,string> None
+ip string IP Address of the User
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+country string None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 08:20:54 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/inputddl4
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284477654
+ comment This is the page view table
+
+# 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: 32
+Bucket Columns: [userid]
+Sort Columns: [Order(col:viewtime, order:1)]
+Storage Desc Params:
+ serialization.format 1
-Detailed Table Information Table(tableName:inputddl4, dbName:default, owner:jssarma, createTime:1279737054, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:viewtime, type:string, comment:null), FieldSchema(name:userid, type:int, comment:null), FieldSchema(name:page_url, type:string, comment:null), FieldSchema(name:referrer_url, type:string, comment:null), FieldSchema(name:friends, type:array<bigint>, comment:null), FieldSchema(name:properties, type:map<string,string>, comment:null), FieldSchema(name:ip, type:string, comment:IP Address of the User)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/inputddl4, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:32, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), buc
ketCols:[userid], sortCols:[Order(col:viewtime, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], parameters:{transient_lastDdlTime=1279737054, comment=This is the page view table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out Mon Sep 20 20:22:22 2010
@@ -16,22 +16,24 @@ PREHOOK: query: DESCRIBE INPUTDDL5
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL5
POSTHOOK: type: DESCTABLE
-name string
+col_name data_type comment
+
+name string None
PREHOOK: query: SELECT INPUTDDL5.name from INPUTDDL5
PREHOOK: type: QUERY
PREHOOK: Input: default@inputddl5
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-30-54_835_1744174828053981951/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-23-57_837_3762384530254196250/-mr-10000
POSTHOOK: query: SELECT INPUTDDL5.name from INPUTDDL5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputddl5
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-30-54_835_1744174828053981951/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-23-57_837_3762384530254196250/-mr-10000
éµé®
PREHOOK: query: SELECT count(1) FROM INPUTDDL5 WHERE INPUTDDL5.name = _UTF-8 0xE982B5E993AE
PREHOOK: type: QUERY
PREHOOK: Input: default@inputddl5
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-30-57_281_5492145936569181144/10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-24-00_215_9153901156666305334/-mr-10000
POSTHOOK: query: SELECT count(1) FROM INPUTDDL5 WHERE INPUTDDL5.name = _UTF-8 0xE982B5E993AE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputddl5
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-30-57_281_5492145936569181144/10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-24-00_215_9153901156666305334/-mr-10000
1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out?rev=999101&r1=999100&r2=999101&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out Mon Sep 20 20:22:22 2010
@@ -23,20 +23,75 @@ PREHOOK: query: DESCRIBE EXTENDED INPUTD
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6
POSTHOOK: type: DESCTABLE
-key string
-value string
-ds string
+col_name data_type comment
+
+key string None
+value string None
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+
+# Detailed Table Information
+Database: default
+Owner: thiruvel
+CreateTime: Tue Sep 14 07:04:41 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/inputddl6
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1284473081
+
+# 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
-Detailed Table Information Table(tableName:inputddl6, dbName:default, owner:njain, createTime:1282028549, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/inputddl6, 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:ds, type:string, comment:null)], parameters:{transient_lastDdlTime=1282028549}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08')
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08')
POSTHOOK: type: DESCTABLE
-key string
-value string
-ds string
+col_name data_type comment
+
+key string None
+value string None
+
+# Partition Information
+col_name data_type comment
+
+ds string None
+
+# Detailed Partition Information
+Partition Value: [2008-04-08]
+Database: default
+Table: inputddl6
+CreateTime: Tue Sep 14 07:04:41 PDT 2010
+LastAccessTime: Wed Dec 31 16:00:00 PST 1969
+Protect Mode: None
+Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/inputddl6/ds=2008-04-08
+Partition Parameters:
+ transient_lastDdlTime 1284473081
+
+# 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
-Detailed Partition Information Partition(values:[2008-04-08], dbName:default, tableName:inputddl6, createTime:1282028551, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/inputddl6/ds=2008-04-08, 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:{transient_lastDdlTime=1282028551})
PREHOOK: query: SHOW PARTITIONS INPUTDDL6
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS INPUTDDL6