Create Partitioned Hive Table

visibility 55 access_time 5 months ago languageEnglish

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 0.37
More from Kontext
Teradata: PIVOT and UNPIVOT Clause
visibility 1,005
thumb_up 0
access_time 10 months ago
Teradata: FIRST_VALUE and LAST_VALUE Funtions
visibility 425
thumb_up 0
access_time 10 months ago
Install Hadoop 3.0.0 on Windows (Single Node)
visibility 50,737
thumb_up 6
access_time 2 years ago
Install Hadoop 3.0.0 on Windows (Single Node)