H190 Unable to fetch results metadata error.need help

[#1]

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.

[#2]

@Shihab

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

[#3 · Accepted solution]

@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.