CREATE EXTERNAL TABLE `athletes_full_2021`(
  `name` string COMMENT 'from deserializer', 
  `short_name` string COMMENT 'from deserializer', 
  `gender` string COMMENT 'from deserializer', 
  `birth_date` string COMMENT 'from deserializer', 
  `birth_place` string COMMENT 'from deserializer', 
  `birth_country` string COMMENT 'from deserializer', 
  `country` string COMMENT 'from deserializer', 
  `country_code` string COMMENT 'from deserializer', 
  `discipline` string COMMENT 'from deserializer', 
  `discipline_code` string COMMENT 'from deserializer', 
  `residence_place` string COMMENT 'from deserializer', 
  `residence_country` string COMMENT 'from deserializer', 
  `height_m/ft` string COMMENT 'from deserializer', 
  `url` string COMMENT 'from deserializer')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.serde2.OpenCSVSerde' 
WITH SERDEPROPERTIES ( 
  'quoteChar'='\"', 
  'separatorChar'=',') 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  's3://<<s3 bucket name>>/olympics2021/athletes_full'
TBLPROPERTIES (
  'areColumnsQuoted'='true', 
  'classification'='csv', 
  'columnsOrdered'='true', 
  'compressionType'='none', 
  'delimiter'=',', 
  'skip.header.line.count'='1',
  'typeOfData'='file')