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

0 votes
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;
Nov 26, 2018 in AWS by Jino
• 5,560 points
1,446 views

1 answer to this question.

0 votes

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. 

answered Nov 26, 2018 by Priyaj
• 56,920 points
No That's not the case.

Related Questions In AWS

0 votes
1 answer

Use external template to create AMI in AWS.

Hey @user, Amazon provides a feature called VM ...READ MORE

answered Dec 28, 2018 in AWS by Nabarupa
48 views
0 votes
1 answer

Create an IAM service role for a Hybrid Environment

To create an IAM service role for ...READ MORE

answered Jan 10 in AWS by Nikita
39 views
0 votes
1 answer
0 votes
1 answer

Pivot rows into columns in AWS Athena?

You can use the following method :- It ...READ MORE

answered Oct 29, 2018 in AWS by Priyaj
• 56,920 points
1,034 views
0 votes
1 answer

Connect AWS Athena to an existing Hive Metastore

Athena works only with its own metastore ...READ MORE

answered Nov 16, 2018 in AWS by Jino
• 5,560 points
430 views
0 votes
1 answer

Aws-elb health check failing at 302 code

you get 302 when performing URL redirection, ...READ MORE

answered Aug 30, 2018 in AWS by Priyaj
• 56,920 points
645 views
0 votes
1 answer

How to get AWS account/service cost using CloudWatch API?

You can check this link for a ...READ MORE

answered Jul 13, 2018 in AWS by Priyaj
• 56,920 points
154 views