Create Partitioned Hive Table

visibility 99 access_time 8 months ago languageEnglish
more_vert

This page shows you how to create partitioned hive table.

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.

copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts