hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "He Yongqiang (JIRA)" <>
Subject [jira] Updated: (HIVE-675) add database/scheme support Hive QL
Date Tue, 08 Sep 2009 13:28:57 GMT


He Yongqiang updated HIVE-675:

    Attachment: hive-675-2009-9-8.patch

Thanks for the detailed comments, Prasad!
bq. 1) more test clientpositive & clientnegative tests
added several tests.

2) db location should take an URI rather than a path. since location can point to a different
HDFS instance
5) if the given db location is not a proper URI then it is silently ignored
and default path is being used. HiveMetastore should throw an error instead if the path is
not absolute or a proper URI
6) remove ql/ from patch
7) remove ql/ from patch
8) there are lot of other locations where MetaStoreUtils.DEFAULT_DATABASE_NAME is used. It
should be replaced by Hive.currentDatabase
10) Hive.createDatabase() & dropDatabase() should throw AlreadyExistsException() instead
of throwin HiveException
11) rename isDatabaseExist() to databaseExists()

3) this path does not support <DBNAME>.<TBLNAME>.<COLUMN>. If you are not
planning to add that support then create a new JIRA.
4) there should be a way to easily move tbl from on db to another db. may be open a JIRA for
that as well?
Let's open new jiras. Once multiple databases is supported at client, lots of new issues will
need to be created.

9) is Hive.currentDatabase thread-safe. does it work in HiveServer where multiple threads
can each have separate currentDatabases?
12) currentDatabase should either be in SessionState or Hive. There is no need for it to be
stored in both objects. 
currentDatabase is now removed from SessionState, and is stored as a threadlocal variable
in Hive.

> add database/scheme support Hive QL
> -----------------------------------
>                 Key: HIVE-675
>                 URL:
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Prasad Chakka
>         Attachments: hive-675-2009-9-7.patch, hive-675-2009-9-8.patch
> Currently all Hive tables reside in single namespace (default). Hive should support multiple
namespaces (databases or schemas) such that users can create tables in their specific namespaces.
These name spaces can have different warehouse directories (with a default naming scheme)
and possibly different properties.
> There is already some support for this in metastore but Hive query parser should have
this feature as well.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message