Create Partitioned Hive Table
warning Please login first to view stats information.
toc Table of contents
This page shows you how to create partitioned hive table that uses parquet as storage format.
use test_db; CREATE TABLE p_table(attr_1 INT, attr_2 STRING) PARTITIONED BY (attr_3 INT) STORED AS PARQUET;
The above SQL scripts create a partitioned table named p_table and it is partitioned by column attr_3. The data is stored as parquet format.
info Last modified by Raymond 2 years ago copyright This page is subject to Site terms.