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 [5/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/create_default_prop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out Wed Oct 13 04:26:34 2010
@@ -7,35 +7,9 @@ PREHOOK: query: DESC EXTENDED table_p1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESC EXTENDED table_p1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-
-# Detailed Table Information
-Database: default
-Owner: sdong
-CreateTime: Tue Sep 21 20:51:39 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/sdong/www/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/table_p1
-Table Type: MANAGED_TABLE
-Table Parameters:
- p1 v1
- transient_lastDdlTime 1285127499
- P2 v21=v22=v23
-
-# 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
+Detailed Table Information Table(tableName:table_p1, dbName:default, owner:thiruvel, createTime:1286825949, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table_p1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{p1=v1, transient_lastDdlTime=1286825949, P2=v21=v22=v23}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: CREATE TABLE table_p2 LIKE table_p1
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE table_p2 LIKE table_p1
@@ -45,36 +19,9 @@ PREHOOK: query: DESC EXTENDED table_p2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESC EXTENDED table_p2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-
-# Detailed Table Information
-Database: default
-Owner: sdong
-CreateTime: Tue Sep 21 20:51:39 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/sdong/www/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/table_p2
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- p1 v1
- transient_lastDdlTime 1285127499
- P2 v21=v22=v23
-
-# 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
+Detailed Table Information Table(tableName:table_p2, dbName:default, owner:thiruvel, createTime:1286825949, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table_p2, 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, p1=v1, transient_lastDdlTime=1286825949, P2=v21=v22=v23}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
PREHOOK: type: CREATETABLE
PREHOOK: Input: default@table_p1
@@ -86,31 +33,6 @@ PREHOOK: query: DESC EXTENDED table_p3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESC EXTENDED table_p3
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-
-# Detailed Table Information
-Database: default
-Owner: sdong
-CreateTime: Tue Sep 21 20:51:43 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/data/users/sdong/www/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/table_p3
-Table Type: MANAGED_TABLE
-Table Parameters:
- p3 v3
- transient_lastDdlTime 1285127503
-
-# 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
+Detailed Table Information Table(tableName:table_p3, dbName:default, owner:thiruvel, createTime:1286825953, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/table_p3, 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:{p3=v3, transient_lastDdlTime=1286825953}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/create_escape.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/create_escape.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/create_escape.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/create_escape.q.out Wed Oct 13 04:26:34 2010
@@ -11,44 +11,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: nzhang
-CreateTime: Tue Sep 21 07:28:36 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/table1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285079316
-
-# 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:
- escape.delim \\
- serialization.format \t
- field.delim \t
+a string
+b string
+Detailed Table Information Table(tableName:table1, dbName:default, owner:thiruvel, createTime:1286800085, 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:{escape.delim=\, serialization.format= , field.delim=
PREHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key, '\\\t\\' FROM src WHERE key = 86
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -62,11 +34,11 @@ POSTHOOK: Lineage: table1.b SIMPLE []
PREHOOK: query: SELECT * FROM table1
PREHOOK: type: QUERY
PREHOOK: Input: default@table1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_07-28-42_009_3448389970814289659/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-28-09_174_3118900658292640763/-mr-10000
POSTHOOK: query: SELECT * FROM table1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_07-28-42_009_3448389970814289659/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-28-09_174_3118900658292640763/-mr-10000
POSTHOOK: Lineage: table1.a SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: table1.b SIMPLE []
86 \ \
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/create_insert_outputformat.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/create_insert_outputformat.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/create_insert_outputformat.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/create_insert_outputformat.q.out Wed Oct 13 04:26:34 2010
@@ -25,10 +25,8 @@ POSTHOOK: query: describe table_test_out
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: table_test_output_format.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: table_test_output_format.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key int None
-value string None
+key int
+value string
PREHOOK: query: CREATE TABLE table_test_output_format_sequencefile(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
@@ -62,10 +60,8 @@ POSTHOOK: Lineage: table_test_output_for
POSTHOOK: Lineage: table_test_output_format.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: table_test_output_format_sequencefile.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: table_test_output_format_sequencefile.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key int None
-value string None
+key int
+value string
PREHOOK: query: CREATE TABLE table_test_output_format_hivesequencefile(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat'
@@ -105,7 +101,5 @@ POSTHOOK: Lineage: table_test_output_for
POSTHOOK: Lineage: table_test_output_format_hivesequencefile.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: table_test_output_format_sequencefile.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: table_test_output_format_sequencefile.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key int None
-value string None
+key int
+value string
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/create_like.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/create_like.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/create_like.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/create_like.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: thiruvel
-CreateTime: Tue Sep 14 08:12:39 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/table1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477159
-
-# 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:1286798759, 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=1286798759}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: CREATE TABLE table2 LIKE table1
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE table2 LIKE table1
@@ -52,43 +26,16 @@ PREHOOK: query: DESCRIBE table2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b string None
+a string
+b string
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 string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:12:39 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/table2
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- transient_lastDdlTime 1284477159
-
-# 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:table2, dbName:default, owner:thiruvel, createTime:1286798760, 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/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:{EXTERNAL=FALSE, transient_lastDdlTime=1286798760}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: CREATE TABLE IF NOT EXISTS table2 LIKE table1
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE IF NOT EXISTS table2 LIKE table1
@@ -106,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: thiruvel
-CreateTime: Tue Sep 14 08:12:40 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/table3
-Table Type: EXTERNAL_TABLE
-Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1284477160
-
-# 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:table3, dbName:default, owner:thiruvel, createTime:1286798760, 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=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1286798760}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
PREHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key, value FROM src WHERE key = 86
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -168,11 +88,11 @@ POSTHOOK: Lineage: table2.b SIMPLE [(src
PREHOOK: query: SELECT * FROM table1
PREHOOK: type: QUERY
PREHOOK: Input: default@table1
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-12-45_384_7121730707453573717/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-06-07_038_1626206004888639/-mr-10000
POSTHOOK: query: SELECT * FROM table1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table1
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-12-45_384_7121730707453573717/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-06-07_038_1626206004888639/-mr-10000
POSTHOOK: Lineage: table1.a SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: table1.b SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: table2.a SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -181,11 +101,11 @@ POSTHOOK: Lineage: table2.b SIMPLE [(src
PREHOOK: query: SELECT * FROM table2
PREHOOK: type: QUERY
PREHOOK: Input: default@table2
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-12-45_467_3430528099067644720/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-06-07_139_9055053700650128611/-mr-10000
POSTHOOK: query: SELECT * FROM table2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table2
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-12-45_467_3430528099067644720/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-06-07_139_9055053700650128611/-mr-10000
POSTHOOK: Lineage: table1.a SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: table1.b SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: table2.a SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out Wed Oct 13 04:26:34 2010
@@ -17,46 +17,20 @@ PREHOOK: query: DESCRIBE table1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE table1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a string None
-b array<string> None
-c array<map<string,string>> None
-d map<string,array<string>> None
+a string
+b array<string>
+c array<map<string,string>>
+d map<string,array<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 array<string> None
-c array<map<string,string>> None
-d map<string,array<string>> None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:13:22 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/table1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477202
-
-# 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 array<string>
+c array<map<string,string>>
+d map<string,array<string>>
+Detailed Table Information Table(tableName:table1, dbName:default, owner:thiruvel, createTime:1286798540, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null), FieldSchema(name:b, type:array<string>, comment:null), FieldSchema(name:c, type:array<map<string,string>>, comment:null), FieldSchema(name:d, type:map<string,array<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=1286798540}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/create_nested_type.txt' OVERWRITE INTO TABLE table1
PREHOOK: type: LOAD
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/create_nested_type.txt' OVERWRITE INTO TABLE table1
@@ -65,11 +39,11 @@ POSTHOOK: Output: default@table1
PREHOOK: query: SELECT * from table1
PREHOOK: type: QUERY
PREHOOK: Input: default@table1
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-13-22_643_4121694117297917611/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-02-20_476_2486617507933287344/-mr-10000
POSTHOOK: query: SELECT * from table1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table1
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-13-22_643_4121694117297917611/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-02-20_476_2486617507933287344/-mr-10000
a0 ["b00","b01"] [{"c001":"C001","c002":"C002"},{"c011":null,"c012":"C012"}] {"d01":["d011","d012"],"d02":["d021","d022"]}
a1 ["b10"] [{"c001":"C001","c002":"C002"}] {"d01":["d011","d012"],"d02":null}
a2 [] [{"c001":null,"c002":"C002"},{"c011":"C011","c012":"C012"}] {"d01":[null,"d012"],"d02":["d021","d022"]}