@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

@Attu ,   Based on the official Cloudera documentation: https://www.cloudera.com/documentation/enterprise/6/release-notes/topics/rg_os_requirements.html#cdh_cm_supported_os It looks like the latest RHEL version supported by Cloudera Enterprise 6.3.x is 7.6. I can open a feature request to ask for supporting RHEL7.7.    It is recommended that you use the supported OS versions as that is fully tested by QA. Use the unsupported version may increase the chances of unexpected cluster issues.   Thanks and hope this helps, Li   ... View more