Is HA cluster configured with Hive-2.0.1 (Derby support) showing redundant database names?

Question

I configured an HA cluster with one Namenode and one fallback and one given node. I started the derby database with hiveserver2 (Hive-2.0.1).

After starting the hive server, open beeline.cmd to check the amount of database.

It shows the default value 2 times:

0: jdbc: hive2: // hostname: port / default> show databases;

+ ---------------- + - +

| database_name |

+ ---------------- + - +

| default |

| default |

+ ---------------- + - +

3 rows selected (0.027 seconds)

At that time, I cannot create a table in this hive2.

Can someone tell me the cause of this problem?

Any help was appreciated.

Answer 1

It is not possible to have the same database twice.

Try to create the same database from two different clients at the same time.

If you can create a duplicate database, ask your request on the Hive mailing list or report to jira.