Details
Description
Give user access to a column of a table, but no access to the table itself, SELECT column_name FROM table works in beeline, but Hue fails to display the list of columns the user have access to in the Hue Hive Editor page.
By checking the Hue log, it showed the Hue runs the following command:
DESCRIBE FORMATTED `test`.`test_table` {/code} and failed with error:
FAILED: SemanticException No valid privileges\n User yshi does not have privileges for DESCTABLE
The required privileges:
Server=server1->Db=test->Table=test_table->action=insert;
Server=server1->Db=test->Table=test_table->action=select;
It is understood that it is by design that DESC FORMATTED requires TABLE level privilege, so Hue has to update accordingly for this.