SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Memory setup for HIVE in SAS

Frequent Contributor
Posts: 106

Memory setup for HIVE in SAS

Hi SAS users,


I am trying to create Table using PROC SQL connecting to Hadoop  to pull the data from hive tables. I am getting memory issue and i  have asked to SET; in my SAS code. I tried adding it as option and it is erroring .

Can anyone suggest me where and how to use memory setting for Hive data pull's.


CONNECT TO HADOOP (user=&user. password=&password. server="XXXX" port=10039 subprotocol=hive2 DBMAX_TEXT=80
30       ! );
ERROR: Invalid option name




Super User
Posts: 3,551

Re: Memory setup for HIVE in SAS

I suspect you need to use the PROPERTIES = option like properties = 'MyProperties' as in this link:


While the link is for the LIBNAME statement you could try it in a CONNECT statement.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation