@henimaher  It could be due to bug https://issues.apache.org/jira/browse/HIVE-21866    perform  yarn app -destroy llap0 and start LLAP service ... View more

https://docs.cloudera.com/HDPDocuments/Ambari-2.7.5.0/ambari-release-notes/content/known_issues.html ... View more

If you are using Kerberos for authentication, when a job is submitted, the user permissions are evaluated first by Ranger and once the authorization is successful, only then the Kerberos ticket is delegated to hive user and the hive user starts the execution. So, as long as the user who is submitting the job has a policy in Ranger, it should work as expected. Hope this helps. If the comment helps you to find a solution or move forward, please accept it as a solution for other community members. ... View more

@manicool7  Can you elaborate more on the issue here and are you ingesting data from any third party like (Tableau, qlik sense) ?   Attach the error details as well ... View more

@Sham  Can you collect yarn logs -applicationId application_1594037379069_89091 > app89091.txt and attach it here.     ... View more

Thanks @Prakashcit    If I am not wrong to enter a support case we should have license with Cloudera. Currently this is our test cluster and we don't have a license/subscription with Cloudera.   Thanks for your help @Prakashcit  ... View more

Hi all,   I had faced the same issue while kerberizing a HDP 3.1.0 cluster integrated with Iislon. The Ambari serer is a built on a Postgres DB cluster, hence it was NOT in the hadoop cluster. so it was NOT on the host list. [root@hdpdb ~]# curl -H "X-Requested-By: ambari" -u admin:admin "http://hdpdb.gz.local:8080/api/v1/clusters/Panyu/hosts"     I had to add the ambari server from adding host wizard and just install the clients. It worked around the "Host not found, hostname= xxxx" issue in my case.      Hope it will help, cheer!  ... View more

@Asoka wrote: I've 'solved' my problem by using -P.  I'll need to manually type my password for each table as I export them, but this is a mostly one-time operation, so the pain is minor. Use — P Option with Sqoop Command Sqoop supports reading passwords via standard input (STDIN). You can use this option by with help of — P options with sqoop command. Sqoop will prompt you for the password. Below is the example of using — P option: $sqoop import --connect jdbc:netezza://localhost/MYDB \ --username testuser -- P --table ORDERS   ... View more

@Lewis @Shelton @Prakashcit  Hi All, I did ranger re-installation and now it is working, but if i integrate hive with ldap, again getting same null pointer exception.    Note: we integrated hive with ldap not ranger, just creating same ldap user in ranger (local) and trying to match it with LDAP user. whether it will create any problem? Kindly advice on this.   select * from asop.test; Error: Error while compiling statement: FAILED: NullPointerException null (state=42000,code=40000) ... View more

ldap config had missing OU info , ldap auth works fine now. ... View more