https://communities.sas.com/t5/SAS-Programming/unable-to-connect-hortonworks/m-p/459050#M116545 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/85346">@rseelam</a>,</P> <P>&nbsp;</P> <P>This is an old post. Hopefully, you have gotten past this.</P> <P>&nbsp;</P> <P>Believe it or not, this could still be a configuration issue. It sounds like the connection to Hive is failing or the Hive server isn't there. If you are connecting to the Cloudera Quickstart or Hortonworks Sandbox there are numerous VM configuration issues you can run into.</P> <P>&nbsp;</P> <P>This SAS Communities thread may help:</P> <P><A href="https://communities.sas.com/t5/SAS-Data-Management/No-sasdata-written-to-Hadoop-only-metadata/m-p/158659/highlight/true#M2834" target="_self">https://communities.sas.com/t5/SAS-Data-Management/No-sasdata-written-to-Hadoop-only-metadata/m-p/15...</A></P> <P>&nbsp;</P> <P>Best wishes,</P> <P>Jeff</P> Tue, 01 May 2018 18:24:13 GMT JBailey 2018-05-01T18:24:13Z https://communities.sas.com/t5/SAS-Programming/unable-to-connect-hortonworks/m-p/275125#M54976 <P>hi, i have extracted jars and xml configs using hadooptracer.py(173 jar files)&nbsp;script and executed libname statement and below is the error.</P><P>libname hdp hadoop server="abc.net" schema=default port=10000 subprotocol=hive2;</P><P>&nbsp;</P><P>ERROR: Unable to connect to the Hive server.<BR />ERROR: Error trying to establish connection.<BR />ERROR: Error in the LIBNAME statement</P> Fri, 03 Jun 2016 21:47:48 GMT https://communities.sas.com/t5/SAS-Programming/unable-to-connect-hortonworks/m-p/275125#M54976 rseelam 2016-06-03T21:47:48Z https://communities.sas.com/t5/SAS-Programming/unable-to-connect-hortonworks/m-p/459050#M116545 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/85346">@rseelam</a>,</P> <P>&nbsp;</P> <P>This is an old post. Hopefully, you have gotten past this.</P> <P>&nbsp;</P> <P>Believe it or not, this could still be a configuration issue. It sounds like the connection to Hive is failing or the Hive server isn't there. If you are connecting to the Cloudera Quickstart or Hortonworks Sandbox there are numerous VM configuration issues you can run into.</P> <P>&nbsp;</P> <P>This SAS Communities thread may help:</P> <P><A href="https://communities.sas.com/t5/SAS-Data-Management/No-sasdata-written-to-Hadoop-only-metadata/m-p/158659/highlight/true#M2834" target="_self">https://communities.sas.com/t5/SAS-Data-Management/No-sasdata-written-to-Hadoop-only-metadata/m-p/15...</A></P> <P>&nbsp;</P> <P>Best wishes,</P> <P>Jeff</P> Tue, 01 May 2018 18:24:13 GMT https://communities.sas.com/t5/SAS-Programming/unable-to-connect-hortonworks/m-p/459050#M116545 JBailey 2018-05-01T18:24:13Z