blob: 2e1ea6b0056184adec887cd6337158462cbbba5f [file] [log] [blame]
CREATE TABLE inv_valid_tbl1 COMMENT 'This is a thrift based table'
PARTITIONED BY(aint DATETIME, country STRING)
CLUSTERED BY(aint) SORTED BY(lint) INTO 32 BUCKETS
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer'
WITH SERDEPROPERTIES ('serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex',
'serialization.format' = 'org.apache.thrift.protocol.TBinaryProtocol')
STORED AS SEQUENCEFILE;
DESCRIBE EXTENDED inv_valid_tbl1;