|
Hey team, I am creating a database as below:
0: jdbc:hive2://127.0.0.1:10000> create database Test;
+---------+--+
| result |
+---------+--+
+---------+--+
After creating an database i am using that database using below command:
0: jdbc:hive2://127.0.0.1:10000> use Test;
+---------+--+
| result |
+---------+--+
+---------+--+
After That, i am drop the database as below:
0: jdbc:hive2://127.0.0.1:10000> drop database test;
+---------+--+
| result |
+---------+--+
+---------+--+
The database drop successfully. I am expecting, after that the carbon data automatically switch to the "default" database. But when i trying to execute command "show tables" the result return nothing as below :
0: jdbc:hive2://127.0.0.1:10000> show tables;
+------------+--------------+--+
| tableName | isTemporary |
+------------+--------------+--+
+------------+--------------+--+
No rows selected (0.019 seconds)
But my default database contains some table as below:
0: jdbc:hive2://127.0.0.1:10000> use default;
+---------+--+
| result |
+---------+--+
+---------+--+
No rows selected (0.024 seconds)
0: jdbc:hive2://127.0.0.1:10000> show tables;
+------------+--------------+--+
| tableName | isTemporary |
+------------+--------------+--+
| one | false |
| two | false |
+------------+--------------+--+
2 rows selected (0.013 seconds)
If I am following all above step on Hive, Hive gave us an error on show tables after drop the database as below:
hive> drop database test;
OK
Time taken: 0.628 seconds
hive> show databases;
OK
default
Time taken: 0.022 seconds, Fetched: 1 row(s)
hive> show tables;
FAILED: SemanticException [Error 10072]: Database does not exist: test
Please confirm this is an Issue or Carbon Data behavior.
|