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

Lefty Leverenz commented on HIVE-6601:
--------------------------------------

Documentation goes here:

* [DDL -- Alter Database | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterDatabase]

similar to create and drop database here (although it would be better to use 
new lines of syntax to show the version information, instead of "|" syntax):

* [DDL -- Create/Drop/Alter Database | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterDatabase]

> 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.2#6252)

Reply via email to