hsdLGagh

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