AtScale Impala SQL to Pull Rolling 12 Months Data.

[tnkii]

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.