Create Partitioned Hive Table

event 2021-12-23 visibility 465 comment 0 insights
more_vert
insights Stats
Raymond Raymond Code Snippets & Tips

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise. 

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