PageRenderTime 17ms CodeModel.GetById 13ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/inputddl8.q.out

#
text | 31 lines | 30 code | 1 blank | 0 comment | 0 complexity | 05f432db90ebf43073792180e6688ca1 MD5 | raw file
 1PREHOOK: query: CREATE TABLE INPUTDDL8 COMMENT 'This is a thrift based table'
 2    PARTITIONED BY(ds STRING, country STRING)
 3    CLUSTERED BY(aint) SORTED BY(lint) INTO 32 BUCKETS
 4    ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer'
 5    WITH SERDEPROPERTIES ('serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex',
 6                          'serialization.format' = 'com.facebook.thrift.protocol.TBinaryProtocol')
 7    STORED AS SEQUENCEFILE
 8PREHOOK: type: CREATETABLE
 9POSTHOOK: query: CREATE TABLE INPUTDDL8 COMMENT 'This is a thrift based table'
10    PARTITIONED BY(ds STRING, country STRING)
11    CLUSTERED BY(aint) SORTED BY(lint) INTO 32 BUCKETS
12    ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer'
13    WITH SERDEPROPERTIES ('serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex',
14                          'serialization.format' = 'com.facebook.thrift.protocol.TBinaryProtocol')
15    STORED AS SEQUENCEFILE
16POSTHOOK: type: CREATETABLE
17POSTHOOK: Output: default@INPUTDDL8
18PREHOOK: query: DESCRIBE EXTENDED INPUTDDL8
19PREHOOK: type: DESCTABLE
20POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL8
21POSTHOOK: type: DESCTABLE
22aint	int	from deserializer
23astring	string	from deserializer
24lint	array<int>	from deserializer
25lstring	array<string>	from deserializer
26lintstring	array<org.apache.hadoop.hive.serde2.thrift.test.IntString>	from deserializer
27mstringstring	map<string,string>	from deserializer
28ds	string	
29country	string	
30	 	 
31Detailed Table Information	Table(tableName:inputddl8, dbName:default, owner:thiruvel, createTime:1286797863, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/inputddl8, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:32, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer, parameters:{serialization.class=org.apache.hadoop.hive.serde2.thrift.test.Complex, serialization.format=com.facebook.thrift.protocol.TBinaryProtocol}), bucketCols:[aint], sortCols:[Order(col:lint, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], parameters:{transient_lastDdlTime=1286797863, comment=This is a thrift based table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)