Hive
  1. Hive
  2. HIVE-4064

Handle db qualified names consistently across all HiveQL statements

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 0.10.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Hive doesn't consistently handle db qualified names across all HiveQL statements. While some HiveQL statements such as SELECT support DB qualified names, other such as CREATE INDEX doesn't.

        Issue Links

          Activity

          Hide
          Jarek Jarcec Cecho added a comment -

          Another command that is not working consistently is:

          ALTER TABLE db.table ...
          
          Show
          Jarek Jarcec Cecho added a comment - Another command that is not working consistently is: ALTER TABLE db.table ...
          Hide
          Shreepadma Venugopalan added a comment -

          I believe there is a problem with a number of DDLs including ALTER TABLE, CREATE INDEX.

          Show
          Shreepadma Venugopalan added a comment - I believe there is a problem with a number of DDLs including ALTER TABLE, CREATE INDEX.
          Hide
          Jeremy Rayner added a comment -

          Any progress on this issue? I understand that there are workarounds, but I would be nice if this got resolved sometime in the near future.

          Show
          Jeremy Rayner added a comment - Any progress on this issue? I understand that there are workarounds, but I would be nice if this got resolved sometime in the near future.
          Hide
          caofangkun added a comment -

          https://reviews.apache.org/r/11755/

          HiveLexer.g Identifier should contain '.' for full table name .
          It works now for 'alter table ' statements.

          Show
          caofangkun added a comment - https://reviews.apache.org/r/11755/ HiveLexer.g Identifier should contain '.' for full table name . It works now for 'alter table ' statements.
          Hide
          Jarek Jarcec Cecho added a comment -

          You might need to set the status to "Patch available" if you want Hive committers to take a look caofangkun.

          Show
          Jarek Jarcec Cecho added a comment - You might need to set the status to "Patch available" if you want Hive committers to take a look caofangkun .

            People

            • Assignee:
              caofangkun
              Reporter:
              Shreepadma Venugopalan
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:

                Development