I am unable to create athena table from S3 data and empty athena table as well .
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
Error Message : Only S3 locations are allowed [SQL: u’CREATE EXTERNAL TABLE
customer_code string ) ROW FORMAT DELIMITED\n FIELDS TERMINATED BY ‘,’\n STORED AS TextFile LOCATION ‘s3a://data’\nTBLPROPERTIES(“transactional” = “false”)\n;’]
- If I am giving s3://bucket/folder as external location getting exception only [hdfs,s3a] schemes are allowed
Please help on this