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,520 points
645 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,120 points

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
28 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
18 views
+5 votes
2 answers

EC2 instance status check failed

Creating a snapshot from an EBS volume ...READ MORE

answered Mar 27, 2018 in AWS by DragonLord999
• 8,360 points
277 views
0 votes
1 answer

How do I create folder under an Amazon S3 bucket through PHP API?

Of Course, it is possible to create ...READ MORE

answered Apr 24, 2018 in AWS by anonymous
1,593 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
• 56,120 points
436 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,520 points
205 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,120 points
359 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,120 points
131 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.