topic Error in batch job reading Hive in Talend Studio

Error in batch job reading Hive

Anonymous — Sat, 16 Nov 2024 08:05:34 GMT

Hi guys,

I am trying to read from Hive via jdbc in a Batch Map Reduce Job.

However, when I run the job it gives me the following error:

Starting job testmr at 10:40 15/06/2018.

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/C:/Users/Yoanna.Vasileva/workspace/.Java/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/Users/Yoanna.Vasileva/workspace/.Java/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.[WARN ]: org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable[statistics] conne

To see the whole post, download it here

Re: Error in batch job reading Hive

Anonymous — Tue, 19 Jun 2018 08:44:17 GMT

Hello,

Are you able to successfully read data from hive by using talend hive components?

Best regards

Sabrina

Re: Error in batch job reading Hive

Anonymous — Tue, 19 Jun 2018 10:45:02 GMT

Hi Sabrina,

Yes I am able to read data successfully from hive with tHiveInput.

Best regards,

Yoanna

Re: Error in batch job reading Hive

Anonymous — Wed, 27 Jun 2018 04:10:31 GMT

Hello,

What's hive server version are you trying to connect?

Best regards

Sabrina

Re: Error in batch job reading Hive

Anonymous — Wed, 27 Jun 2018 08:40:56 GMT

Hello,

The version is: Hive 1.2.1000.2.5.0.0-1245 .

Best regards

Re: Error in batch job reading Hive

Anonymous — Thu, 05 Jul 2018 11:00:37 GMT

Hello,

Is your query working perfectly fine? Was it some copy/paste issue?

Best regards

Sabrina

Re: Error in batch job reading Hive

Anonymous — Thu, 05 Jul 2018 11:20:53 GMT

As I mentioned earlier I am able to read data with the same query via hive components. Moreover, when I execute the query in hive in hive(via putty) it works. It gives me errors with the jdbc components in a map reduce job.

Best regards,

Yoanna