You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/05/13 18:14:47 UTC
svn commit: r1594261 - in /hive/trunk/ql/src/test:
queries/clientpositive/describe_table.q
results/clientpositive/describe_table.q.out
Author: hashutosh
Date: Tue May 13 16:14:46 2014
New Revision: 1594261
URL: http://svn.apache.org/r1594261
Log:
HIVE-6187 : Add test to verify that DESCRIBE TABLE works with quoted table names (Carl Steinbach via Ashutosh Chauhan)
Modified:
hive/trunk/ql/src/test/queries/clientpositive/describe_table.q
hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out
Modified: hive/trunk/ql/src/test/queries/clientpositive/describe_table.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/describe_table.q?rev=1594261&r1=1594260&r2=1594261&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/describe_table.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/describe_table.q Tue May 13 16:14:46 2014
@@ -2,14 +2,26 @@ describe srcpart;
describe srcpart.key;
describe srcpart PARTITION(ds='2008-04-08', hr='12');
+describe `srcpart`;
+describe `srcpart`.`key`;
+describe `srcpart` PARTITION(ds='2008-04-08', hr='12');
+
describe extended srcpart;
describe extended srcpart.key;
describe extended srcpart PARTITION(ds='2008-04-08', hr='12');
+describe extended `srcpart`;
+describe extended `srcpart`.`key`;
+describe extended `srcpart` PARTITION(ds='2008-04-08', hr='12');
+
describe formatted srcpart;
describe formatted srcpart.key;
describe formatted srcpart PARTITION(ds='2008-04-08', hr='12');
+describe formatted `srcpart`;
+describe formatted `srcpart`.`key`;
+describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12');
+
create table srcpart_serdeprops like srcpart;
alter table srcpart_serdeprops set serdeproperties('xyz'='0');
alter table srcpart_serdeprops set serdeproperties('pqrs'='1');
Modified: hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out?rev=1594261&r1=1594260&r2=1594261&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/describe_table.q.out Tue May 13 16:14:46 2014
@@ -37,6 +37,45 @@ hr string
ds string
hr string
+PREHOOK: query: describe `srcpart`
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe `srcpart`
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+key string default
+value string default
+ds string
+hr string
+
+# Partition Information
+# col_name data_type comment
+
+ds string
+hr string
+PREHOOK: query: describe `srcpart`.`key`
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe `srcpart`.`key`
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+key string from deserializer
+PREHOOK: query: describe `srcpart` PARTITION(ds='2008-04-08', hr='12')
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe `srcpart` PARTITION(ds='2008-04-08', hr='12')
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+key string default
+value string default
+ds string
+hr string
+
+# Partition Information
+# col_name data_type comment
+
+ds string
+hr string
PREHOOK: query: describe extended srcpart
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@srcpart
@@ -80,6 +119,49 @@ ds string
hr string
#### A masked pattern was here ####
+PREHOOK: query: describe extended `srcpart`
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe extended `srcpart`
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+key string default
+value string default
+ds string
+hr string
+
+# Partition Information
+# col_name data_type comment
+
+ds string
+hr string
+
+#### A masked pattern was here ####
+PREHOOK: query: describe extended `srcpart`.`key`
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe extended `srcpart`.`key`
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+key string from deserializer
+PREHOOK: query: describe extended `srcpart` PARTITION(ds='2008-04-08', hr='12')
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe extended `srcpart` PARTITION(ds='2008-04-08', hr='12')
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+key string default
+value string default
+ds string
+hr string
+
+# Partition Information
+# col_name data_type comment
+
+ds string
+hr string
+
+#### A masked pattern was here ####
PREHOOK: query: describe formatted srcpart
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@srcpart
@@ -168,6 +250,94 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
+PREHOOK: query: describe formatted `srcpart`
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe formatted `srcpart`
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+# col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+# col_name data_type comment
+
+ds string
+hr string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Protect Mode: None
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+#### A masked pattern was here ####
+
+# 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
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe formatted `srcpart`.`key`
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+# col_name data_type comment
+
+key string from deserializer
+PREHOOK: query: describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12')
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@srcpart
+POSTHOOK: query: describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12')
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@srcpart
+# col_name data_type comment
+
+key string default
+value string default
+
+# Partition Information
+# col_name data_type comment
+
+ds string
+hr string
+
+# Detailed Partition Information
+Partition Value: [2008-04-08, 12]
+Database: default
+Table: srcpart
+#### A masked pattern was here ####
+Protect Mode: None
+#### A masked pattern was here ####
+Partition Parameters:
+ COLUMN_STATS_ACCURATE true
+ numFiles 1
+ numRows 0
+ rawDataSize 0
+ totalSize 5812
+#### A masked pattern was here ####
+
+# 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
PREHOOK: Output: database:default