tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

[vroncalla]

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

[Anonymous]

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

[vroncalla]

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

thiveinput_error3.png

[manodwhb]

@vroncalla , are you created  hive DB connection in metadata,which is using in tHiveInput?

[David_Beaty]

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.

[vroncalla]

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.