Last active
May 12, 2022 20:47
-
-
Save kamipatel/03f121f51365b858bd39c3651bfd299d to your computer and use it in GitHub Desktop.
ebikesorder-athena-ddl
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE EXTERNAL TABLE `ebikesorder`( | |
| `id` string, | |
| `orderdatetime` string, | |
| `account` string, | |
| `amount` decimal(10,2), | |
| `model` string, | |
| `quantity` decimal(10,0), | |
| `status` string) | |
| ROW FORMAT DELIMITED | |
| FIELDS TERMINATED BY ',' | |
| STORED AS INPUTFORMAT | |
| 'org.apache.hadoop.mapred.TextInputFormat' | |
| OUTPUTFORMAT | |
| 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | |
| LOCATION | |
| 's3://ebikes-data-1/data/' | |
| TBLPROPERTIES ("skip.header.line.count"="1") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment