| 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; |