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,810 points
13,355 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
• 58,090 points
No That's not the case.

Related Questions In AWS

0 votes
1 answer

Create a service that uses an external deployment controller.

Hi@akhtar, The following create-service example creates a service that uses ...READ MORE

answered Nov 8, 2020 in AWS by MD
• 95,440 points
704 views
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
493 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 11, 2019 in AWS by Nikita
578 views
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
• 58,090 points
7,513 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,810 points
1,372 views
0 votes
1 answer

Aws-elb health check failing at 302 code

In the event that the condition of ...READ MORE

answered Aug 30, 2018 in AWS by Priyaj
• 58,090 points
9,362 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
• 58,090 points
704 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP