Creating an external table in Hive displays an error if the table already exists in another keyspace. However, it appears that the Hive table was created. Steps to reproduce:
1) Create a keyspace "Company1" with a replication factor = 1.
2) Create a table "TestTable" in Company1;
3) Insert a row of data in Company1.TestTable.
4) Create a keyspace "Company2" with a replication factor = 1.
5) Create a table "TestTable" in Company2;
6) Insert a row of data in Company2.TestTable. (Use different values.)
7) Create an external table "TestTable" with cassandra.ks.name = "Company1".
8) Create an external table "TestTable" with cassandra.ks.name = "Company2".
Step #8 will cause and error: AlreadyExistsException(message: Table TestTable already exists)
However, if you "use Company2" and "show tables", TestTable exists. Selecting the data in TestTable displays the correct data. Using Company1 also displays the correct data.
Is this error incorrect? Can Hive contain identical table names from two different keyspaces?