external_table.hql

CREATE EXTERNAL TABLE raw_facts (
dimension1 STRING,
dimension2 STRING,
dimension3 STRING,
dimension4 STRING,
timestamp1 TIMESTAMP,
timestamp2 TIMESTAMP,
measure1 DECIMAL,
measure2 DECIMAL,
measure3 DECIMAL
) ROW FORMAT
DELIMITED FIELDS TERMINATED BY ','
ESCAPED BY '\\'
STORED AS TEXTFILE
LOCATION 's3n://my-bucket/my-prefix/';