[
https://issues.apache.org/jira/browse/HIVE-6601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14204305#comment-14204305
]
Lefty Leverenz commented on HIVE-6601:
--------------------------------------
Documented by [~navis] and revised by the nitpicker (me). Please review:
* [_just the diffs_ |
https://cwiki.apache.org/confluence/pages/diffpages.action?pageId=27362034&originalId=48202507]
* [Overview |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Overview]
* [Alter Database |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterDatabase]
* [Show Databases |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowDatabases]
* [Show Locks |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowLocks]
* [Describe Database |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeDatabase]
> alter database commands should support schema synonym keyword
> -------------------------------------------------------------
>
> Key: HIVE-6601
> URL: https://issues.apache.org/jira/browse/HIVE-6601
> Project: Hive
> Issue Type: Bug
> Reporter: Thejas M Nair
> Assignee: Navis
> Labels: TODOC14
> Fix For: 0.14.0
>
> Attachments: HIVE-6601.1.patch.txt
>
>
> It should be possible to use "alter schema" as an alternative to "alter
> database". But the syntax is not currently supported.
> {code}
> alter schema db1 set owner user x;
> NoViableAltException(215@[])
> FAILED: ParseException line 1:6 cannot recognize input near 'schema' 'db1'
> 'set' in alter statement
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
