Top "Amazon-athena" questions

While creating a table in Athena; it gives me following exception: no viable alternative at input

Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return …

I have the following query that I am trying to run on Athena. SELECT observation_date, COUNT(*) AS count FROM …

tried the below syntax none of them helped to convert a string type column to date select INVC_,APIDT,APDDT …

I have some issue while formatting a timestamp with Amazon Athena service. select date_format(current_timestamp, 'y') Returns just …

At Amazon Athena, I want to extract only the character string "2017-07-27" from the character string "2017-07-27 12:10:08". SELECT …

I am looking to convert the following string: mmm-dd-yyyy to a date: yyyy-mm-dd e.g Nov-06-2015 to 2015-11-06 …

I'm trying to create an external table on csv files with Aws Athena with the code below but the line …

Looking at the Date/Time Athena documentation, I don't see a function to do this, which surprises me. The closest …

I am trying to understand what is difference between aws athena service and newly released s3 select (still in preview). …