PREHOOK: query: -- test for describe extended table
-- test for describe extended table partition
-- test for alter table drop partition
DROP TABLE INPUTDDL6
PREHOOK: type: DROPTABLE
POSTHOOK: query: -- test for describe extended table
-- test for describe extended table partition
-- test for alter table drop partition
DROP TABLE INPUTDDL6
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE INPUTDDL6(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: 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
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@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
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@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:pyang, createTime:1264209075, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/data/users/pyang/task2/trunk/VENDOR.hive/trunk/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=1264209075}, viewOriginalText:null, viewExpandedText:null)	
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:1264209075, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/data/users/pyang/task2/trunk/VENDOR.hive/trunk/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=1264209075})	
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
POSTHOOK: query: ALTER TABLE INPUTDDL6 DROP PARTITION (ds='2008-04-08')
POSTHOOK: type: ALTERTABLE_DROPPARTS
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
POSTHOOK: query: DROP TABLE INPUTDDL6
POSTHOOK: type: DROPTABLE
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