Can not Query from the Hive CLI/Can not Query Impala tables from Hue From Each Node of a BDA Cluster (Doc ID 1614909.1)

Last updated on JANUARY 17, 2014

Applies to:

Big Data Appliance Integrated Software - Version 2.2.1 to 2.4.0 [Release 2.2 to 2.4]
Linux x86-64

Symptoms

1. From any node of a cluster, except Node 4 (the node for the Hive service) any query from the Hive CLI raises:


4. The Hive CM Service-Wide/Advanced property: "Bypass Hive Metastore Server"  is not checked as per the recommended setting. (Services > hive > Configuration > View and Edit > Service-WideAdvanced > "Bypass Hive Metastore Server")  (If set, this property allows Hive client to access the Metastore database  directly rather than going through the Hive Metastore Server for Metastore information.)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms