loading geospatial data into table

Hi,

As per the documentation, you need to store "earthquakes.csv" and "california-counties.json" inside of the folder in the S3 bucket.

If you look at the sample earthquake code example, you need to mention the s3 folder path (TEXTFILE LOCATION) when you run the query.

CREATE external TABLE earthquakes ( earthquake_date string, latitude double, longitude double, depth double, magnitude double, magtype string, mbstations string, gap string, distance string, rms string, source string, eventid string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION 's3://<your_bucket_name/csv/';

You need to store the .csv file under "csv" folder inside your bucket. Likewise, you also need to store the .json file under "csv" folder inside your bucket.

Make sure you set the Query result location parameter in "Query result and encryption settings" under the settings tab in Athena Console.

Once you do, then you can run the queries and you'll see all the records created in the Athena data catalog table.

Note: Do not add the S3 object name at the end of the TEXTFILE LOCATION in earquake sql table query as well as LOCATION in countries sql query.

For eg. add s3://bucketabc/csv/ instead of s3://<your_bucket_name/csv/earthquakes.csv

I have done the above steps and I can see all the records in both the tables:

Records in Earthquake Table: 77037

Records in Countries Table: 30

I hope this helps.