Hive
  1. Hive
  2. HIVE-2721

ability to select a view qualified by the database / schema name

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 0.7.0, 0.7.1, 0.8.0, 0.9.0
    • Fix Version/s: 0.10.0
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      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

      1. HIVE-2721-1.patch
        105 kB
        Martin Traverso
      2. HIVE-2721.patch
        105 kB
        Martin Traverso

        Activity

        Robert Morton created issue -
        Carl Steinbach made changes -
        Field Original Value New Value
        Component/s Database/Schema [ 12317906 ]
        Martin Traverso made changes -
        Assignee Martin Traverso [ martint ]
        Hide
        Robert Morton added a comment -

        I believe index DDL operations like CREATE INDEX have a similar limitation.

        Show
        Robert Morton added a comment - I believe index DDL operations like CREATE INDEX have a similar limitation.
        Hide
        Martin Traverso added a comment -
        Show
        Martin Traverso added a comment - Diff: https://reviews.facebook.net/D2901
        Martin Traverso made changes -
        Attachment HIVE-2721.patch [ 12523536 ]
        Kevin Wilfong made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Hide
        Namit Jain added a comment -

        some minor comments on phabricator

        Show
        Namit Jain added a comment - some minor comments on phabricator
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Hide
        Martin Traverso added a comment -

        Update patch to address comments on phabricator

        Show
        Martin Traverso added a comment - Update patch to address comments on phabricator
        Martin Traverso made changes -
        Attachment HIVE-2721-1.patch [ 12523808 ]
        Martin Traverso made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Martin Traverso made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        Martin Traverso made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Hide
        Namit Jain added a comment -

        +1

        Show
        Namit Jain added a comment - +1
        Hide
        Namit Jain added a comment -

        Committed. Thanks Martin

        Show
        Namit Jain added a comment - Committed. Thanks Martin
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Hadoop Flags Reviewed [ 10343 ]
        Resolution Fixed [ 1 ]
        Hide
        Hudson added a comment -

        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
        Show
        Hudson added a comment - 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
        Hide
        Ashutosh Chauhan added a comment -

        This has introduced six new failures on trunk. See: https://builds.apache.org/job/Hive-trunk-h0.21/1399/

        Show
        Ashutosh Chauhan added a comment - This has introduced six new failures on trunk. See: https://builds.apache.org/job/Hive-trunk-h0.21/1399/
        Ashutosh Chauhan made changes -
        Fix Version/s 0.10.0 [ 12320745 ]
        Affects Version/s 0.9.0 [ 12317742 ]
        Hide
        Martin Traverso added a comment -

        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?

        Show
        Martin Traverso added a comment - 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?
        Hide
        Hudson added a comment -

        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
        Show
        Hudson added a comment - 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
        Hide
        Ashutosh Chauhan added a comment -

        This issue is fixed and released as part of 0.10.0 release. If you find an issue which seems to be related to this one, please create a new jira and link this one with new jira.

        Show
        Ashutosh Chauhan added a comment - This issue is fixed and released as part of 0.10.0 release. If you find an issue which seems to be related to this one, please create a new jira and link this one with new jira.
        Ashutosh Chauhan made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Martin Traverso
            Reporter:
            Robert Morton
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development