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. -- View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Drop-Daabase-seems-unexpected-behaviour-tp2036.html Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.