I am unable to create table from S3 data.
Note : I am using only S3 not hdfs and Hadoop.
I am using s3 to create file in athena database . I am getting exception Only S3 locations are allowed. when I am giving the s3a://bucket/folder as external location
If I am giving s3://bucket/folder as external location getting exception only [hdfs,s3a] schemes are allowed
Please help on this