Parameter Validation Failure: SQL Query - Malformed SQL Statement: Expected token 'WHEN' but found Keyword with value 'LIMIT' instead at position 24. Statement:SELECT * from Case LIMIT 1

Matillion ETL
1

Hello Everyone,

I am getting this error in a component in matillion job.

Let me know if you need more inputs.

 

Thank you.

2

Hi @shameershaikh44​ and I'm sorry to hear you're getting an error. Can you let me know which component you're having this error in and anything else of note so we can try to help you further?

Many thanks,

Claire

3

Hi @shameershaikh44​

Is the name of the table on which your query applies "case"? I think it should be renamed or at least enclosed in quotes. it is interpreted here as a case when function.