topic Re: tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable in Talend Studio

tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

vroncalla — Sat, 16 Nov 2024 06:16:11 GMT

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

Re: tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

Anonymous — Mon, 25 Mar 2019 04:27:52 GMT

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

Re: tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

vroncalla — Mon, 25 Mar 2019 15:32:50 GMT

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

Re: tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

manodwhb — Tue, 26 Mar 2019 12:03:07 GMT

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

Re: tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

David_Beaty — Tue, 26 Mar 2019 13:38:47 GMT

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.

Re: tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

vroncalla — Fri, 29 Mar 2019 14:22:52 GMT

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.