You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Robert Morton (Created) (JIRA)" <ji...@apache.org> on 2012/01/17 02:33:38 UTC
[jira] [Created] (HIVE-2721) ability to select a view qualified by
the database / schema name
ability to select a view qualified by the database / schema name
----------------------------------------------------------------
Key: HIVE-2721
URL: https://issues.apache.org/jira/browse/HIVE-2721
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.8.0, 0.7.1, 0.7.0
Reporter: Robert Morton
Priority: Blocker
HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Carl Steinbach (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2721:
---------------------------------
Component/s: Database/Schema
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Priority: Blocker
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Martin Traverso (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Martin Traverso updated HIVE-2721:
----------------------------------
Attachment: HIVE-2721.patch
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2721) ability to select a view qualified
by the database / schema name
Posted by "Robert Morton (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13258311#comment-13258311 ]
Robert Morton commented on HIVE-2721:
-------------------------------------
I believe index DDL operations like CREATE INDEX have a similar limitation.
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2721) ability to select a view qualified
by the database / schema name
Posted by "Martin Traverso (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13258462#comment-13258462 ]
Martin Traverso commented on HIVE-2721:
---------------------------------------
Diff: https://reviews.facebook.net/D2901
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2721:
-----------------------------
Status: Open (was: Patch Available)
some minor comments on phabricator
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.8.0, 0.7.1, 0.7.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2721) ability to select a view qualified
by the database / schema name
Posted by "Martin Traverso (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13264039#comment-13264039 ]
Martin Traverso commented on HIVE-2721:
---------------------------------------
I checkout out trunk and ran those tests and can't get them to fail. Any idea what might be going on? Could it be possible hudson is not working off of a clean checkout?
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0, 0.9.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Fix For: 0.10.0
>
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Work stopped] (HIVE-2721) ability to select a view
qualified by the database / schema name
Posted by "Martin Traverso (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-2721 stopped by Martin Traverso.
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2721:
-----------------------------
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committed. Thanks Martin
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Martin Traverso (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Martin Traverso updated HIVE-2721:
----------------------------------
Attachment: HIVE-2721-1.patch
Update patch to address comments on phabricator
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Martin Traverso (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Martin Traverso updated HIVE-2721:
----------------------------------
Assignee: Martin Traverso
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Martin Traverso (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Martin Traverso updated HIVE-2721:
----------------------------------
Status: Patch Available (was: Open)
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.8.0, 0.7.1, 0.7.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2721) ability to select a view qualified
by the database / schema name
Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13263833#comment-13263833 ]
Ashutosh Chauhan commented on HIVE-2721:
----------------------------------------
This has introduced six new failures on trunk. See: https://builds.apache.org/job/Hive-trunk-h0.21/1399/
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-2721:
-----------------------------------
Affects Version/s: 0.9.0
Fix Version/s: 0.10.0
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0, 0.9.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Fix For: 0.10.0
>
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2721) ability to select a view qualified by
the database / schema name
Posted by "Kevin Wilfong (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Wilfong updated HIVE-2721:
--------------------------------
Status: Patch Available (was: Open)
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.8.0, 0.7.1, 0.7.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2721) ability to select a view qualified
by the database / schema name
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13261019#comment-13261019 ]
Namit Jain commented on HIVE-2721:
----------------------------------
+1
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2721) ability to select a view qualified
by the database / schema name
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13263303#comment-13263303 ]
Hudson commented on HIVE-2721:
------------------------------
Integrated in Hive-trunk-h0.21 #1399 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1399/])
HIVE-2721 ability to select a view qualified by the database / schema name
(Martin Traverso via namit) (Revision 1330991)
Result = FAILURE
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1330991
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java
* /hive/trunk/ql/src/test/queries/clientpositive/view.q
* /hive/trunk/ql/src/test/results/clientnegative/invalidate_view1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
* /hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out
* /hive/trunk/ql/src/test/results/clientpositive/view.q.out
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Work started] (HIVE-2721) ability to select a view
qualified by the database / schema name
Posted by "Martin Traverso (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-2721 started by Martin Traverso.
> ability to select a view qualified by the database / schema name
> ----------------------------------------------------------------
>
> Key: HIVE-2721
> URL: https://issues.apache.org/jira/browse/HIVE-2721
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor
> Affects Versions: 0.7.0, 0.7.1, 0.8.0
> Reporter: Robert Morton
> Assignee: Martin Traverso
> Priority: Blocker
> Attachments: HIVE-2721-1.patch, HIVE-2721.patch
>
>
> HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996641&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996641
> https://issues.apache.org/jira/browse/HIVE-1517?focusedCommentId=12996679&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12996679
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira