Skip to content

Instantly share code, notes, and snippets.

@hadoopsters

hadoopsters/create_hive_table_basic.hql

Created December 19, 2017 01:47
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/6d824e00bc01f6fab79637f42e4e9eba to your computer and use it in GitHub Desktop.
Save hadoopsters/6d824e00bc01f6fab79637f42e4e9eba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_hive_table_basic.hql
CREATE TABLE my_database.my_table
(
column_1 string,
column_2 int,
column_3 double
)
STORED AS ORC
TBLPROPERTIES('ORC.COMPRESS'='SNAPPY'); -- ensure SNAPPY is uppercase, lowercase triggers a nasty bug in Hive (fixed in later versions)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment