1. It often failed to connect to HMS. Need to rest...
# questions-and-troubleshootingl
Lillian Y.
04/01/2026, 8:08 PM1. It often failed to connect to HMS. Need to restart StarRocks and HMS.
2. Cannot do "ANALYZE" of the external hive tables. It complains there is no "SELECT" permission to the columns, but the user does have the SELECT permissions. The "SELECT *" works.
The ranger plugin is the ranger-starrocks-plugin-3.0.0-SNAPSHOT.jar. Is there new plugins for starrocks 4.0.7? And how to limit the connections to HMS?
p
peter pang
04/02/2026, 6:40 PMneed more info , what is the error message ? what is the log of failed ?
l
Lillian Y.
04/02/2026, 6:47 PMmysql > set catalog hive;
mysql > select * from dm.traffic_mp_wr limit 1;
it returns results.
mysql> analyze table dm.traffic_mp_wr;
ERROR 5204 (42000): Access denied; you need (at least one of) the SELECT privilege(s) on TABLE traffic_mp_wr for this operation.
Lillian Y.
04/02/2026, 6:51 PMThere is error in fe.log:
2026-03-26 213414.795Z ERROR (main|1) [RangerConfiguration.addResourceIfReadable():61] addResourceIfReadable(ranger-starrocks-starrocks-ai-hdp1-policymgr-ssl.xml): couldn't find resource file location
Lillian Y.
04/02/2026, 6:52 PMIt used to be ranger-starrocks-starocks-policymgr-ssl.xml, without the host name.
Lillian Y.
04/02/2026, 6:53 PMSorry, the error message is in fe.warn.log.
p
peter pang
04/02/2026, 7:30 PMso u are using ranger for the access control with hive table ?
peter pang
04/02/2026, 7:31 PMwhat is the ranger config for this table / user / role ?
l
Lillian Y.
04/02/2026, 9:45 PMyes, I am using ranger. For this table, the user has all permissions.