@Srinivas Santhanam I guess you would have figured out by now. For others, the problem with above query is quotes in hdfs path, try without quote like below add jar hdfs:///tmp/udfs/hive/esri-geometry-api.jar ... View more

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