I am not able to install the HAWQ Standby master on an AWS cluster running HDP 2.4.2 and Ambari 2.2.2 Here is the error: "This can be run only on master or standby host" Not sure what that means. It is not being installed on a DN, with PFX installed. It is not bing installed on the Ambari node. I am using the Name Node (since I only have 3 HDP master nodes) to install the HAWQ Standby Master. I attempted to remove the HAWQ Standby (that does not start) from the Name node and placed it on another node just to test. It gives the same error. So right now I am just running without a standby master. See How do I begin trouble shooting this? ... View more

We are looking for re-assurance that our data sitting in Hive right now is protected from the outside world. We set up SQL workbench on our local PCs and connect to it like shown below. However, it doesn’t matter what we put in for Username & Password, it still let’s us connect to our Hive data which is concerning us for security reasons. How can I be assured us that if some hacker out in the world came across our external IP (xx.xx.xx.xxxx), they wouldn’t be able to access our data in Hive? I cannot set up AD auth from Azure since I cannot access my corporate AD, so LDAP Authentication is not possible, and I do not want to set up a MIT KDC Should I: Leave Hive Authentication to None but apply SQL Standard Authorizations (See https://community.hortonworks.com/questions/22086/can-we-enable-hive-acls-without-ranger.html and https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization) Should I set up Ranger instead of SQL Standard Auth? With either above would this ensue that if someone log in as hive/ hive, the tables are still secured with the appropriate authorizations? ... View more