Can not Query from the Hive CLI/Can not Query Impala tables from Hue From Each Node of a BDA Cluster
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-Wide > Advanced > "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