Drop Daabase seems unexpected behaviour.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Drop Daabase seems unexpected behaviour.

Harmeet Singh
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.