LMEJ4hxV

1DROP TABLE IF EXISTS temp_Athletes PURGE; 
2CREATE TEMPORARY EXTERNAL TABLE IF NOT EXISTS temp_Athletes(
3  AthleteID			BIGINT,
4  Name				STRING,
5  Nationality		STRING,
6  Sex				STRING,
7  DoB				SMALLINT,
8  Height			FLOAT,
9  Weight			INT,
10  Sport				STRING,
11  Gold				INT,
12  Silver			INT,
13  Bronze			INT)
14  
15  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
16with serdeproperties (
17  "separatorChar" = ",",
18  "quoteChar"     = "\"")
19  STORED AS TEXTFILE
20  LOCATION '/user/kohnkeklau'
21  TBLPROPERTIES ('skip.header.line.count'='1');