few minuets before i saw this post i just successfully solved the problem, i had two issues one i did not create hive db CREATE DATABASE hive; i base it on your post from https://community.hortonworks.com/answers/107905/view.html another issue i had i in the db url connection, i change it, to localhost. i am trying to accept your answer but i cant, don't have a button for it? next stage is to try it with non root install ... View more

@Geoffrey Shelton Okot Problem resolved by simply Service Restart ) Thanks. ... View more

@Geoffrey Shelton Okot, Yes, that answers my doubt. Thank you so much for your response. ... View more

@arjun more If you have KDC and AD integrated, this simply means the account to which the keytab is related has been disabled, locked, expired, or deleted. The AD service account should NEVER expire. If not could you validate the below steps Make sure the [realms] and [domain_realms] entries in cat /etc/krb5.conf is correct. Validate the contents of these 2 files /var/kerberos/krb5kdc/kdc.conf , /var/kerberos/krb5kdc/kadm5.acl Check the hdfs prinncipal # kadmin.local Authenticating as principal hdfs-uktehdpprod/admin@EUROPE.ODCORP.NET with password. kadmin.local: listprincs hdfs* hdfs-uktehdpprod@EUROPE.ODCORP.NET kadmin.local: Get the correct prncipal for hdfs # klist -kt /etc/security/keytabs/hdfs.headless.keytab Keytab name: FILE:/etc/security/keytabs/hdfs.headless.keytab KVNO Timestamp Principal ---- ------------------- ------------------------------------------------------ 1 08/24/2017 15:42:23 hdfs-uktehdpprod@EUROPE.ODCORP.NET 1 08/24/2017 15:42:23 hdfs-uktehdpprod@EUROPE.ODCORP.NET 1 08/24/2017 15:42:23 hdfs-uktehdpprod@EUROPE.ODCORP.NET Try grabbing a valid Kerberos ticket # kinit -kt /etc/security/keytabs/hdfs.headless.keytab hdfs-uktehdpprod@EUROPE.ODCORP.NET Validate the avalability period # klist Ticket cache: FILE:/tmp/krb5cc_0 Default principal: hdfs-uktehdpprod@EUROPE.ODCORP.NET Valid starting Expires Service principal 10/04/2017 19:36:12 10/05/2017 19:36:12 krbtgt/EUROPE.ODCORP.NET@EUROPE.ODCORP.NET Please revert ... View more

@Benjamin Hopp @Chad Woodhead I had the exact same issue and tried bringing down both of my two NiFi nodes, waiting a few minutes, and brought them back online. Then I tried turning on the PutHDFS processor and it worked properly. Has anyone figured out why this solves the issue or what is causing this problem? ... View more

@PJ Okay good to know enjoy ... View more

@Hiren Gala Can you give te screenshot and parameters used? The following are possible causes of this issue: 1. Incorrect port and/or Hive Service defined in connection. 2. Network issues. 3. The Hive server is not started. Please revert ... View more

Thanks advince. The issue was resolved after changing the realms name from dev.com to DEV.COM ... View more

Thank you @Geoffrey Shelton Okot, I have added hosts in client machine, it works like charm. ... View more