Hi,
I'm trying to get my Impala SQL to work but it does not. Data is currently sitting in AtScale server and using Cloudera Impala driver to connect and pull data.
I have my SQL statement as
Select *
From data_table
Where data_table.period_end_date >= date_add(month,datediff(month,0,getdate())-12,0)
but SQL editor in Alteryx returns an error saying it doesn't recognize the GETDATE function, which is odd. I then changed to CURRENT_TIMESTAMP() and it also is giving me an error saying there it's expecting one of "and"... "collate".... "except"...
Does anyone know what the issue is?
Thank you.
