Skip to content

Instantly share code, notes, and snippets.

@velotiotech

velotiotech/gist:8a50df1cc6a7b8190bb6cc83a6e07295

Created June 11, 2020 07:54
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 velotiotech/8a50df1cc6a7b8190bb6cc83a6e07295 to your computer and use it in GitHub Desktop.
Save velotiotech/8a50df1cc6a7b8190bb6cc83a6e07295 to your computer and use it in GitHub Desktop.
Download ZIP
create contact_details query
Raw
gistfile1.txt
CREATE EXTERNAL TABLE `contact_details`(
`id` int COMMENT '',
`street` string COMMENT '',
`city` string COMMENT '',
`state` string COMMENT '',
`country` string COMMENT '',
`zip` string COMMENT '')
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
's3://athena-blog/contact-details'
TBLPROPERTIES (
'has_encrypted_data'='false',
'skip.header.line.count'='1')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment