[HIVE-17591] Getting error while select,insert,update,delete to hive from IBM SPSS Modeler server

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 1.2.2
• Component/s: Hive, HiveServer2

Environment

Redhat 7.2

• Assignee: Unassigned
• Reporter: sudarshana
• Due: 26/Sep/17
• Created: 25/Sep/17 00:22
• Updated: 21/Oct/22 07:20

Description

We are getting while we are connecting from IBM SPSS Modeler server which intern use SPSS analytical server. But we have everything(hive authorization, privilege ..etc) done.

A SQL exception occurred. The error is: org.apache.hive.service.cli.HiveSQLException: Error while complining statement:FAILED: HiveAccessControlException Permission denied: Principal[name=,type] does not have following previlegers for operation QUERY[[SELECT] on Object[type=TABLE_OR_VIEW,name]]