[jira] [Commented] (HIVE-6601) alter database commands should support schema synonym keyword
[
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)
[jira] [Commented] (HIVE-6601) alter database commands should support schema synonym keyword
[
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)
[jira] [Commented] (HIVE-6601) alter database commands should support schema synonym keyword
[
https://issues.apache.org/jira/browse/HIVE-6601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14076515#comment-14076515
]
Thejas M Nair commented on HIVE-6601:
-
+1
> 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
> 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)
[jira] [Commented] (HIVE-6601) alter database commands should support schema synonym keyword
[
https://issues.apache.org/jira/browse/HIVE-6601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14076146#comment-14076146
]
Hive QA commented on HIVE-6601:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12658100/HIVE-6601.1.patch.txt
{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 5770 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_optimization
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_ql_rewrite_gbtoidx
org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes
org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/76/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/76/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-76/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12658100
> 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
> 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)
[jira] [Commented] (HIVE-6601) alter database commands should support schema synonym keyword
[
https://issues.apache.org/jira/browse/HIVE-6601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13995393#comment-13995393
]
Thejas M Nair commented on HIVE-6601:
-
This is the case with the other alter database command as well - ALTER
DATABASE database_name SET DBPROPERTIES
> 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
>
> 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)
