HI @Pradeep Allu please post your other question as a new question ... View more

@niraj nagle are you still having issues with this? Can you accept best answer or provide your own solution? ... View more

@Gerd Koenig good job, re-accepted to give you credit ... View more

@Artem Ervits Thanks. The post suggested was helpful. ... View more

@Vinod Nerella See this https://community.hortonworks.com/articles/16944/warning-setpgid31734-0-failed-errno-13-permission.html ... View more

@emaxwel @Artem @neeraj Gentlemen thanks for all your responses.Its unfortunate the bits can't be installed elsewhere except in /usr/hdp and furthermore administration of the various named used could have been simplified I am from the Oracle Application background at most there are 2 users for the ebs application and database. I will reformat the 4 servers. @emaxwell you have a very valid argument on the segregation of duties I will try to incorporate that "security concern" I dont want some dark angel poke holes in my production cluster ... View more

@Özgür Akdemirci Could you do me a favor please? 🙂 If you can post this as new question then it will helpful as its new issue. Accept one of the answers in this thread only if it was helpful. When you post a new question then post the output of hive show tables; ... View more

I am having similar issue We have non Kerberiozed Hadoop Kafka environment . I am testing integrating Ranger Kafak to secure the environment. HDP Version: HDP-2.3.4.0-3485 This is what I did. -- Enables Kafka plugin in Ranger. -- Restarted Ranger -- Create following policies in Ranger ( see the image ) ( Important : Added group Public left policy condition blank ) -- Logged in to server 21 to Produce and consume message's -- I was able to produce and consume messages from any server . What we want is to secure our Kafka environment through ranger by ip address. I understand that the identity of client user over a non-secure channel is not possible. I followed the following article to secure or Kafka environment. https://cwiki.apache.org/confluence/display/RANGER/Kafka+Plugin#KafkaPlugin-WhydowehavetospecifypublicusergrouponallpoliciesitemscreatedforauthorizingKafkaaccessovernon-securechannel Please let me know what I am missing. ... View more

We had this issue because some partitions pointed to a non HA location on hdfs. Fixed it by running: hive --config /etc/hive/conf/conf.server --service metatool [-dryRun] -updateLocation hdfs://h2cluster hdfs://h2namenode:8020 , In our case, the problem was that some hive partitions had incorrect location. We fixed it using hive metatool like this: hive --config /etc/hive/conf/conf.server --service metatool [-dryRun] -updateLocation hdfs://hcluster hdfs://namenode:8020 ... View more