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.
'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_184.108.40.2066.zip file on this site.
I guess you will have more information about the issue in the logs of the mapreduce jobs.