Create Partitioned Hive Table

Raymond Raymond event 2021-12-23 visibility 486
more_vert

This page shows you how to create partitioned hive table that uses parquet as storage format.

Code snippet

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.

More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts