Hi @Raja723 ,   Could you please share a screenshot for us to see which step you were asked to enter database name and table name? Please use the Add a Role wizard to add the Reports Manager role. During the step, it should ask you the database host, database type, database name and username/password. As long as you specify the values correctly, the wizard should do a database connection and create the necessary tables in the database for you automatically. Please make sure you follow the documentation to create the database first and make sure that CM server can make successful connection to the RMAN database. Here is the documentation for Mysql: https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ig_mysql.html#mysql_configure_cm_db   Thanks and hope this helps, Li ... View more

Hi @Ma ,   Please check this community thread in regarding to Cloudera Manager 6.1 Express functionality change: https://community.cloudera.com/t5/Product-Announcements/ANNOUNCE-Cloudera-Manager-6-1-Express-functionality-change/td-p/84180   In short, from Cloudera Enterprise 6.1 and higher, we are limiting Cloudera Express customers using both CM6 and CDH6 to a maximum of 100 deployable nodes across all of their environments.   Thanks and hope this answers your question. Li   ... View more

@Alieer ,   Did you upgrade CM/CDH on your cluster recently?   From the error snippet below: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'A0.OWNER_TYPE' in 'field list' It looks like the Hive Hive Metastore Database Schema may not be upgraded correctly.    Please try these steps: 1. From Cloudera Manager, stop Hive service 2. On the UI, Clusters -> Hive -> Actions -> Upgrade Hive Metastore Database Schema 3. Start Hive service 4. Try your test again   Thanks and hope this helps, Li ... View more

Hi @vikaskanchan ,   I believe you are asking a question about authorization for specific services access. I am not quite sure if there is a specific way to authorize users just using Spark. What we do have are permissions, ACLs, Sentry for the underlying data that services such as Spark or Pig would need. For example, HDFS and Hive can be configured using Sentry and Spark Jobs typically access HDFS and Hive data. More details about authorization can be found here: https://www.cloudera.com/documentation/enterprise/latest/topics/sg_authorization.html Cloudera Manager only provides Users Roles authorization which does not seem to fit your need: https://www.cloudera.com/documentation/enterprise/latest/topics/cm_sg_user_roles.html   Thanks, Li ... View more

Hi @SandeepSingh ,   Please use role config groups instead of role types. You can see relevant methods in ApiService to get and create groups. You may want to read this thread which people experienced the similar error message. https://grokbase.com/t/cloudera/scm-users/1373r4h204/cm-api-create-cluster-error   Thanks and hope this helps, Li ... View more