Kontext Copilot - An AI-powered assistant for data analytics that runs on your local computer. Learn more Get started

hive sql parquet

Create Partitioned Hive Table

event 2021-12-23 thumb_up 0 visibility 465 comment 0 insights

more_vert

warning Please login first to view stats information.

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

Code snippet

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.

info Last modified by Raymond 3 years ago copyright This page is subject to Site terms.

Create Partitioned Hive Table

insights Stats

Code snippet

Log in with external accounts

Create Partitioned Hive Table

insights Stats

Table of contents

Code snippet

Log in with external accounts