THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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
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;
...