Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-9669

loaded views are still returned as tables for GET_TABLES in LocalCatalog mode

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: Impala 3.3.0, Impala 3.4.0
    • Fix Version/s: Impala 4.0
    • Component/s: Catalog
    • Labels:
      None
    • Epic Color:
      ghx-label-7

      Description

      It's expected that unloaded views are returned as tables in legacy catalog mode, because they are represented as IncompleteTables which have no difference with normal tables. When the view is loaded (i.e. used once), Impala should be able to get its type and return it correctly for GET_TABLES request.

      However, in LocalCatalog mode, the types for loaded views are always TABLE.

      For reproducing the issue, there are no easy way to trigger GET_TABLES in command lines. The most easier way may be using HUE:

      • Make sure coordinators are in LocalCatalog mode.
      • Create a view and run a query on it to make sure it's loaded.
      • In HUE's Impala editor, the view is shown as table, no matter how many times we refresh the table list:
      • In HUE's Hive editor, the view is shown with a view logo:

       

        Attachments

        1. normal_view_in_hive_editor.png
          52 kB
          Quanlong Huang
        2. view_shown_as_table_in_impala_editor.png
          87 kB
          Quanlong Huang

          Issue Links

            Activity

              People

              • Assignee:
                stigahuang Quanlong Huang
                Reporter:
                stigahuang Quanlong Huang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: