Hey Mark, good article! Thought I'd resurface this by adding a note on point (3) above, for those who want to set up multiple HS2s and load balance as per http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_hadoop-high-availability/content/ch_multiple_hs2s.html And here is a sample LIBNAME syntax that would be used to connect from the SAS application: libname h2 hadoop URI=”jdbc:hive2://<server1>,<server2>,<server3>/default;
serviceDiscoveryMode=zooKeeper;zooKeeperNamespace="hiveserver2″
user=&sysuserid server=”dummy”;
... View more
