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
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?
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?
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks