Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
create bill_details queryy
CREATE EXTERNAL TABLE `bil_details`(
`id` int COMMENT '',
`amount_paid` string COMMENT '',
`amount_due` 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/bill-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