@Lorenzo On CDP Hive the Spark engine is deprecated if favor of TEZ      ... View more

Hello!   SQOOP takes advantage of YARN to create a distributed IMPORT/EXPORT job To do so, it needs to compile your query for the mappers to actually execute the job   Check out the following links for further information:   https://sqoop.apache.org/docs/1.4.7/SqoopUserGuide.html - Section 8.2 Table 18 https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/orm/CompilationManager.java#L50   Hope this helps,   Sincerely, José M Martínez Poblete Cloudera Support Hive SME US/East/Shift5 my.cloudera.com/faq/support.html USA: 1-866-809-4659 INTL: 1-650-425-9421   ... View more

Use the following command reference These are to be executed from Hive Beeline to view Role Privileges and Assignments > SHOW ROLES; List available roles > SHOW CURRENT ROLES; List roles assigned to current user/group > SHOW ROLE GRANT GROUP <GROUP NAME>; Lists the roles that are assigned to the specified group. > SHOW GRANT ROLE <ROLE>; Lists the permissions that have been granted to the specified role. >SHOW GRANT ROLE <role name> ON <object type> <object name> Lists the permissions that a role has on an object. ... View more

What is the specific version of HDP /CDH / CDP ? ... View more

Note the class should be com.cloudera.hive.jdbc.HS2Driver Make sure to use the parameters as detailed in the driver docs shared on the previous response A sample KNOX JDBC string looks similar to this: jdbc:hive2://<HOST>:8443/default;SSL=1;SSLTrustStore=/etc/truststore.jks;SSLTrustStorePwd=changeit;AuthMech=3;TransportMode=http;httpPath=gateway/cdp-proxy-api/hive;UseNativeQuery=0;IgnoreTransactions=1;LogLevel=6;LogPath=/tmp/jdbc/ When all details have been entered, click on Test Connection Good Luck! ... View more

Gabriel, We'd still recommend to have it enabled in only one instance  To avoid race conditions and such Thank You, -JMP ... View more

Andrea, On the node running HS2, locate the most recent hive.keytab using ``` ls -ltr /var/run/cloudera-scm-agent/process/*hive_on_tez-HIVESERVER2/hive.keytab | tail -1 ``` Then kinit as `hive/@REALM` After that, you should be able to scan directories owned by the Hive user ``` hdfs dfs -ls /tmp/hive ``` Hope this helps -JMP ... View more

Hi Andrea,   Is this a kerberized environment? Best, -JMP ... View more