Skip to content

Instantly share code, notes, and snippets.

@hadoopsters

hadoopsters/ctas_hive_table.hql

Last active December 19, 2017 14:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hadoopsters/c7aa3106140fd40a827282b12153d4e5 to your computer and use it in GitHub Desktop.
Save hadoopsters/c7aa3106140fd40a827282b12153d4e5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ctas_hive_table.hql
CREATE TABLE my_database.my_table
STORED AS ORC TBLPROPERTIES('ORC.COMPRESS'='SNAPPY') as
SELECT * FROM my_database.my_other_table WHERE YEAR=2017 AND MONTH=11 AND DAY=30;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment