@Raja Sekhar Chintalapati Can you share log information from the moment you try to start the metastore? Also the output of --> klist -kte /etc/security/keytabs/hive.service.keytab ... View more

@rakesh kumar You can enforce authorization at any level in hive using Apache Ranger Please have a look http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_security/content/overview_ranger_ambari_install.html ... View more

Please check the following, these could give you some pointers: https://community.hortonworks.com/content/supportkb/48949/how-can-i-use-sqoop-to-import-and-create-tables-wi.html https://community.hortonworks.com/articles/17469/creating-hive-partitioned-tables-using-sqoop.html ... View more

@Prakash Punj This happens when keystore where certificates were imported is GKR type instead of JKS. Recreate the keystore, import certificates (do not use self signed certificates in production environment) and run security setup for ambari again ... View more

@Joav Bally Could you ssh into the machine and retrieve /var/log/hive/hiveserver2.log from the time you try to start it? It would be more explicit if we go directly to the hiveserver2 log files instead of what Ambari brings ... View more

That's basically it, View cannot access hive because of hiveserver2 is down. Please copy and paste the output of the hiverserver2 when you try to starting it. Also hiveserver2.log file would be useful to see the underline problem ... View more

@Joav Bally Make sure you have hiveserver2 is up and running. Do the other checks passed successfully? ... View more

Hi @Andrew Watson @Constantin Stanca is right... you can start 2 or 3 different broker process, each with its own logs dir, etc... They will run as different brokers but in the same machine... You can create a config properties for one broker, then change broker id, port and log directory. Then copy it with different config and start each broker using the different config properties. Things to look at broker.id logs.dirs port (since running in same machine, need to be different) ... View more