[
https://issues.apache.org/jira/browse/IMPALA-9669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Quanlong Huang updated IMPALA-9669:
-----------------------------------
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:
!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!
was:
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.
> 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
> Reporter: Quanlong Huang
> Priority: Major
> 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: [email protected]
For additional commands, e-mail: [email protected]
