question Re: H190 Unable to fetch results metadata error.need help in Archives of Support Questions (Read Only)

H190 Unable to fetch results metadata error.need help

shihab_pri — Mon, 27 Jun 2016 15:49:58 GMT

We are getting the following error in Hive query editor.This error occurs inconsistently.Select queries are working fine.We are using Ambari 2.2.2.2.

Re: H190 Unable to fetch results metadata error.need help

bandarusridhar1 — Tue, 28 Jun 2016 08:36:36 GMT

@Shihab

Can you please check and Hive metastore? Please provide metastore logs for details understanding.

Re: H190 Unable to fetch results metadata error.need help

cstanca — Thu, 29 Dec 2016 07:06:15 GMT

@Shihab

Hive view calls GetResultSetMetadata without verifying query completion with GetOperationStatus. This results in an error status from hive server. This is https://issues.apache.org/jira/browse/AMBARI-13575 bug that supposed to be fixed in 2.2.0. However, you may encounter a variation of the same issue. There is no issue to track it. You should login to https://issues.apache.org/jira/browse/AMBARI-19313?jql=project%20%3D%20AMBARI and submit the issue with proper documentation.

If you are still on Ambari 2.2.2.2, try to upgrade to a more recent version. I have seen the error you describe in 2.2.x versions, but I haven't seen it on 2.4.x. I recall seeing some similar issues with 2.3.x as well.