hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sourabh potnis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-7300) When creating database by specifying location, .db is not created
Date Thu, 26 Jun 2014 15:42:26 GMT

     [ https://issues.apache.org/jira/browse/HIVE-7300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

sourabh potnis updated HIVE-7300:
---------------------------------

    Description: 
When I create a database without specifying location:
e.g. create database test;
it will get created in /apps/hive/warehouse/ as /apps/hive/warehouse/test.db

But when I create database by specifying location:
e.g. create database test_loc location '/addh0010/hive/addh0011/warehouse';
Database will be created but /addh0010/hive/addh0011/warehouse/test_loc.db does not get created.

So if user tries to create 2 tables with same name in two different databases at same location.
We are not sure if table is created.

So when database is created with location, .db directory should be created with that database
name at that location.


  was:
When I create a database without specifying location:
e.g. create database test;
it will get created in /apps/hive/warehouse/ as /apps/hive/warehouse/test.db

But when I create database by specifying location:
e.g. create database test_loc location '/addh0010/hive/addh0011/warehouse';
Database will be created but /addh0010/hive/addh0011/warehouse/test_loc does not get created.

So if user tries to create 2 tables with same name in two different databases at same location.
We are not sure if table is created.

So when database is created with location, .db directory should be created with that database
name at that location.



> When creating database by specifying location, .db is not created
> -----------------------------------------------------------------
>
>                 Key: HIVE-7300
>                 URL: https://issues.apache.org/jira/browse/HIVE-7300
>             Project: Hive
>          Issue Type: Bug
>            Reporter: sourabh potnis
>
> When I create a database without specifying location:
> e.g. create database test;
> it will get created in /apps/hive/warehouse/ as /apps/hive/warehouse/test.db
> But when I create database by specifying location:
> e.g. create database test_loc location '/addh0010/hive/addh0011/warehouse';
> Database will be created but /addh0010/hive/addh0011/warehouse/test_loc.db does not get
created.
> So if user tries to create 2 tables with same name in two different databases at same
location. We are not sure if table is created.
> So when database is created with location, .db directory should be created with that
database name at that location.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message