DROP TABLE IF EXISTS temp_Athletes PURGE;
CREATE TEMPORARY EXTERNAL TABLE IF NOT EXISTS temp_Athletes(
  AthleteID			BIGINT,
  Name				STRING,
  Nationality		STRING,
  Sex				STRING,
  DoB				SMALLINT,
  Height			FLOAT,
  Weight			INT,
  Sport				STRING,
  Gold				INT,
  Silver			INT,
  Bronze			INT)

  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
with serdeproperties (
  "separatorChar" = ",",
  "quoteChar"     = "\"")
  STORED AS TEXTFILE
  LOCATION '/user/kohnkeklau'
  TBLPROPERTIES ('skip.header.line.count'='1');