[jira] Updated: (HIVE-675) add database/scheme support Hive QL

["He Yongqiang (JIRA)" <ji...@apache.org>]

     [ 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.