[ 
https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12897625#action_12897625
 ] 

HBase Review Board commented on HIVE-675:
-----------------------------------------

Message from: "Carl Steinbach" <c...@cloudera.com>


bq.  On 2010-08-11 06:57:04, namit jain wrote:
bq.  > ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g, line 572
bq.  > <http://review.cloudera.org/r/508/diff/2/?file=5203#file5203line572>
bq.  >
bq.  >     remove KW_SCHEMAS

In MySQL SHOW SCHEMAS is a synonym for SHOW DATABASES as of version 5.0.2. I 
think the general convention in Hive is to mimic the behavior of MySQL. Please 
let me know if there is a reason why we should not do that here.

http://dev.mysql.com/doc/refman/5.0/en/show-databases.html
 


- Carl


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
http://review.cloudera.org/r/508/#review838
-----------------------------------------------------------





> add database/schema support Hive QL
> -----------------------------------
>
>                 Key: HIVE-675
>                 URL: https://issues.apache.org/jira/browse/HIVE-675
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Metastore, Query Processor
>            Reporter: Prasad Chakka
>            Assignee: Carl Steinbach
>             Fix For: 0.6.0, 0.7.0
>
>         Attachments: hive-675-2009-9-16.patch, hive-675-2009-9-19.patch, 
> hive-675-2009-9-21.patch, hive-675-2009-9-23.patch, hive-675-2009-9-7.patch, 
> hive-675-2009-9-8.patch, HIVE-675-2010-7-16.patch.txt, 
> HIVE-675-2010-8-4.patch.txt
>
>
> 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.

Reply via email to