IBM Support

Jaql permissions problem when running as user other than BigInsights administrator user

Release Notes


Abstract

When Jaql jobs are run under a user ID other than the BigInsights administrator user, errors might be raised. The solution is to grant full permission to the Hadoop directory on DFS.

Content

When Jaql jobs are run under a user ID other than the BigInsights administrator user, permission denied errors such as the following message might be raised:

java.lang.reflect.UndeclaredThrowableException: could not initialize directories from system space
org.apache.hadoop.security.AccessControlException: org.apache.hadoop.security.AccessControlException: Permission denied: user=user1, access=WRITE, inode="hadoop":biadmin:supergroup:rwxr-xr-x


This is because the user executing the job does not have sufficient permission to write to the global temp space created by Jaql.

To work around this issue, grant full permission to the Hadoop directory on DFS. The following command provides sufficient privilege:
hadoop fs -chmod -R 777 /hadoop


After you have run this command, all users should be able to run Jaql jobs without encountering the error, above.

[{"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"1.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 July 2020

UID

swg27023514