topic Re: Execute HQL Context variable in thiveinput in Talend Studio

Execute HQL Context variable in thiveinput

Anonymous — Sat, 16 Nov 2024 03:59:04 GMT

Hello,

Im trying to execute hql query from contextvariable in thiveinput

If my context variable has hard code values then its working fine.

If im reading another context variable the it throw error.

Re: Execute HQL Context variable in thiveinput

Anonymous — Fri, 29 Nov 2019 00:27:13 GMT

For testing, print the value of context variable on the console to check if the context variable is assigned value correctly. If you can't still solve it, please upload a screenshot of job and show us the error.

Regards
Shong

Re: Execute HQL Context variable in thiveinput

Anonymous — Mon, 02 Dec 2019 17:05:03 GMT

Hi,

Print result is good but not reading the other variables in query.

Here is my query in variable:

"select distinct XXXXXXXXXXXXX from +context.db_name+.+context.view_name"

Error:

tHiveInput_1 Error while compiling statement: FAILED: ParseException line 1:109 cannot recognize input near '+' 'context' '.' in join source
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:109 cannot recognize input near '+' 'context' '.' in join source

Error.PNG

Re: Execute HQL Context variable in thiveinput

Anonymous — Wed, 04 Dec 2019 09:21:59 GMT

It's a compilation error, change the query to
"select distinct XXXXXXXXXXXXX from "+context.db_name+"."+context.view_name"