Error in batch job reading Hive

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

Hi Sabrina,

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

Best regards,

Yoanna

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

Hello,

The version is: Hive 1.2.1000.2.5.0.0-1245 .

Best regards

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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