Create Partitioned Hive Table
Raymond visibility 247 event 2021-12-23 access_time 2 years ago language English
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.
No comments yet.