One Star

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

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!