Four Stars

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!

2 REPLIES
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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

 

Thank you for the reply!