Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I am getting the following error message while using a new tHiveInput_1 component:
dbUser_tHiveInput_1 cannot be resolved to a variable
I am using:
- Talend Big Data Platform 7.1.1
- JDK: 1.8.0_111
- Windows 10 Pro 64 bits
- Log4J enabled
We are trying to migrate some jobs from Talend 6.3 to 7.1 and are getting this errors
Does anybody know how to solve this?
Thanks in advance
Hello @vroncalla
Could you please show us the full query statement? Did you enclose the query itself in double-quotes? Are you able to run a simple query without context value successfully?
Best regards
Sabrina
Helllo @xdshi
Sure
No, I am not able to run a simple query. I tried a simple query but it did not work
The error message is being showed even using a simple query "dbUser_tHiveInput_1 cannot be resolved to a variable"
The query variable is ok:
This is the version we have: Talend-Studio-20181026_1147-V7.1.1
Please your support
@vroncalla , are you created hive DB connection in metadata,which is using in tHiveInput?
Hi,
Consider deleting the tHiveInput component from the job and then re-add it by dragging in a new version from the palette and setting it back up again.
Yes, the problem is showed using this approach (using a connection from metadata). In order to deal with this we are using a tHiveConnection component and check the option "Use an existing connection" in tHiveInput component.