Amazon Athena: no viable alternative at input

amazon-web-services amazon-athena
Deepak Singhal picture Deepak Singhal · Dec 1, 2016 · Viewed 56.1k times · Source

While creating a table in Athena; it gives me following exception:

no viable alternative at input

Answer

Deepak Singhal picture Deepak Singhal · Dec 1, 2016

hyphens are not allowed in table name.. ( though wizard allows it ) .. Just remove hyphen and it works like a charm

Related questions

Athena greater than condition in date column

I have the following query that I am trying to run on Athena. SELECT observation_date, COUNT(*) AS count FROM db.table_name WHERE observation_date > '2017-12-31' GROUP BY observation_date However it is producing this …

Read More
AWS Athena and date_format

I have some issue while formatting a timestamp with Amazon Athena service. select date_format(current_timestamp, 'y') Returns just 'y' (the string). The only way I found to format dates in Amazon Athena is trough CONCAT + YEAR + MONTH + DAY …

Read More
What is difference between s3 select and athena

I am trying to understand what is difference between aws athena service and newly released s3 select (still in preview). And how usecases different for both of those? It seems both helps in selecting partial data from s3.

Read More