g2dLMz4Z

1CREATE EXTERNAL TABLE IF NOT EXISTS lookup_example_nhl_ext(
2    team String,
3    division String,
4    conference String)
5  COMMENT 'NHL teams'
6  ROW FORMAT DELIMITED
7  FIELDS TERMINATED BY ','
8  LINES TERMINATED BY '\n'
9  STORED AS TEXTFILE
10  LOCATION 'hdfs:///user/<user>/lookup-example/nhl-lookup'
11  TBLPROPERTIES ("skip.header.line.count"="1");