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 [4/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/...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/alter_partition_format_loc.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/alter_partition_format_loc.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/alter_partition_format_loc.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/alter_partition_format_loc.q.out Wed Oct 13 04:26:34 2010
@@ -7,34 +7,10 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:08:59 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/alter_partition_format_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284476939
-
-# 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
+key int
+value string
+Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:thiruvel, createTime:1286798855, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter_partition_format_test, 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=1286798855}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter_partition_format_test set fileformat rcfile
PREHOOK: type: ALTERTABLE_FILEFORMAT
PREHOOK: Input: default@alter_partition_format_test
@@ -47,36 +23,10 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int from deserializer
-value string from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:08:59 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/alter_partition_format_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476940
- transient_lastDdlTime 1284476940
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int from deserializer
+value string from deserializer
+Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:thiruvel, createTime:1286798855, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter_partition_format_test, 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:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=thiruvel, last_modified_time=1286798856, transient_lastDdlTime=1286798856}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter_partition_format_test set location "file:/test/test/"
PREHOOK: type: ALTERTABLE_LOCATION
PREHOOK: Input: default@alter_partition_format_test
@@ -89,36 +39,10 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int from deserializer
-value string from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:08:59 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: file:/test/test
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476940
- transient_lastDdlTime 1284476940
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int from deserializer
+value string from deserializer
+Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:thiruvel, createTime:1286798855, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/test/test/, 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:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=thiruvel, last_modified_time=1286798856, transient_lastDdlTime=1286798856}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: drop table alter_partition_format_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter_partition_format_test
@@ -145,38 +69,11 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test partition(ds='2010')
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-
-# Detailed Partition Information
-Partition Value: [2010]
-Database: default
-Table: alter_partition_format_test
-CreateTime: Tue Sep 14 08:09: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/alter_partition_format_test/ds=2010
-Partition Parameters:
- transient_lastDdlTime 1284476940
-
-# 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
+key int
+value string
+ds string
+Detailed Partition Information Partition(values:[2010], dbName:default, tableName:alter_partition_format_test, createTime:1286798856, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter_partition_format_test/ds=2010, 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=1286798856})
PREHOOK: query: alter table alter_partition_format_test partition(ds='2010') set fileformat rcfile
PREHOOK: type: ALTERPARTITION_FILEFORMAT
PREHOOK: Input: default@alter_partition_format_test
@@ -191,40 +88,11 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test partition(ds='2010')
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-
-# Detailed Partition Information
-Partition Value: [2010]
-Database: default
-Table: alter_partition_format_test
-CreateTime: Tue Sep 14 08:09: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/alter_partition_format_test/ds=2010
-Partition Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476941
- transient_lastDdlTime 1284476941
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int
+value string
+ds string
+Detailed Partition Information Partition(values:[2010], dbName:default, tableName:alter_partition_format_test, createTime:1286798856, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter_partition_format_test/ds=2010, 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:[], parameters:{}), parameters:{last_modified_by=thiruvel, last_modified_time=1286798856, transient_lastDdlTime=1286798856})
PREHOOK: query: alter table alter_partition_format_test partition(ds='2010') set location "file:/test/test/ds=2010"
PREHOOK: type: ALTERPARTITION_LOCATION
PREHOOK: Input: default@alter_partition_format_test
@@ -239,77 +107,20 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test partition(ds='2010')
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-
-# Detailed Partition Information
-Partition Value: [2010]
-Database: default
-Table: alter_partition_format_test
-CreateTime: Tue Sep 14 08:09:00 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Location: file:/test/test/ds=2010
-Partition Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476941
- transient_lastDdlTime 1284476941
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int
+value string
+ds string
+Detailed Partition Information Partition(values:[2010], dbName:default, tableName:alter_partition_format_test, createTime:1286798856, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/test/test/ds=2010, 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:[], parameters:{}), parameters:{last_modified_by=thiruvel, last_modified_time=1286798857, transient_lastDdlTime=1286798857})
PREHOOK: query: desc extended alter_partition_format_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int 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 08:09:00 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/alter_partition_format_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284476940
-
-# 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
+key int
+value string
+ds string
+Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:thiruvel, createTime:1286798856, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter_partition_format_test, 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=1286798856}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter_partition_format_test set fileformat rcfile
PREHOOK: type: ALTERTABLE_FILEFORMAT
PREHOOK: Input: default@alter_partition_format_test
@@ -322,41 +133,11 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int from deserializer
-value string from deserializer
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:09:00 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/alter_partition_format_test
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476941
- transient_lastDdlTime 1284476941
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int from deserializer
+value string from deserializer
+ds string
+Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:thiruvel, createTime:1286798856, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/alter_partition_format_test, 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:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286798857, transient_lastDdlTime=1286798857}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table alter_partition_format_test set location "file:/test/test/"
PREHOOK: type: ALTERTABLE_LOCATION
PREHOOK: Input: default@alter_partition_format_test
@@ -369,41 +150,11 @@ PREHOOK: query: desc extended alter_part
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended alter_partition_format_test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int from deserializer
-value string from deserializer
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:09:00 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: file:/test/test
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284476941
- transient_lastDdlTime 1284476941
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int from deserializer
+value string from deserializer
+ds string
+Detailed Table Information Table(tableName:alter_partition_format_test, dbName:default, owner:thiruvel, createTime:1286798856, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/test/test/, 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:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{last_modified_by=thiruvel, last_modified_time=1286798857, transient_lastDdlTime=1286798857}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: drop table alter_partition_format_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter_partition_format_test
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/bucket_groupby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/bucket_groupby.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/bucket_groupby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/bucket_groupby.q.out Wed Oct 13 04:26:34 2010
@@ -7,39 +7,11 @@ PREHOOK: query: describe extended cluste
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended clustergroupby
POSTHOOK: type: DESCTABLE
-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: nzhang
-CreateTime: Mon Sep 20 23:12:00 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/clustergroupby
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285049520
-
-# 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
+key string
+value string
+ds string
+Detailed Table Information Table(tableName:clustergroupby, dbName:default, owner:thiruvel, createTime:1286799299, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/clustergroupby, 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=1286799299}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table clustergroupby partition (ds='100') select key, value from src sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -139,11 +111,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='100' group by key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=100
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-08_471_264777909273341136/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-04_391_496085082728658237/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='100' group by key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=100
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-08_471_264777909273341136/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-04_391_496085082728658237/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 3
@@ -172,45 +144,11 @@ POSTHOOK: query: describe extended clust
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-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: nzhang
-CreateTime: Mon Sep 20 23:12:00 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/clustergroupby
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 1
- numFiles 1
- last_modified_by nzhang
- last_modified_time 1285049532
- transient_lastDdlTime 1285049532
- numRows 500
- totalSize 5812
-
-# 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: [key]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key string
+value string
+ds string
+Detailed Table Information Table(tableName:clustergroupby, dbName:default, owner:thiruvel, createTime:1286799299, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/clustergroupby, 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:[key], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=thiruvel, last_modified_time=1286799306, transient_lastDdlTime=1286799306, numRows=500, totalSi
ze=5812}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table clustergroupby partition (ds='101') select key, value from src distribute by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -316,11 +254,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='101' group by key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=101
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-20_193_4381502362232094489/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-10_631_330475374084282440/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='101' group by key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=101
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-20_193_4381502362232094489/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-10_631_330475374084282440/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -428,11 +366,11 @@ STAGE PLANS:
PREHOOK: query: select length(key), count(1) from clustergroupby where ds='101' group by length(key) limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=101
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-24_121_8011305195289924924/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-13_272_378379398402774764/-mr-10000
POSTHOOK: query: select length(key), count(1) from clustergroupby where ds='101' group by length(key) limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=101
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-24_121_8011305195289924924/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-13_272_378379398402774764/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -531,11 +469,11 @@ STAGE PLANS:
PREHOOK: query: select abs(length(key)), count(1) from clustergroupby where ds='101' group by abs(length(key)) limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=101
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-28_041_4377337206683711142/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-16_007_3235459708019247294/-mr-10000
POSTHOOK: query: select abs(length(key)), count(1) from clustergroupby where ds='101' group by abs(length(key)) limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=101
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-28_041_4377337206683711142/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-16_007_3235459708019247294/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -644,11 +582,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='101' group by key,3 limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=101
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-31_955_2035389635675970206/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-18_557_7014524165209144470/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='101' group by key,3 limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=101
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-31_955_2035389635675970206/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-18_557_7014524165209144470/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -761,11 +699,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from (select value as key, key as value from clustergroupby where ds='101')subq group by key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=101
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-35_858_682244352816074312/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-26_089_856130089143672363/-mr-10000
POSTHOOK: query: select key, count(1) from (select value as key, key as value from clustergroupby where ds='101')subq group by key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=101
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-35_858_682244352816074312/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-26_089_856130089143672363/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -863,12 +801,12 @@ PREHOOK: query: select key, count(1) fro
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=100
PREHOOK: Input: default@clustergroupby@ds=101
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-39_667_6993113161354815698/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-28_594_4859888465200168624/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby group by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=100
POSTHOOK: Input: default@clustergroupby@ds=101
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-39_667_6993113161354815698/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-28_594_4859888465200168624/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1291,45 +1229,11 @@ POSTHOOK: Lineage: clustergroupby PARTIT
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-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: nzhang
-CreateTime: Mon Sep 20 23:12:00 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/clustergroupby
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 2
- numFiles 2
- last_modified_by nzhang
- last_modified_time 1285049564
- transient_lastDdlTime 1285049564
- numRows 1000
- totalSize 11624
-
-# 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: [value]
-Sort Columns: [Order(col:key, order:1), Order(col:value, order:1)]
-Storage Desc Params:
- serialization.format 1
+key string
+value string
+ds string
+Detailed Table Information Table(tableName:clustergroupby, dbName:default, owner:thiruvel, createTime:1286799299, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/clustergroupby, 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:[value], sortCols:[Order(col:key, order:1), Order(col:value, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{numPartitions=2, numFiles=2, last_modified_by=thiruvel, last_modified_time=1286799335, tr
ansient_lastDdlTime=1286799335, numRows=1000, totalSize=11624}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table clustergroupby partition (ds='102') select key, value from src distribute by value sort by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -1437,11 +1341,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='102' group by key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=102
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-52_423_5195000162572997399/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-39_061_3582799164493598492/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='102' group by key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=102
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-52_423_5195000162572997399/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-39_061_3582799164493598492/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1551,11 +1455,11 @@ STAGE PLANS:
PREHOOK: query: select value, count(1) from clustergroupby where ds='102' group by value limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=102
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-56_614_4460480942841985035/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-41_567_7781693855424961483/-mr-10000
POSTHOOK: query: select value, count(1) from clustergroupby where ds='102' group by value limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=102
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-12-56_614_4460480942841985035/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-41_567_7781693855424961483/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1675,11 +1579,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='102' group by key, value limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=102
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-13-00_558_2886682989236055618/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-44_109_2716598788006290449/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='102' group by key, value limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=102
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-13-00_558_2886682989236055618/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-44_109_2716598788006290449/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1720,45 +1624,11 @@ POSTHOOK: Lineage: clustergroupby PARTIT
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=102).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=102).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-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: nzhang
-CreateTime: Mon Sep 20 23:12:00 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/clustergroupby
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 3
- numFiles 3
- last_modified_by nzhang
- last_modified_time 1285049584
- transient_lastDdlTime 1285049584
- numRows 1500
- totalSize 17436
-
-# 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: [value, key]
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- serialization.format 1
+key string
+value string
+ds string
+Detailed Table Information Table(tableName:clustergroupby, dbName:default, owner:thiruvel, createTime:1286799299, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/clustergroupby, 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:[value, key], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{numPartitions=3, numFiles=3, last_modified_by=thiruvel, last_modified_time=1286799346, transient_lastDdlTime=12
86799346, numRows=1500, totalSize=17436}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table clustergroupby partition (ds='103') select key, value from src distribute by value, key sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -1870,11 +1740,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='103' group by key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=103
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-13-11_680_1170880569605249416/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-50_284_7568294531708606872/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='103' group by key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=103
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-13-11_680_1170880569605249416/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-50_284_7568294531708606872/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -1998,11 +1868,11 @@ STAGE PLANS:
PREHOOK: query: select key, count(1) from clustergroupby where ds='103' group by value, key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@clustergroupby@ds=103
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-13-15_849_1305890724778001430/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-52_910_4870036796285454803/-mr-10000
POSTHOOK: query: select key, count(1) from clustergroupby where ds='103' group by value, key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@clustergroupby@ds=103
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-13-15_849_1305890724778001430/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-15-52_910_4870036796285454803/-mr-10000
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: clustergroupby PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out Wed Oct 13 04:26:34 2010
@@ -99,11 +99,11 @@ POSTHOOK: Lineage: columnarserde_create_
PREHOOK: query: SELECT columnarserde_create_shortcut.* FROM columnarserde_create_shortcut DISTRIBUTE BY 1
PREHOOK: type: QUERY
PREHOOK: Input: default@columnarserde_create_shortcut
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-36_108_8409199986184348363/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-09_802_1487672755503813438/-mr-10000
POSTHOOK: query: SELECT columnarserde_create_shortcut.* FROM columnarserde_create_shortcut DISTRIBUTE BY 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columnarserde_create_shortcut
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-36_108_8409199986184348363/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-09_802_1487672755503813438/-mr-10000
POSTHOOK: Lineage: columnarserde_create_shortcut.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
@@ -123,11 +123,11 @@ null null null 0 NULL
PREHOOK: query: SELECT columnarserde_create_shortcut.a[0], columnarserde_create_shortcut.b[0], columnarserde_create_shortcut.c['key2'], columnarserde_create_shortcut.d, columnarserde_create_shortcut.e FROM columnarserde_create_shortcut DISTRIBUTE BY 1
PREHOOK: type: QUERY
PREHOOK: Input: default@columnarserde_create_shortcut
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-39_691_5606542646725803617/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-22_954_5642646028069530983/-mr-10000
POSTHOOK: query: SELECT columnarserde_create_shortcut.a[0], columnarserde_create_shortcut.b[0], columnarserde_create_shortcut.c['key2'], columnarserde_create_shortcut.d, columnarserde_create_shortcut.e FROM columnarserde_create_shortcut DISTRIBUTE BY 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columnarserde_create_shortcut
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-39_691_5606542646725803617/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-22_954_5642646028069530983/-mr-10000
POSTHOOK: Lineage: columnarserde_create_shortcut.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
@@ -182,18 +182,16 @@ POSTHOOK: Lineage: columnarserde_create_
POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
POSTHOOK: Lineage: columnshortcuttable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string from deserializer
-value string from deserializer
+key string from deserializer
+value string from deserializer
PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
PREHOOK: type: QUERY
PREHOOK: Input: default@columnshortcuttable
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-50_492_1201536824580029819/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-40_597_3555575733389397838/-mr-10000
POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columnshortcuttable
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-50_492_1201536824580029819/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-40_597_3555575733389397838/-mr-10000
POSTHOOK: Lineage: columnarserde_create_shortcut.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
@@ -229,11 +227,11 @@ POSTHOOK: Lineage: columnshortcuttable.v
PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
PREHOOK: type: QUERY
PREHOOK: Input: default@columnshortcuttable
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-51_053_7536543525937925493/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-42_280_1296197972182075194/-mr-10000
POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columnshortcuttable
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-51_053_7536543525937925493/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-42_280_1296197972182075194/-mr-10000
POSTHOOK: Lineage: columnarserde_create_shortcut.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
@@ -269,11 +267,11 @@ POSTHOOK: Lineage: columnshortcuttable.v
PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
PREHOOK: type: QUERY
PREHOOK: Input: default@columnshortcuttable
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-51_605_3764283101735008865/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-43_316_4144322716554802876/-mr-10000
POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columnshortcuttable
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-24-51_605_3764283101735008865/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-04-43_316_4144322716554802876/-mr-10000
POSTHOOK: Lineage: columnarserde_create_shortcut.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: columnarserde_create_shortcut.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/combine3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/combine3.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/combine3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/combine3.q.out Wed Oct 13 04:26:34 2010
@@ -47,42 +47,12 @@ POSTHOOK: Lineage: combine_3_srcpart_seq
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=001).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=00).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key int from deserializer
-value string from deserializer
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
-
-# Detailed Partition Information
-Partition Value: [2010-08-03, 00]
-Database: default
-Table: combine_3_srcpart_seq_rc
-CreateTime: Mon Sep 20 23:25:54 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/combine_3_srcpart_seq_rc/ds=2010-08-03/hr=00
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285050355
- numRows 500
- totalSize 15250
-
-# 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
+key int from deserializer
+value string from deserializer
+ds string
+hr string
+Detailed Partition Information Partition(values:[2010-08-03, 00], dbName:default, tableName:combine_3_srcpart_seq_rc, createTime:1286798296, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/combine_3_srcpart_seq_rc/ds=2010-08-03/hr=00, 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:{}), parameters:{numFiles=1, transient_lastDdlTime=1286798297, numRows=500, totalSize=15250})
PREHOOK: query: desc extended combine_3_srcpart_seq_rc partition(ds="2010-08-03", hr="001")
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended combine_3_srcpart_seq_rc partition(ds="2010-08-03", hr="001")
@@ -91,52 +61,22 @@ POSTHOOK: Lineage: combine_3_srcpart_seq
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=001).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=00).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key int from deserializer
-value string from deserializer
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
-
-# Detailed Partition Information
-Partition Value: [2010-08-03, 001]
-Database: default
-Table: combine_3_srcpart_seq_rc
-CreateTime: Mon Sep 20 23:26:02 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Location: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/test/data/warehouse/combine_3_srcpart_seq_rc/ds=2010-08-03/hr=001
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285050362
- numRows 500
- totalSize 2076
-
-# 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: []
-Storage Desc Params:
- serialization.format 1
+key int from deserializer
+value string from deserializer
+ds string
+hr string
+Detailed Partition Information Partition(values:[2010-08-03, 001], dbName:default, tableName:combine_3_srcpart_seq_rc, createTime:1286798300, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/combine_3_srcpart_seq_rc/ds=2010-08-03/hr=001, 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:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286798300, numRows=500, totalSize=2076})
PREHOOK: query: select key, value, ds, hr from combine_3_srcpart_seq_rc where ds="2010-08-03" order by key, hr limit 30
PREHOOK: type: QUERY
PREHOOK: Input: default@combine_3_srcpart_seq_rc@ds=2010-08-03/hr=00
PREHOOK: Input: default@combine_3_srcpart_seq_rc@ds=2010-08-03/hr=001
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-26-03_040_1636466126220724204/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_04-58-21_151_2378487651404482598/-mr-10000
POSTHOOK: query: select key, value, ds, hr from combine_3_srcpart_seq_rc where ds="2010-08-03" order by key, hr limit 30
POSTHOOK: type: QUERY
POSTHOOK: Input: default@combine_3_srcpart_seq_rc@ds=2010-08-03/hr=00
POSTHOOK: Input: default@combine_3_srcpart_seq_rc@ds=2010-08-03/hr=001
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-26-03_040_1636466126220724204/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_04-58-21_151_2378487651404482598/-mr-10000
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=001).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=001).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -240,12 +180,12 @@ PREHOOK: query: select key, ds from comb
PREHOOK: type: QUERY
PREHOOK: Input: default@combine_3_srcpart_seq_rc_bucket@ds=1
PREHOOK: Input: default@combine_3_srcpart_seq_rc_bucket@ds=11
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-26-23_545_2451540426039382986/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_04-58-31_121_8495821577127810126/-mr-10000
POSTHOOK: query: select key, ds from combine_3_srcpart_seq_rc_bucket tablesample (bucket 1 out of 2) s where ds = '1' or ds= '11' order by key, ds limit 30
POSTHOOK: type: QUERY
POSTHOOK: Input: default@combine_3_srcpart_seq_rc_bucket@ds=1
POSTHOOK: Input: default@combine_3_srcpart_seq_rc_bucket@ds=11
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-26-23_545_2451540426039382986/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_04-58-31_121_8495821577127810126/-mr-10000
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=001).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=001).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: combine_3_srcpart_seq_rc PARTITION(ds=2010-08-03,hr=00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/create_1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/create_1.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/create_1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/create_1.q.out Wed Oct 13 04:26:34 2010
@@ -7,42 +7,16 @@ PREHOOK: query: DESCRIBE table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
+a string
+b string
PREHOOK: query: DESCRIBE EXTENDED table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED table1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
-
-# Detailed Table Information
-Database: default
-Owner: heyongqiang
-CreateTime: Wed Sep 29 13:05:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285790733
-
-# 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 string
+b string
+Detailed Table Information Table(tableName:table1, dbName:default, owner:thiruvel, createTime:1286827811, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table1, 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=1286827811}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: CREATE TABLE IF NOT EXISTS table1 (a STRING, b STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE IF NOT EXISTS table1 (a STRING, b STRING) STORED AS TEXTFILE
@@ -56,42 +30,16 @@ PREHOOK: query: DESCRIBE table2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b int None
+a string
+b int
PREHOOK: query: DESCRIBE EXTENDED table2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED table2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b int None
-
-# Detailed Table Information
-Database: default
-Owner: heyongqiang
-CreateTime: Wed Sep 29 13:05:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table2
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285790733
-
-# 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 string
+b int
+Detailed Table Information Table(tableName:table2, dbName:default, owner:thiruvel, createTime:1286827811, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table2, 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=1286827811}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: CREATE TABLE table3 (a STRING, b STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE
@@ -105,43 +53,16 @@ PREHOOK: query: DESCRIBE table3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table3
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
+a string
+b string
PREHOOK: query: DESCRIBE EXTENDED table3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED table3
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
-
-# Detailed Table Information
-Database: default
-Owner: heyongqiang
-CreateTime: Wed Sep 29 13:05:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table3
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285790733
-
-# 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 \t
- field.delim \t
+a string
+b string
+Detailed Table Information Table(tableName:table3, dbName:default, owner:thiruvel, createTime:1286827811, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table3, 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= , field.delim=
PREHOOK: query: CREATE TABLE table4 (a STRING, b STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS SEQUENCEFILE
@@ -155,43 +76,16 @@ PREHOOK: query: DESCRIBE table4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table4
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
+a string
+b string
PREHOOK: query: DESCRIBE EXTENDED table4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED table4
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
-
-# Detailed Table Information
-Database: default
-Owner: heyongqiang
-CreateTime: Wed Sep 29 13:05:34 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table4
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285790734
-
-# 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 \t
- field.delim \t
+a string
+b string
+Detailed Table Information Table(tableName:table4, dbName:default, owner:thiruvel, createTime:1286827812, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table4, 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= , field.delim=
PREHOOK: query: CREATE TABLE table5 (a STRING, b STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS RCFILE
@@ -205,40 +99,13 @@ PREHOOK: query: DESCRIBE table5
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table5
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string from deserializer
-b string from deserializer
+a string from deserializer
+b string from deserializer
PREHOOK: query: DESCRIBE EXTENDED table5
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED table5
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string from deserializer
-b string from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: heyongqiang
-CreateTime: Wed Sep 29 13:05:34 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table5
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285790734
-
-# 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: []
-Storage Desc Params:
- serialization.format \t
- field.delim \t
+a string from deserializer
+b string from deserializer
+Detailed Table Information Table(tableName:table5, dbName:default, owner:thiruvel, createTime:1286827812, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table5, 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= , field.delim=