I solved this problem using the following method , but I do want to know why would one want to use the SERDE method and not this one? [hbase@hadoop1 ~]$ more a.csv 5842,50,30,4,240,340 5843,52,32,5,250,360 5844,56,31,2,248,333 [hbase@hadoop1 ~]$ create table test3(Id int, lowT string, highT string,vib int, lowP string,highP string) ROW FORMAT DELIMITED FIELDS TERMINATED BY "," STORED AS TEXTFILE TBLPROPERTIES("skip.header.line.count"="1"); load data inpath '/user/hbase/a.csv' OVERWRITE INTO TABLE test3; Loading data to table default.test3 Table default.test3 stats: [numFiles=1, numRows=0, totalSize=63, rawDataSize=0] OK Time taken: 0.668 seconds ... View more

@Sami Ahmad can you let us know the value of the property when yarn RM HA was done. This can be achieved by using the API is described in my last comment http://localhost:8080/api/v1/clusters/c1/configurations/service_config_versions?service_name=YARN&service_config_version_note=This%20configuration%20is%20created%20by%20Enable%20ResourceManager%20HA%20wizard I am trying to understand if that yarn property was set to true when RAM HA was done for the very first time and then later got reverted to false OR value of that property was false even when RM HA was completed We can know that by looking into the property value by using above API as that service config version is created when YARN RM HA is completed. Also let us know ambari version. It allows us to look into the correct version of ambari code and verify if it's a bug specific to the ambari version that you are using or not. ... View more

awesome approach . .the work around worked. thanks a lot ... View more

thank you that exactly was the issue, I added the user to all the nodes of the cluster and now hive works. ... View more

You may find this useful as well for future. https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients Also, be advised ranger only works with hiveserver2. ... View more

Hi @Sami Ahmad As per the attached screenshot you are getting error in the "Check Kerberos" action from one of the randomly selected client host by the ambari. It seems that install kerberos client went ok on all nodes. Its the kerberos service check that failed and so I believed issue was not on any particular client host. In this case if ambari would have selected any other kerberos client host to do service check, then the action would have failed even on that host. ... View more

Do you have the MIT KDC set up ? If not then please install it as documented below: https://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.1/bk_Ambari_Security_Guide/content/_optional_install_a_new_mit_kdc.html Once done choose the option "Use an Existing MIT KDC" ... View more