tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

Highlighted
Five Stars

tHiveInput Error - dbUser_tHiveInput_1 cannot be resolved to a variable

Hello I am getting the following error message while using a new tHiveInput_1 component:

dbUser_tHiveInput_1 cannot be resolved to a variable

 

thiveinput_error2.png

 

thiveinput_error1.png

 

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

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

Helllo @xdshi 

 

Sure

 

thiveinput_error3.png

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"

 

thiveinput_error4.png

 

The query variable is ok:

 

thiveinput_error5.png

 

This is the version we have: Talend-Studio-20181026_1147-V7.1.1

 

Please your support

Forteen Stars

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

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Nine Stars

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

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.

 

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.
Five Stars

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

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.

 

 

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now

How to Modernize Your Cloud Platform for Big Data Analytics With Talend and Micr...

Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>

Read