Execute HQL Context variable in thiveinput

[Anonymous]

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. 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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