Skip to content

Instantly share code, notes, and snippets.

@gajoseph
Created May 21, 2018 21:47
Show Gist options
  • Save gajoseph/e3368ac4b1f66a3440430dbeed3164e7 to your computer and use it in GitHub Desktop.
Save gajoseph/e3368ac4b1f66a3440430dbeed3164e7 to your computer and use it in GitHub Desktop.
Create a table and Db in aws Athena
create database clindb;
CREATE EXTERNAL TABLE IF NOT EXISTS comp_logs (
`Date_Received` Date,
product STRING,
sub_product STRING,
issue INT,
sub_issue STRING,
Consumer_comp STRING,
comp_pub_response STRING,
comp_name STRING,
state string,
zip STRING,
tags String,
consumer_Consetn_provided String,
Submitted_via String,
Date_sent_to_company date,
Company_response_to_consumer String ,
Timely_response string,
Consumer_disputed String ,
Complaint_ID String
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'serialization.format' = ',',
'field.delim' = ','
) LOCATION 's3://mybucclindb/comp'
TBLPROPERTIES ('has_encrypted_data'='false');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment