An alternative workaround in the Postgres metastore DB is to replace literal
string values 'NULL::character varying' that are were inserted w/o the setting
with the actual null-s, in TBLS and SDS tables (and potentially others but I
don’t know if there are any).
From: Stephen Sprague mailto:spr
Hi Team,
Trying to retrieve the privileges associated with table using Hive
metastore api. But after connection, it retrieves all other properties
associated with table and gives null for privileges.
Configuration Applied:
Enable the SQL Authorization inside the Hive Server and user like hive,ro