9K3xQawf

1CREATE EXTERNAL TABLE IF NOT EXISTS Crime(
2Dc_Dist INT, 
3PSA INT,
4Dispatch_Date_Time TIMESTAMP,
5Dispatch_Date date,
6Dispatch_Time STRING, 
7Hour INT,
8Dc_Key BIGINT,
9Location_Block STRING,
10UCR_General INT,
11Text_General_Code STRING,
12Police_Districts INT,
13Month STRING,
14Lon STRING,  
15Lat STRING)
16
17COMMENT 'Data about crime from a public database'
18ROW FORMAT DELIMITED
19FIELDS TERMINATED BY ','
20STORED AS TEXTFILE
21location 's3://dsabucket/crimeData/crime';