Uploaded image for project: 'Hue'
  1. Hue
  2. HUE-3751

[metastore] Confusion when table name and database name are the same

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.9.0
    • Fix Version/s: 3.10.0
    • Component/s: app.catalog, con.hive
    • Labels:
      None

      Description

      To revert when we switch to Hive 2.0

      The Hive syntax is ambiguous prior to Hive 2.0 - you can use either "DB.TABLE" or "TABLE.COLUMN". To ensure this always works you need to switch databases, then use the unqualified table name: "DESCRIBE <TABLE>". If you want to describe a column, run "DESCRIBE [DB.]TABLE COLUMN".
      
      This is fixed in Hive 2.0, but the change is backwards incompatible.
      
      Note - this is only an issue when table and database name are the same, it should work fine under other conditions. See https://issues.apache.org/jira/browse/HIVE-12184 for more information.
      

        Attachments

          Activity

            People

            • Assignee:
              romain Romain Rigaux
              Reporter:
              romain Romain Rigaux
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: