[IMPALA-2238] Impala doesn't set HUE end user as the owner when creating tables

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.2.5
• Component/s: Catalog
• Labels: ramp-up security
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Yibing Shi
• Created: 24/Aug/15 12:54
• Updated: 19/Jun/20 19:09
• Resolved: 19/Jun/20 19:09

Description

In a Kerberized cluster (sentry not enabled), I can reproduce this problem with below:

1. Login to HUE as user 'yshi'
2. In HUE Hive editor, run query create table hue_test_hive (id int)
3. In HUE Impala editor, run query create table hue_test_impala (id int)
4. Login to the Hive Metastore database (take PostgreSQL as example) and execute query select * from "TBLS" where "TBLS"."TBL_NAME" like 'hue_test%', and then we get below result:

   TBL_ID	CREATE_TIME	DB_ID	LAST_ACCESS_TIME	OWNER	RETENTION	SD_ID	TBL_NAME	TBL_TYPE	VIEW_EXPANDED_TEXT	VIEW_ORIGINAL_TEXT
   29606	1440420180	1	0	yshi	0	88435	hue_test_hive	MANAGED_TABLE
   29607	1440420210	1	0	hue/[e-mail]	0	88436	hue_test_impala	MANAGED_TABLE

As we can see, the owner of the table created in Impala editor is owned by hue/<host>@REALM, while that created in Hive editor is owned by the HUE end user.

I haven't tried insecure cluster yet, but it should behave the same.

Issue Links

• duplicates: IMPALA-7075 Add support for object ownership for Impala
• is duplicated by: IMPALA-2279 Impala should set the end user as the table owner when tables are created in HUE