This is a known issue hash indexes are prone to become corrupted. HiveMetastore makes use of hash indexes for PostgreSQL and these corruptions cause issues. Affected Indexes: TC_TXNID_INDEX and HL_TXNID_INDEX Workaround: The workaround is to reindex the corrupted indexes. For example, in PostgreSQL run reindex index tc_txnid_index. And, If you use PostgreSQL as the backend database, a supported version later than 9.6 is recommended. You can refer the below link for more reference: https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/release-notes/content/known_issues.html ... View more

please change the property in    Hive Metastore Server Advanced Configuration Snippet (Safety Valve) for hive-site.xml        and     Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml ... View more

Hive on spark is not supported on HDP 3.0.1 . You need to use Spark HWC and integrate with LLAP to take advantage,   In HDP 3.x ,Tez is the default execution engine and you can also use MR. ... View more