query: -- test for describe extended table
-- test for describe extended table partition
-- test for alter table drop partition
DROP TABLE INPUTDDL6
query: CREATE TABLE INPUTDDL6(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME) STORED AS TEXTFILE
query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-09')
query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-08')
query: DESCRIBE EXTENDED INPUTDDL6
key	string	
value	string	
ds	datetime	
	 	 
Detailed Table Information	Table(tableName:inputddl6,dbName:default,owner:njain,createTime:1242172817,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/njain/hive5/hive5/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:datetime,comment:null)],parameters:{})	
query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08')
key	string	
value	string	
ds	datetime	
	 	 
Detailed Partition Information	Partition(values:[2008-04-08],dbName:default,tableName:inputddl6,createTime:0,lastAccessTime:0,sd:StorageDescriptor(cols:[FieldSchema(name:key,type:string,comment:null), FieldSchema(name:value,type:string,comment:null)],location:file:/data/users/njain/hive5/hive5/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:{})	
query: SHOW PARTITIONS INPUTDDL6
ds=2008-04-08
ds=2008-04-09
query: ALTER TABLE INPUTDDL6 DROP PARTITION (ds='2008-04-08')
query: SHOW PARTITIONS INPUTDDL6
ds=2008-04-09
query: DROP TABLE INPUTDDL6
query: EXPLAIN
DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-09')
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