...
- Apache Avro
- Apache Thrift
- Google Protocol Buffers
For the The latest information on Parquet formats engine and data description support, please visit the Parquet-MR projects feature matrix.
...
Hive QL Syntax
Hive 0.10 - 0.12
No Format |
---|
CREATE TABLE parquet_test ( id int, str string, mp MAP<STRING,STRING>, lst ARRAY<STRING>, strct STRUCT<A:STRING,B:STRING>) PARTITIONED BY (part string) ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe' STORED AS INPUTFORMAT 'parquet.hive.DeprecatedParquetInputFormat' OUTPUTFORMAT 'parquet.hive.DeprecatedParquetOutputFormat'; |
...
Hive 0.13
...
No Format |
---|
CREATE TABLE parquet_test ( |
...
id int, |
...
str string, |
...
mp MAP<STRING,STRING>, |
...
lst ARRAY<STRING>, |
...
strct STRUCT<A:STRING,B:STRING>) |
...
PARTITIONED BY (part string) |
...
STORED AS PARQUET; |
Limitations
- Binary, timestamp, date, char, varchar or decimal support are pending (HIVE-6384)
- Create Table AS SELECT (CTAS) and column rename support are pending (HIVE-6375)
...