access_time 8 months ago languageEnglish

Create Partitioned Table - Hive SQL

visibility 966 comment 0
This page shows how to create partitioned Hive tables via Hive SQL (HQL). Example: CREATE TABLE IF NOT EXISTS hql.transactions(txn_id BIGINT, cust_id INT, amount DECIMAL(20,2),txn_type STRING, created_date DATE) COMMENT 'A table to store transactions' PARTITIONED BY (txn_date DATE) STORED AS ...
info Last modified by Administrator 8 months ago
thumb_up 0

comment Comments

No comments yet.

Forum discussions for column Hadoop.

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to contribute on Kontext to help others?

Learn more