My Oracle Support Banner

"java.sql.SQLException: Insufficient privileges to execute add" Error Running an ODI Mapping from One Hive Table to Another (Doc ID 1970309.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


The error below occurs when running an ODI mapping that loads data from one Hive table to another using any Hive IKM. For example, IKM Hive Transform or IKM Hive Control Append.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.