Skip to content

Instantly share code, notes, and snippets.

@pavlov99

pavlov99/blog-lookup-table-2-external-table.hive

Created September 17, 2016 08:42
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 pavlov99/8546456937523f17a071e8d2f5029136 to your computer and use it in GitHub Desktop.
Save pavlov99/8546456937523f17a071e8d2f5029136 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
blog-lookup-table-2-external-table.hive
CREATE EXTERNAL TABLE IF NOT EXISTS lookup_example_nhl_ext(
team String,
division String,
conference String)
COMMENT 'NHL teams'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION 'hdfs:///user/<user>/lookup-example/nhl-lookup'
TBLPROPERTIES ("skip.header.line.count"="1");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment