Can't create external table output from my hive query
<p>I have a .csv file containing data about crime incidences in Philadelphia.
I am using a hive script in amazon EMR to convert this data into a HIVE table.</p>

<p>I am using the following hive script:</p>

<pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS Crime(
Dc_Dist INT, 
PSA INT,
Dispatch_Date_Time TIMESTAMP,
Dispatch_Date date,
Dispatch_Time STRING, 
Hour INT,
Dc_Key BIGINT,
Location_Block STRING,
UCR_General INT,
Text_General_Code STRING,
Police_Districts INT,
Month STRING,
Lon STRING,  
Lat STRING)

COMMENT 'Data about crime from a public database'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
location 's3://dsabucket/crimeData/crime';
</code></pre>

<p><a href="https://i.stack.imgur.com/NuiRu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NuiRu.png" alt="This image is a screenshot of the workflow I follow to run the hive script on the AWS EMR cluster]"></a></p>

<p>I run this script but I do not get a file or data in my output folder. I am not sure if the table is created properly or not. As I understand the 'STORED AS TEXTFILE' line should store this table as a textfile.</p>