topic Re: SAS connector to hadoop in Administration and Deployment

SAS connector to hadoop

aloou — Thu, 17 Feb 2022 14:02:08 GMT

hello everyone,

i am trying to lunch a parallel load from hive to sas but i receive an error :

ERROR: java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/opt/sas/Hadoop_INT/sitexmls/core-site.xml;

lineNumber: 190; columnNumber: 7; The element type "value" must be terminated by the matching end-tag "</value>".

ERROR: java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/opt/sas/Hadoop_INT/sitexmls/core-site.xml;

lineNumber: 190; columnNumber: 7; The element type "value" must be terminated by the matching end-tag "</value>".

What should i d o ?

Thanks

SASKiwi — Fri, 18 Feb 2022 00:53:06 GMT

Please post the SAS program that is producing these errors. I suspect you will need to open a Tech Support track for this to diagnose further.

aloou — Mon, 21 Feb 2022 10:55:25 GMT

in a proc cas;

i am using the option DataTranfermode='parallel'

this is how i got that error.

thank you

SASKiwi — Mon, 21 Feb 2022 20:04:50 GMT

Does it work without that option?

aloou — Tue, 22 Feb 2022 10:06:39 GMT

yes it works.

but it loads data in a serial mode (which takes a lot of time for large data).

LinusH — Tue, 22 Feb 2022 12:44:55 GMT

"SAS Data Connector to Hadoop lets you load data serially from Hive into SAS Cloud Analytic Services.

All users can use SAS Data Connector to Hadoop.

SAS Data Connect Accelerator for Hadoop is a separately licensed product that lets you load data in parallel using the SAS Embedded Process."

Do you license, have installed and configured SAS Data Connect Accelerator for Hadoop?