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

        Ashutosh Chauhan made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Ashutosh Chauhan made changes -
        Fix Version/s 0.10.0 [ 12320745 ]
        Affects Version/s 0.9.0 [ 12317742 ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Hadoop Flags Reviewed [ 10343 ]
        Resolution Fixed [ 1 ]
        Martin Traverso made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Martin Traverso made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        Martin Traverso made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Martin Traverso made changes -
        Attachment HIVE-2721-1.patch [ 12523808 ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Kevin Wilfong made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Martin Traverso made changes -
        Attachment HIVE-2721.patch [ 12523536 ]
        Martin Traverso made changes -
        Assignee Martin Traverso [ martint ]
        Carl Steinbach made changes -
        Field Original Value New Value
        Component/s Database/Schema [ 12317906 ]
        Robert Morton created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development