Qlik Compose May2021 required permissions on Cloudera CDP

[Abrie_M]

Good day

Using Qlik Compose 2021.5.0.69  (Data Lakes) on our CDP cluster  we found the following error:

org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:199], sqlState:42000, errorCode:40000, errorMessage:Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [svcAttunityAcc] does not have [CREATE] privilege on [groupbi_abrie_poc_v]), Query: CREATE DATABASE IF NOT EXISTS groupbi_abrie_poc_v.>.

Is this normal behavior for Compose to want to create databases? According to the documentation, the only permissions needed on the storage zone are:

So far I could not log a support case, as there is no option available for Qlik Compose (only the older versions).

Regards

Abrie Marais

[Abrie_M]

Just an update.

Compose also needs 2 additional databases <storage>_v and <storage_v_internal.

We could not find reference to this in the documentation.

After we've created the databases, we could continue with our project configuration.

[TimGarrod · Accepted solution]

@Abrie_M  -  The _V database provides access to the Consumer views created by Compose.   The v_internal creates some artifacts leveraged by Compose for processing as well as consumed within the live views built in the storage_v database.

The naming of these can be changed in the Project Settings / Naming tab.

https://help.qlik.com/en-US/compose/May2021/Content/ComposeDWDL/Main/DL/Projects/edit_project_settin...

This doc discusses the _v database and views created by Qlik Compose 

https://help.qlik.com/en-US/compose/May2021/Content/ComposeDWDL/Main/DL/Data%20Warehouse/working_wit...

Hope that helps.  If you need to discuss further, just let me know.

[Abrie_M]

Thanx Tim for your feedback. I'll have a look.

Regards

Abrie