You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2020/04/20 03:37:00 UTC

[jira] [Assigned] (IMPALA-9669) loaded views are still returned as tables for GET_TABLES in LocalCatalog mode

     [ https://issues.apache.org/jira/browse/IMPALA-9669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Quanlong Huang reassigned IMPALA-9669:
--------------------------------------

    Assignee: Quanlong Huang

> loaded views are still returned as tables for GET_TABLES in LocalCatalog mode
> -----------------------------------------------------------------------------
>
>                 Key: IMPALA-9669
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9669
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Catalog
>            Reporter: Quanlong Huang
>            Assignee: Quanlong Huang
>            Priority: Critical
>         Attachments: normal_view_in_hive_editor.png, view_shown_as_table_in_impala_editor.png
>
>
> 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:
>  !view_shown_as_table_in_impala_editor.png|width=493,height=160!
>  * In HUE's Hive editor, the view is shown with a view logo:
>  !normal_view_in_hive_editor.png|width=350,height=203!
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org