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

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

Anonymous — Sat, 16 Nov 2024 08:07:23 GMT

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(")")

.toString();

See attached images as well.

Has anyone else seen this?

Thanks!

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

Anonymous — Thu, 28 Jun 2018 10:46:03 GMT

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

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

Anonymous — Thu, 28 Jun 2018 13:19:45 GMT

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

Thank you for the reply!