Hello Fawze,   Not sure if you are still experiencing the same issue for now. This issue was resolved from CDH 5.15.    As a workaround for the CDH version before 5.15, I would suggest you to add any non existing user in Default pool settings. ## CM->Clusters->Dynamic Resource Pool Configuration->Impala Admission Control-> Default Settings->Check "Allow these users and groups to submit to this pool"-> Add any non existing user under "Users". Like "<non_existing_user>" Refresh Dynamic resource pool. And try to re run the impala query and check if it still throwing the error or not.   Thanks Benny ... View more

oozie.action.max.output.data is the Max size in characters for output data. The logical max size that you can store is 16MB in the DB. Setting high value to this setting will not affect Oozie job per say, however, it will affect any operations that will interact with DB, both reading and writing. I recommend that you keep this number as small as possible, ideally no more than 2MB. ... View more

Please also try to use Cloudera Manager navigate to,  Oozie > Configuration > Oozie Server Group > Advance > Oozie Server Advanced Configuration Snippet (Safety Valve)  for  oozie-site.xml ... View more