You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2013/01/09 11:32:05 UTC

[jira] [Commented] (HIVE-2721) ability to select a view qualified by the database / schema name

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

Hudson commented on HIVE-2721:
------------------------------

Integrated in Hive-trunk-hadoop2 #54 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/54/])
    HIVE-2721 ability to select a view qualified by the database / schema name
(Martin Traverso via namit) (Revision 1330991)

     Result = ABORTED
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, 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
For more information on JIRA, see: http://www.atlassian.com/software/jira