Hive Command "SHOW DATABASES" Stops Working After 50 "canary" Databases are Accumulated (Doc ID 1982054.1)

Last updated on JUNE 15, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.0 to 4.1.0 [Release 4.0 to 4.1]
Linux x86-64

Symptoms

Hive command "show databases" stops working after 50 "canary" databases are accumulated. This can occur when run from Hive CLI or Beeline. If you log in as the "sentry admin" user then the "show databases" command will succeed.

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