carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-327) Drop Daabase unexpected behaviour.
Date Fri, 27 Jan 2017 08:23:24 GMT

    [ https://issues.apache.org/jira/browse/CARBONDATA-327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15842385#comment-15842385
] 

Rahul Kumar commented on CARBONDATA-327:
----------------------------------------

[~harmeetsingh] this behavior is similar as spark hive . so you can mark it as closed.

> Drop Daabase unexpected behaviour. 
> -----------------------------------
>
>                 Key: CARBONDATA-327
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-327
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Harmeet Singh
>            Assignee: Manish Gupta
>            Priority: Trivial
>
> 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)

Mime
View raw message