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 [7/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/ddltime.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out Wed Oct 13 04:26:34 2010
@@ -7,35 +7,10 @@ PREHOOK: query: desc extended T1
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended T1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string default
-value string default
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Mon Sep 20 23:31:14 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/t1
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- transient_lastDdlTime 1285050674
-
-# 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 default
+value string default
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1286799731, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1286799731}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -52,39 +27,10 @@ POSTHOOK: query: desc extended T1
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Mon Sep 20 23:31:14 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/t1
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 0
- EXTERNAL FALSE
- numFiles 1
- transient_lastDdlTime 1285050681
- 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: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key string default
+value string default
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1286799731, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{numPartitions=0, EXTERNAL=FALSE, numFiles=1, transient_lastDdlTime=1286799735, numRows=500, totalSize=5812}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select /*+ HOLD_DDLTIME*/ * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -105,39 +51,10 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Mon Sep 20 23:31:14 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/t1
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 0
- EXTERNAL FALSE
- numFiles 1
- transient_lastDdlTime 1285050688
- 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: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key string default
+value string default
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1286799731, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{numPartitions=0, EXTERNAL=FALSE, numFiles=1, transient_lastDdlTime=1286799740, numRows=500, totalSize=5812}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -162,39 +79,10 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Mon Sep 20 23:31:14 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/t1
-Table Type: MANAGED_TABLE
-Table Parameters:
- numPartitions 0
- EXTERNAL FALSE
- numFiles 1
- transient_lastDdlTime 1285050696
- 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: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key string default
+value string default
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1286799731, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{numPartitions=0, EXTERNAL=FALSE, numFiles=1, transient_lastDdlTime=1286799744, numRows=500, totalSize=5812}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: create table if not exists T2 like srcpart
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table if not exists T2 like srcpart
@@ -216,41 +104,12 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Mon Sep 20 23:31: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/t2
-Table Type: MANAGED_TABLE
-Table Parameters:
- EXTERNAL FALSE
- transient_lastDdlTime 1285050696
-
-# 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 default
+value string default
+ds string
+hr string
+Detailed Table Information Table(tableName:t2, dbName:default, owner:null, createTime:1286799744, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1286799744}, viewOriginalText
:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T2 partition (ds = '2010-06-21', hr = '1') select key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -279,42 +138,12 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
-
-# Detailed Partition Information
-Partition Value: [2010-06-21, 1]
-Database: default
-Table: t2
-CreateTime: Mon Sep 20 23:31:43 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/t2/ds=2010-06-21/hr=1
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285050703
- numRows 489
- totalSize 5722
-
-# 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 default
+value string default
+ds string
+hr string
+Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1286799749, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286799749, numRows=489, totalSize=5722})
PREHOOK: query: insert overwrite table T2 partition (ds = '2010-06-21', hr='1') select /*+ HOLD_DDLTIME */ key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -347,42 +176,12 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
-
-# Detailed Partition Information
-Partition Value: [2010-06-21, 1]
-Database: default
-Table: t2
-CreateTime: Mon Sep 20 23:31:43 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/t2/ds=2010-06-21/hr=1
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285050711
- numRows 489
- totalSize 5722
-
-# 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 default
+value string default
+ds string
+hr string
+Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1286799749, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286799754, numRows=489, totalSize=5722})
PREHOOK: query: insert overwrite table T2 partition (ds='2010-06-01', hr='1') select key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -419,39 +218,9 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-col_name data_type comment
-
-key string default
-value string default
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
-
-# Detailed Partition Information
-Partition Value: [2010-06-01, 1]
-Database: default
-Table: t2
-CreateTime: Mon Sep 20 23:31:58 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/t2/ds=2010-06-01/hr=1
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285050718
- numRows 489
- totalSize 5722
-
-# 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 default
+value string default
+ds string
+hr string
+Detailed Partition Information Partition(values:[2010-06-01, 1], dbName:default, tableName:t2, createTime:1286799758, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/t2/ds=2010-06-01/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286799758, numRows=489, totalSize=5722})
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out?rev=1021992&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out Wed Oct 13 04:26:34 2010
@@ -0,0 +1,215 @@
+PREHOOK: query: describe srcpart
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe srcpart
+POSTHOOK: type: DESCTABLE
+key string default
+value string default
+ds string
+hr string
+PREHOOK: query: describe srcpart.key
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe srcpart.key
+POSTHOOK: type: DESCTABLE
+key string from deserializer
+PREHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
+POSTHOOK: type: DESCTABLE
+key string default
+value string default
+ds string
+hr string
+PREHOOK: query: describe extended srcpart
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended srcpart
+POSTHOOK: type: DESCTABLE
+key string default
+value string default
+ds string
+hr string
+
+Detailed Table Information Table(tableName:srcpart, dbName:default, owner:null, createTime:1286921841, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.test.build/build/ql/test/data/warehouse/srcpart, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{transient_lastDdlTime=1286921841}, viewOriginalText:nul
l, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: describe extended srcpart.key
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended srcpart.key
+POSTHOOK: type: DESCTABLE
+key string from deserializer
+PREHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
+POSTHOOK: type: DESCTABLE
+key string default
+value string default
+ds string
+hr string
+
+Detailed Partition Information Partition(values:[2008-04-08, 12], dbName:default, tableName:srcpart, createTime:1286921842, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:pfile:/home/thiruvel/projects/hive/hive.test.build/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12, 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=1286921842})
+PREHOOK: query: describe formatted srcpart
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe formatted srcpart
+POSTHOOK: type: DESCTABLE
+# col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+# col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Oct 12 15:17:21 PDT 2010
+LastAccessTime: UNKNOWN
+Protect Mode: None
+Retention: 0
+Location: pfile:/home/thiruvel/projects/hive/hive.test.build/build/ql/test/data/warehouse/srcpart
+Table Type: MANAGED_TABLE
+Table Parameters:
+ transient_lastDdlTime 1286921841
+
+# 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
+PREHOOK: query: describe formatted srcpart.key
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe formatted srcpart.key
+POSTHOOK: type: DESCTABLE
+# col_name data_type comment
+
+key string from deserializer
+PREHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12')
+POSTHOOK: type: DESCTABLE
+# col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+# col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Partition Information
+Partition Value: [2008-04-08, 12]
+Database: default
+Table: srcpart
+CreateTime: Tue Oct 12 15:17:22 PDT 2010
+LastAccessTime: UNKNOWN
+Protect Mode: None
+Location: pfile:/home/thiruvel/projects/hive/hive.test.build/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+Partition Parameters:
+ transient_lastDdlTime 1286921842
+
+# 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
+PREHOOK: query: create table srcpart_serdeprops like srcpart
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table srcpart_serdeprops like srcpart
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@srcpart_serdeprops
+PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('xyz'='0')
+PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
+PREHOOK: Input: default@srcpart_serdeprops
+PREHOOK: Output: default@srcpart_serdeprops
+POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('xyz'='0')
+POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
+POSTHOOK: Input: default@srcpart_serdeprops
+POSTHOOK: Output: default@srcpart_serdeprops
+PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('pqrs'='1')
+PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
+PREHOOK: Input: default@srcpart_serdeprops
+PREHOOK: Output: default@srcpart_serdeprops
+POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('pqrs'='1')
+POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
+POSTHOOK: Input: default@srcpart_serdeprops
+POSTHOOK: Output: default@srcpart_serdeprops
+PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('abcd'='2')
+PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
+PREHOOK: Input: default@srcpart_serdeprops
+PREHOOK: Output: default@srcpart_serdeprops
+POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('abcd'='2')
+POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
+POSTHOOK: Input: default@srcpart_serdeprops
+POSTHOOK: Output: default@srcpart_serdeprops
+PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('A1234'='3')
+PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
+PREHOOK: Input: default@srcpart_serdeprops
+PREHOOK: Output: default@srcpart_serdeprops
+POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('A1234'='3')
+POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
+POSTHOOK: Input: default@srcpart_serdeprops
+POSTHOOK: Output: default@srcpart_serdeprops
+PREHOOK: query: describe formatted srcpart_serdeprops
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: describe formatted srcpart_serdeprops
+POSTHOOK: type: DESCTABLE
+# col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+# col_name data_type comment
+
+ds string None
+hr string None
+
+# Detailed Table Information
+Database: default
+Owner: null
+CreateTime: Tue Oct 12 15:17:25 PDT 2010
+LastAccessTime: UNKNOWN
+Protect Mode: None
+Retention: 0
+Location: pfile:/home/thiruvel/projects/hive/hive.test.build/build/ql/test/data/warehouse/srcpart_serdeprops
+Table Type: MANAGED_TABLE
+Table Parameters:
+ EXTERNAL FALSE
+ last_modified_by thiruvel
+ last_modified_time 1286921846
+ transient_lastDdlTime 1286921846
+
+# 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:
+ A1234 3
+ abcd 2
+ pqrs 1
+ serialization.format 1
+ xyz 0
+PREHOOK: query: drop table srcpart_serdeprops
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@srcpart_serdeprops
+PREHOOK: Output: default@srcpart_serdeprops
+POSTHOOK: query: drop table srcpart_serdeprops
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@srcpart_serdeprops
+POSTHOOK: Output: default@srcpart_serdeprops
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out Wed Oct 13 04:26:34 2010
@@ -4,53 +4,41 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a list structure in a thrift table
describe src_thrift.lint
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-lint array<int> from deserializer
+lint array<int> from deserializer
PREHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-$elem$ int from deserializer
+$elem$ int from deserializer
PREHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-$key$ string from deserializer
+$key$ string from deserializer
PREHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-$value$ string from deserializer
+$value$ string from deserializer
PREHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-myint int from deserializer
-mystring string from deserializer
-underscore_int int from deserializer
+myint int from deserializer
+mystring string from deserializer
+underscore_int int from deserializer
PREHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-myint int from deserializer
+myint int from deserializer
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Wed Oct 13 04:26:34 2010
@@ -40,34 +40,10 @@ PREHOOK: query: DESCRIBE EXTENDED dest1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED dest1
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:16:05 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/dest1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477365
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key int
+value string
+Detailed Table Information Table(tableName:dest1, dbName:default, owner:thiruvel, createTime:1286800022, 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/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286800022}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
@@ -83,11 +59,11 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-08_426_1865933645353720968/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-27-06_293_5581599167057805225/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-08_426_1865933645353720968/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-27-06_293_5581599167057805225/-mr-10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out Wed Oct 13 04:26:34 2010
@@ -40,34 +40,10 @@ PREHOOK: query: DESCRIBE EXTENDED dest1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED dest1
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:16:51 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/dest1
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477411
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+key int
+value string
+Detailed Table Information Table(tableName:dest1, dbName:default, owner:thiruvel, createTime:1286799930, 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/dest1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799930}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
@@ -83,11 +59,11 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-54_460_1149384812640316385/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-25-34_757_4775013083546657/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-14_08-16-54_460_1149384812640316385/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-25-34_757_4775013083546657/-mr-10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/index_creation.q.out Wed Oct 13 04:26:34 2010
@@ -30,35 +30,11 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_2__
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string default
-_bucketname string
-_offsets array<bigint>
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Tue Sep 14 08:20:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/default__src_src_index_2__
-Table Type: INDEX_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477633
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- serialization.format 1
+key string default
+_bucketname string
+_offsets array<bigint>
+Detailed Table Information Table(tableName:default__src_src_index_2__, dbName:default, owner:null, createTime:1286799495, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/default__src_src_index_2__, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799495}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: create index src_index_3 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_3
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_3 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_3
@@ -67,35 +43,11 @@ PREHOOK: query: desc extended src_idx_sr
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended src_idx_src_index_3
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string default
-_bucketname string
-_offsets array<bigint>
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Tue Sep 14 08:20:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/src_idx_src_index_3
-Table Type: INDEX_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477633
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- serialization.format 1
+key string default
+_bucketname string
+_offsets array<bigint>
+Detailed Table Information Table(tableName:src_idx_src_index_3, dbName:default, owner:null, createTime:1286799495, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/src_idx_src_index_3, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799495}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: create index src_index_4 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_4 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
@@ -104,36 +56,11 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_4__
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string default
-_bucketname string
-_offsets array<bigint>
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Tue Sep 14 08:20:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/default__src_src_index_4__
-Table Type: INDEX_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477633
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- serialization.format \t
- field.delim \t
+key string default
+_bucketname string
+_offsets array<bigint>
+Detailed Table Information Table(tableName:default__src_src_index_4__, dbName:default, owner:null, createTime:1286799495, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/default__src_src_index_4__, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format= , field.delim=
PREHOOK: query: create index src_index_5 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\'
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_5 on table src(key) as 'compact' WITH DEFERRED REBUILD ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\'
@@ -142,37 +69,11 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_5__
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string default
-_bucketname string
-_offsets array<bigint>
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Tue Sep 14 08:20:33 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/default__src_src_index_5__
-Table Type: INDEX_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477633
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- escape.delim \\
- serialization.format \t
- field.delim \t
+key string default
+_bucketname string
+_offsets array<bigint>
+Detailed Table Information Table(tableName:default__src_src_index_5__, dbName:default, owner:null, createTime:1286799495, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/default__src_src_index_5__, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{escape.delim=\, serialization.format= , field.delim=
PREHOOK: query: create index src_index_6 on table src(key) as 'compact' WITH DEFERRED REBUILD STORED AS RCFILE
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_6 on table src(key) as 'compact' WITH DEFERRED REBUILD STORED AS RCFILE
@@ -181,35 +82,11 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_6__
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string from deserializer
-_bucketname string from deserializer
-_offsets array<bigint> from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Tue Sep 14 08:20:34 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/default__src_src_index_6__
-Table Type: INDEX_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477634
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
-InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- serialization.format 1
+key string from deserializer
+_bucketname string from deserializer
+_offsets array<bigint> from deserializer
+Detailed Table Information Table(tableName:default__src_src_index_6__, dbName:default, owner:null, createTime:1286799495, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/default__src_src_index_6__, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799495}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: create index src_index_7 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_7 STORED AS RCFILE
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_index_7 on table src(key) as 'compact' WITH DEFERRED REBUILD in table src_idx_src_index_7 STORED AS RCFILE
@@ -218,35 +95,11 @@ PREHOOK: query: desc extended src_idx_sr
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended src_idx_src_index_7
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key string from deserializer
-_bucketname string from deserializer
-_offsets array<bigint> from deserializer
-
-# Detailed Table Information
-Database: default
-Owner: null
-CreateTime: Tue Sep 14 08:20:34 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/src_idx_src_index_7
-Table Type: INDEX_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477634
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
-InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: [Order(col:key, order:1)]
-Storage Desc Params:
- serialization.format 1
+key string from deserializer
+_bucketname string from deserializer
+_offsets array<bigint> from deserializer
+Detailed Table Information Table(tableName:src_idx_src_index_7, dbName:default, owner:null, createTime:1286799495, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:_bucketname, type:string, comment:), FieldSchema(name:_offsets, type:array<bigint>, comment:)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/src_idx_src_index_7, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[Order(col:key, order:1)], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286799495}, viewOriginalText:null, viewExpandedText:null, tableType:INDEX_TABLE)
PREHOOK: query: drop index src_index_2 on src
PREHOOK: type: DROPINDEX
POSTHOOK: query: drop index src_index_2 on src
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inoutdriver.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inoutdriver.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inoutdriver.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inoutdriver.q.out Wed Oct 13 04:26:34 2010
@@ -7,30 +7,6 @@ PREHOOK: query: desc extended test
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended test
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-
-# Detailed Table Information
-Database: default
-Owner: chauhana
-CreateTime: Wed Sep 29 10:52:37 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/Users/chauhana/workspace/howl-sprint2-hooks/build/ql/test/data/warehouse/test
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1285782757
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-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
+a int
+Detailed Table Information Table(tableName:test, dbName:default, owner:thiruvel, createTime:1286869048, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/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.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1286869048}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out Wed Oct 13 04:26:34 2010
@@ -31,7 +31,5 @@ PREHOOK: query: DESCRIBE TEST1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST1
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b double None
+a int
+b double
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out Wed Oct 13 04:26:34 2010
@@ -31,13 +31,7 @@ PREHOOK: query: DESCRIBE TEST10
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST10
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-hr string None
+key int
+value string
+ds string
+hr string
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out Wed Oct 13 04:26:34 2010
@@ -33,7 +33,5 @@ PREHOOK: query: DESCRIBE TEST15
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST15
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
+key int
+value string
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out Wed Oct 13 04:26:34 2010
@@ -7,18 +7,14 @@ PREHOOK: query: DESCRIBE TEST2a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST2a
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b double None
+a int
+b double
PREHOOK: query: DESC TEST2a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESC TEST2a
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b double None
+a int
+b double
PREHOOK: query: CREATE TABLE TEST2b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE TEST2b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
@@ -28,11 +24,9 @@ PREHOOK: query: DESCRIBE TEST2b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST2b
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a array<int> None
-b double None
-c map<double,int> None
+a array<int>
+b double
+c map<double,int>
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out Wed Oct 13 04:26:34 2010
@@ -7,10 +7,8 @@ PREHOOK: query: DESCRIBE TEST3a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3a
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a int None
-b double None
+a int
+b double
PREHOOK: query: CREATE TABLE TEST3b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE TEST3b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
@@ -20,11 +18,9 @@ PREHOOK: query: DESCRIBE TEST3b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3b
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a array<int> None
-b double None
-c map<double,int> None
+a array<int>
+b double
+c map<double,int>
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
@@ -72,12 +68,10 @@ PREHOOK: query: DESCRIBE TEST3b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3b
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a array<int> None
-b double None
-c map<double,int> None
-x double None
+a array<int>
+b double
+c map<double,int>
+x double
PREHOOK: query: EXPLAIN
ALTER TABLE TEST3b RENAME TO TEST3c
PREHOOK: type: ALTERTABLE_RENAME
@@ -112,12 +106,10 @@ PREHOOK: query: DESCRIBE TEST3c
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3c
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-a array<int> None
-b double None
-c map<double,int> None
-x double None
+a array<int>
+b double
+c map<double,int>
+x double
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
@@ -165,33 +157,7 @@ PREHOOK: query: DESCRIBE EXTENDED TEST3c
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED TEST3c
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-r1 int None
-r2 double None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:23:52 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/test3c
-Table Type: MANAGED_TABLE
-Table Parameters:
- last_modified_by thiruvel
- last_modified_time 1284477832
- transient_lastDdlTime 1284477832
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+r1 int
+r2 double
+Detailed Table Information Table(tableName:test3c, dbName:default, owner:thiruvel, createTime:1286799236, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:r1, type:int, comment:null), FieldSchema(name:r2, type:double, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/test3c, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=thiruvel, last_modified_time=1286799237, transient_lastDdlTime=1286799237}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out Wed Oct 13 04:26:34 2010
@@ -101,50 +101,20 @@ POSTHOOK: query: DESCRIBE EXTENDED part_
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).a SIMPLE []
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).b SIMPLE []
-col_name data_type comment
-
-a string None
-b string None
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-ts string None
-
-# Detailed Partition Information
-Partition Value: [2008 04 08, 10:11:12=455]
-Database: default
-Table: part_special
-CreateTime: Mon Sep 20 23:55:13 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/part_special/ds=2008 04 08/ts=10%3A11%3A12%3D455
-Partition Parameters:
- numFiles 1
- transient_lastDdlTime 1285052113
- numRows 1
- totalSize 4
-
-# 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
+ds string
+ts string
+Detailed Partition Information Partition(values:[2008 04 08, 10:11:12=455], dbName:default, tableName:part_special, createTime:1286799702, lastAccessTime: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/part_special/ds=2008 04 08/ts=10%3A11%3A12%3D455, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1286799702, numRows=1, totalSize=4})
PREHOOK: query: SELECT * FROM part_special WHERE ds='2008 04 08' AND ts = '10:11:12=455'
PREHOOK: type: QUERY
PREHOOK: Input: default@part_special@ds=2008 04 08/ts=10%3A11%3A12%3D455
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-55-13_931_8974375359528209894/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-21-42_889_255644628587795756/-mr-10000
POSTHOOK: query: SELECT * FROM part_special WHERE ds='2008 04 08' AND ts = '10:11:12=455'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part_special@ds=2008 04 08/ts=10%3A11%3A12%3D455
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-20_23-55-13_931_8974375359528209894/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-21-42_889_255644628587795756/-mr-10000
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).a SIMPLE []
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).b SIMPLE []
1 2 2008 04 08 10:11:12=455
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out Wed Oct 13 04:26:34 2010
@@ -33,13 +33,7 @@ PREHOOK: query: DESCRIBE INPUTDDL2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL2
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-country string None
+key int
+value string
+ds string
+country string
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out Wed Oct 13 04:26:34 2010
@@ -33,7 +33,5 @@ PREHOOK: query: DESCRIBE INPUTDDL3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL3
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-key int None
-value string None
+key int
+value string
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out Wed Oct 13 04:26:34 2010
@@ -23,62 +23,27 @@ PREHOOK: query: DESCRIBE INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL4
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-viewtime string None
-userid int None
-page_url string None
-referrer_url string None
-friends array<bigint> None
-properties map<string,string> None
-ip string IP Address of the User
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-country string None
+viewtime string
+userid int
+page_url string
+referrer_url string
+friends array<bigint>
+properties map<string,string>
+ip string IP Address of the User
+ds string
+country string
PREHOOK: query: DESCRIBE EXTENDED INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-viewtime string None
-userid int None
-page_url string None
-referrer_url string None
-friends array<bigint> None
-properties map<string,string> None
-ip string IP Address of the User
-
-# Partition Information
-col_name data_type comment
-
-ds string None
-country string None
-
-# Detailed Table Information
-Database: default
-Owner: thiruvel
-CreateTime: Tue Sep 14 08:20:54 PDT 2010
-LastAccessTime: Wed Dec 31 16:00:00 PST 1969
-Protect Mode: None
-Retention: 0
-Location: pfile:/home/thiruvel/projects/hive/hive/build/ql/test/data/warehouse/inputddl4
-Table Type: MANAGED_TABLE
-Table Parameters:
- transient_lastDdlTime 1284477654
- comment This is the page view table
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: 32
-Bucket Columns: [userid]
-Sort Columns: [Order(col:viewtime, order:1)]
-Storage Desc Params:
- serialization.format 1
+viewtime string
+userid int
+page_url string
+referrer_url string
+friends array<bigint>
+properties map<string,string>
+ip string IP Address of the User
+ds string
+country string
+Detailed Table Information Table(tableName:inputddl4, dbName:default, owner:thiruvel, createTime:1286798568, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:viewtime, type:string, comment:null), FieldSchema(name:userid, type:int, comment:null), FieldSchema(name:page_url, type:string, comment:null), FieldSchema(name:referrer_url, type:string, comment:null), FieldSchema(name:friends, type:array<bigint>, comment:null), FieldSchema(name:properties, type:map<string,string>, comment:null), FieldSchema(name:ip, type:string, comment:IP Address of the User), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/inputddl4, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:32, serdeInfo:SerDeInfo(name:null, serialization
Lib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[userid], sortCols:[Order(col:viewtime, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], parameters:{transient_lastDdlTime=1286798568, comment=This is the page view table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out?rev=1021992&r1=1021991&r2=1021992&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out Wed Oct 13 04:26:34 2010
@@ -16,24 +16,22 @@ PREHOOK: query: DESCRIBE INPUTDDL5
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL5
POSTHOOK: type: DESCTABLE
-col_name data_type comment
-
-name string None
+name string
PREHOOK: query: SELECT INPUTDDL5.name from INPUTDDL5
PREHOOK: type: QUERY
PREHOOK: Input: default@inputddl5
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-23-57_837_3762384530254196250/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-10-24_142_4717365799469321057/-mr-10000
POSTHOOK: query: SELECT INPUTDDL5.name from INPUTDDL5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputddl5
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-23-57_837_3762384530254196250/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-10-24_142_4717365799469321057/-mr-10000
éµé®
PREHOOK: query: SELECT count(1) FROM INPUTDDL5 WHERE INPUTDDL5.name = _UTF-8 0xE982B5E993AE
PREHOOK: type: QUERY
PREHOOK: Input: default@inputddl5
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-24-00_215_9153901156666305334/-mr-10000
+PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-10-26_576_1899173500377396904/-mr-10000
POSTHOOK: query: SELECT count(1) FROM INPUTDDL5 WHERE INPUTDDL5.name = _UTF-8 0xE982B5E993AE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputddl5
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-09-16_06-24-00_215_9153901156666305334/-mr-10000
+POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_05-10-26_576_1899173500377396904/-mr-10000
1