Harmeet Singh created CARBONDATA-327:
----------------------------------------
Summary: Drop Daabase unexpected behaviour.
Key: CARBONDATA-327
URL:
https://issues.apache.org/jira/browse/CARBONDATA-327 Project: CarbonData
Issue Type: Bug
Reporter: 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)