tELTHiveMap producing incorrect HQL in Java "cannot recognize input near ... in expression specification"

[Anonymous]

Hi Community,

I have a simple join I'm trying to do with the tELTHiveMap component, and when I try to run it, it's throwing exceptions related to incorrectly formatted SQL, and sure enough despite having the join properly configured as per the Talend how-to here: 

https://help.talend.com/reader/hfF27SBEP9Avc0ofq7IDjw/CWdBTEme8NAbFgJDfOgzoA

I'm still getting the error because it would seem as though the JOIN condition is not being generated by the code, but is present in the generated SQL statement in the join panel.

.append(" ")

.append("ON")

.append("(")

.append(" ")

.append(" ")

.append(")")

.toString();

See attached images as well.

Has anyone else seen this?

Thanks!

[Anonymous]

Hello,

Could you please check your "Code" tab in your job to see if there will be compile error highlighted in red line?

Best regards

Sabrina

[Anonymous]

Yep, it's actually attached in a screenshot. See the attached pictures.

Thank you for the reply!