topic Parse Syntax error ,can anyone guide me what is going wrong here in Data Engineering

Parse Syntax error ,can anyone guide me what is going wrong here

Sajid1 — Wed, 02 Nov 2022 17:57:56 GMT

Select case WHEN {{ Month }} = 0 then add_months(current_date(),-13 ) else

WHEN {{ Month }}> month(add_months(current_date(),-1)) then add_months(to_date(concat(year(current_date())-1,'-',{{Month}},'-',1)),-13)

else add_months(to_date(concat(year(current_date()),'-',{{Month}},'-',1)),-13) end dt

Here Month is a parameter with dropdownlist having values from 0-12. However, while executing the sql, getting parse_syntax_error

The error is pasted below

[PARSE_SYNTAX_ERROR] Syntax error at or near '0'line 1, pos 17

== SQL ==

Select case WHEN 0 = 0 then add_months(current_date(),-13 ) else

-----------------^^^

WHEN 0> month(add_months(current_date(),-1)) then add_months(to_date(concat(year(current_date())-1,'-',0,'-',1)),-13)

else add_months(to_date(concat(year(current_date()),'-',0,'-',1)),-13) end dt LIMIT 1000

Re: Parse Syntax error ,can anyone guide me what is going wrong here

Sajid1 — Thu, 03 Nov 2022 08:38:05 GMT

My bad, I had missed with the syntax and rewrote the first condition in a alternate manner and it fixed it. Thanks for your time to go through the post

The update code is for your reference

Select case {{ Month }} WHEN 0 then add_months(current_date(),-13 )

WHEN {{ Month }} > month(add_months(current_date(),-1)) then add_months(to_date(concat(year(current_date())-1,'-',{{Month}},'-',1)),-13)

else add_months(to_date(concat(year(current_date()),'-',{{Month}},'-',1)),-13) end

Re: Parse Syntax error ,can anyone guide me what is going wrong here

Debayan — Thu, 03 Nov 2022 06:31:19 GMT

Hi @Sajid Thavalengal Rahiman , Have you followed the recommendation given above? Also, could you please paste the whole error with the code?

Re: Parse Syntax error ,can anyone guide me what is going wrong here

Debayan — Fri, 04 Nov 2022 04:49:44 GMT

Glad to know! Thanks.