Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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