hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "He Yongqiang (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HIVE-675) add database/scheme support Hive QL
Date Mon, 07 Sep 2009 11:31:57 GMT

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

He Yongqiang updated HIVE-675:
------------------------------

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

Added three new commands: 
1) "USE db_name"  to switch among existing databases
2) "CREATE DATABASE db_name LOCATION 'absolute_path_of_db_location' "
3) "DROP DATABASE db_name"

By default, hive use the 'default' database.
User can use the commands
{noformat}
use db_1; 
INSERT OVERWRITE DIRECTORY 'table_of_db2_hdfs_directory'  SELECT  ....  FROM table_of_db1
a ...";
{noformat}
to query one table in db1 and insert results to table in another database (db2).  This can
achieve some basic security by the underlying file system used.



> add database/scheme support Hive QL
> -----------------------------------
>
>                 Key: HIVE-675
>                 URL: https://issues.apache.org/jira/browse/HIVE-675
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Prasad Chakka
>         Attachments: hive-675-2009-9-7.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.


Mime
View raw message