Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Query error occurs when I connect to the hive and spotfire by jdbc

Query error occurs when I connect to the hive and spotfire by jdbc

New Contributor

Hi guys.

 

This is Jin.

 

Recently I have a work to do spotfire with hive(CDH-5.5.0).

 

So, last week I try to connect spotfire to Hive by jdbc and I seem to connect sucessfully.

 

But, there are some issue about run the query.

 

Actually, normal a 'select' query is work fine.

For example)

'Select * From  order'

 

But, If I set prompt option(=like where cause) in information designer(=spotfire query designer) than some error message is comes up.

 

The error message is

 

InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: ERROR_STATE, SQL state: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask.   (HRESULT: 80131500)

 

Could you give me a any advice for me ??

 

Hive : CDH-5.5.0

jdbc driver version :  hive_jdbc_2.5.12.1036.zip file on this site.

 

 

 

 

 

 

 

 

 

 

 

 

1 REPLY 1

Re: Query error occurs when I connect to the hive and spotfire by jdbc

Super Collaborator

I guess you will have more information about the issue in the logs of the mapreduce jobs.

Don't have an account?
Coming from Hortonworks? Activate your account here