Drop Database unexpected behaviour

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

Drop Database unexpected behaviour

anubhavtarar
i create a database in hive and carbondata then dropped both databases when i execute show table in hive it gives an exception that database does not exists but in carbon data it does not give any exception
in hive---
i got following output ----
hive> CREATE DATABASE SAMPLE;
OK
hive (default)> use SAMPLE;
OK
hive (SAMPLE)> drop database SAMPLE;
OK
hive (SAMPLE)> use SAMPLE;
FAILED: SemanticException [Error 10072]: Database does not exist: SAMPLE
hive (SAMPLE)> show tables;
FAILED: SemanticException [Error 10072]: Database does not exist: SAMPLE
where as in carbondata i got folowing output
0: jdbc:hive2://localhost:10000> CREATE DATABASE SAMPLE;
0: jdbc:hive2://localhost:10000> USE SAMPLE;
0: jdbc:hive2://localhost:10000> DROP DATABASE SAMPLE;
0: jdbc:hive2://localhost:10000> USE SAMPLE;
Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED: SemanticException [Error 10072]: Database does not exist: SAMPLE (state=,code=0)
0: jdbc:hive2:
0: jdbc:hive2://localhost:10000>show tables;
------------------------
tableName isTemporary
------------------------
------------------------
No rows selected (0.066 seconds)

is this a valid bug?