PREHOOK: query: -- test for describe extended table -- test for describe extended table partition -- test for alter table drop partition CREATE TABLE INPUTDDL6(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: -- test for describe extended table -- test for describe extended table partition -- test for alter table drop partition CREATE TABLE INPUTDDL6(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@INPUTDDL6 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-09') PREHOOK: type: LOAD PREHOOK: Output: default@inputddl6 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-09') POSTHOOK: type: LOAD POSTHOOK: Output: default@inputddl6 POSTHOOK: Output: default@inputddl6@ds=2008-04-09 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-08') PREHOOK: type: LOAD PREHOOK: Output: default@inputddl6 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-08') POSTHOOK: type: LOAD POSTHOOK: Output: default@inputddl6 POSTHOOK: Output: default@inputddl6@ds=2008-04-08 PREHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6 POSTHOOK: type: DESCTABLE key string value string ds string Detailed Table Information Table(tableName:inputddl6, dbName:default, owner:krishnak, createTime:1300690725, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/inputddl6, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{transient_lastDdlTime=1300690725}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08') PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08') POSTHOOK: type: DESCTABLE key string value string ds string Detailed Partition Information Partition(values:[2008-04-08], dbName:default, tableName:inputddl6, createTime:1300690728, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/inputddl6/ds=2008-04-08, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1300690728}) PREHOOK: query: SHOW PARTITIONS INPUTDDL6 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS INPUTDDL6 POSTHOOK: type: SHOWPARTITIONS ds=2008-04-08 ds=2008-04-09 PREHOOK: query: ALTER TABLE INPUTDDL6 DROP PARTITION (ds='2008-04-08') PREHOOK: type: ALTERTABLE_DROPPARTS PREHOOK: Input: default@inputddl6 PREHOOK: Output: default@inputddl6@ds=2008-04-08 POSTHOOK: query: ALTER TABLE INPUTDDL6 DROP PARTITION (ds='2008-04-08') POSTHOOK: type: ALTERTABLE_DROPPARTS POSTHOOK: Input: default@inputddl6 POSTHOOK: Output: default@inputddl6@ds=2008-04-08 PREHOOK: query: SHOW PARTITIONS INPUTDDL6 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS INPUTDDL6 POSTHOOK: type: SHOWPARTITIONS ds=2008-04-09 PREHOOK: query: DROP TABLE INPUTDDL6 PREHOOK: type: DROPTABLE PREHOOK: Input: default@inputddl6 PREHOOK: Output: default@inputddl6 POSTHOOK: query: DROP TABLE INPUTDDL6 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@inputddl6 POSTHOOK: Output: default@inputddl6 PREHOOK: query: EXPLAIN DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-09') PREHOOK: type: DESCTABLE POSTHOOK: query: EXPLAIN DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-09') POSTHOOK: type: DESCTABLE ABSTRACT SYNTAX TREE: (TOK_DESCTABLE (TOK_TABTYPE INPUTDDL6 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-09'))) EXTENDED) STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 is a root stage STAGE PLANS: Stage: Stage-0 Describe Table Operator: Describe Table partition: ds 2008-04-09 table: INPUTDDL6 Stage: Stage-1 Fetch Operator limit: -1