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)