4PUBkVZ8

1CREATE EXTERNAL TABLE IF NOT EXISTS sacramento.crime_data (
2               ts VARCHAR(255),
3               address VARCHAR(255),
4               district INT,
5               beat VARCHAR(255),
6               grid INT,
7               crimedescr VARCHAR(255),
8               ucr_ncic_code INT,
9               latitude FLOAT,
10               longitude FLOAT
11               )
12               ROW FORMAT DELIMITED
13               FIELDS TERMINATED BY ','
14               LINES TERMINATED BY '\n'
15               LOCATION '{S3_INPUT_DIR}';