IBM Support

Datastage using Hive with odbc -error java.lang.RuntimeException:org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: userid is not allowed to impersonate hive

Troubleshooting


Problem

When testing using the DataDirect example program - encountered this error MSG = [IBM(DataDirect OEM)][ODBC Apache Hive Wire Protocol driver][Hive]Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: hive/xxxx is not allowed to impersonate hive

Resolving The Problem

In hdfs configurations, You need to add following keys and values:

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21972388