[
https://issues.apache.org/jira/browse/HIVE-2584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14063169#comment-14063169
]
Lefty Leverenz commented on HIVE-2584:
--------------------------------------
If most commands accept a database name, we need to add \[db_name.\] to
table_name in the DDL doc (and possibly some other docs). It's already in the
CREATE TABLE syntax, but only 5 out of 56 instances of table_name have db_name
in syntax or text. Excluding ALTER statements, it's 5 out of 28. For
view_name 1 out of 10 has db_name.
Alternatively, we could change table_name to table_spec, defined as
"db_name.table_name" with a list of exceptions. But that would lead to
confusion, since people rarely read the DDL doc from the beginning.
* [LanguageManual DDL |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL]
> Alter table should accept database name
> ---------------------------------------
>
> Key: HIVE-2584
> URL: https://issues.apache.org/jira/browse/HIVE-2584
> Project: Hive
> Issue Type: Improvement
> Affects Versions: 0.7.1
> Reporter: Bharath Mundlapudi
> Assignee: Chun Chen
> Attachments: HIVE-2584.2.patch, HIVE-2584.3.patch, HIVE-2584.4.patch,
> HIVE-2584.5.patch, HIVE-2584.6.patch, HIVE-2584.patch
>
>
> It would be nice if alter table accepts database name.
> For example:
> This would be more useful in certain usecases:
>
> alter table DB.Tbl set location <location>;
> rather than 2 statements.
> use DB;
> alter table Tbl set location <location>;
>
--
This message was sent by Atlassian JIRA
(v6.2#6252)
