Kontext Copilot - An AI-powered assistant for data analytics that runs on your local computer. Learn more
Get started
Create Partitioned Hive Table
insights Stats
warning Please login first to view stats information.
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.
info Last modified by Raymond 3 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.