access_time 8 months ago languageEnglish

Create Table as SELECT - Hive SQL

visibility 1,105 comment 0
This page shows how to create a managed(internal) Hive table from a SELECT statement via Hive SQL (HQL). Example: CREATE TABLE IF NOT EXISTS hql.transactions_copy STORED AS PARQUET AS SELECT * FROM hql.transactions; A MapReduce job will be submitted to create the table from SELECT statement.
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