no viable alternative at input create external service amazonathena status code 400

Question

CREATE EXTERNAL TABLE demodbdb
(
  data struct<
             name:string,
             age:string
             cars:array<string>
             >
)
ROW FORMAT SERDE
'org.openx.data.jsonserde.JsonSerDe'
LOCATION
's3://priyajdm/';

I got the following error: 

no viable alternative at input 'create external' (service: amazonathena; status code: 400; error code: invalidrequestexception;

Answer 1

In your case a (,) comma is missing after age:string 

The other reasons for getting this error could be that you are missing other symbols or using hypen with the database name.

Add a comma and it will work absolutely fine. 

Comments

No That's not the case.