Hive and MapR -- TApplicationException: Invalid method name 'Execute'

One Star

Hive and MapR -- TApplicationException: Invalid method name 'Execute'

I am using Enterprise Talend 5.4 with MapR 3.1.0
The tHiveConnection component results in the following stack trace:

Exception in component tHiveConnection_1
java.sql.SQLException: org.apache.thrift.TApplicationException: Invalid method name: 'execute'
        at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:196)
        at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:132)
        at org.apache.hadoop.hive.jdbc.HiveConnection.configureConnection(HiveConnection.java:133)
        at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:122)
        at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:106)
        at java.sql.DriverManager.getConnection(DriverManager.java:615)
        at java.sql.DriverManager.getConnection(DriverManager.java:195)
I tried to load some libraries in my /opt/mapr/hive/hive-0.12/lib directory using the tLibraryLoad because Talend was placecing the hive-0.11 jars in the class path, such as hive-exec, hive-jdbc, hive-metastore, and hive-service, but received the same error.
Has anyone come across this?
Regards,
Matthew
Moderator

Re: Hive and MapR -- TApplicationException: Invalid method name 'Execute'

Hi,
What's your connection mode? Embedded or standalone? Could you please upload your tHiveConnection component setting screenshot into forum?
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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch