[resolved] tHiveConnection at Talend 5.5.1 not working with Cloudera

One Star

[resolved] tHiveConnection at Talend 5.5.1 not working with Cloudera

I am Using Talend 5.5.1 Bigdata
tHiveConnection is throwing following Exception.

[INFO ]: hive.metastore - Trying to connect to metastore with URI thrift://txwlcloud1:9083
Exception in component tHiveConnection_1
org.apache.hive.service.ServiceException: Unable to connect to MetaStore!
at org.apache.hive.service.cli.CLIService.start(CLIService.java:99)
at org.apache.hive.service.cli.thrift.EmbeddedThriftBinaryCLIService.<init>(EmbeddedThriftBinaryCLIService.java:35)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:150)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at big_data.testhdfs_0_1.TestHDFS.tHiveConnection_1Process(TestHDFS.java:355)
at big_data.testhdfs_0_1.TestHDFS.runJobInTOS(TestHDFS.java:838)
at big_data.testhdfs_0_1.TestHDFS.main(TestHDFS.java:697)
Caused by: java.lang.NullPointerException
at java.lang.ProcessBuilder.start(Unknown Source)
at org.apache.hadoop.util.Shell.runCommand(Shell.java:445)
at org.apache.hadoop.util.Shell.run(Shell.java:418)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:650)
at org.apache.hadoop.util.Shell.execCommand(Shell.java:739)
at org.apache.hadoop.util.Shell.execCommand(Shell.java:722)
at 
Following is my connection setup: Same connection is working in talend version 5.4
One Star

Re: [resolved] tHiveConnection at Talend 5.5.1 not working with Cloudera

Ok. SO it is really strange way I fixed the problem.
instead of using hive version Cloudera 5 we have to use cloudera cdh 4.3+(yarn mode )


I think this is a bug for version 5.5..
Moderator

Re: [resolved] tHiveConnection at Talend 5.5.1 not working with Cloudera

Hi amitkr.dutta,

Could you please open a jira issue on Talend Bug Tracker, our component developer will check it to see if it is a bug.

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog