@AhmedAl_Attar Thanks much for your prompt reply But am looking something on LOE for KS8..like no.of hours if we go in that direction. ... View more

Not sure whether my question is relevant to this subject line, if not my apologies if am posting in the wrong subject post. Currently we have SAS Viya 3.5 and We would like to know what could be a possible LOE for K8S ? like man hours and timings if we go that path.   Would really appreciate if you guys could provide some information on above   Thank you in advance.         ... View more

Thank you Chris Do I need to enable any settings for this python code to run from SAS Enterprise Guide ? ... View more

Sorry I didnt get you, what details you need ? ... View more

Am looking into to execute Python code within SAS Environment ? ... View more

I had similar kind of issues...throws error Cannot open data set, Connection is lost or abandoned   Can you please advise on this   When SAS EG is left inactive for indefinite time, SAS EG disconnects the session and am loosing all my work data from the run. When I connect to SAS EG and run any job that creates temp datasets in work library and creates libraries. If I leave the session open and perform other tasks, SAS is not running anything at that moment in time, it is inactive but the project is open and connected the server session. When am back check after some time and EG session disconnecting from it’s session, work data is lost and created libraries are disconnected and no longer exist. Have to reconnect and rerun project to retrieve data and libraries. ... View more

Sorry I didnt get you   No my question is    so how does the multiple servers would fit in below libname statement for server = ?   libname hdp hadoop server=hxpduped port=10000 schema=default user=myusr1 password=mypwd1; ​ libname hdp hadoop server=hxpduped hive_principal='hive/_HOST@HD.COMPANY.COM';   we have high availability for hive server2   HOST=<pcnkadpnt01.abc-abc.com:3020>,<pcnkadpnt02.abc-abc.com:3020>,<pcnkadpnt03.abc-abc.com:3020>     ... View more

I was able to connect to hive with ./isql command from sas server What would be the next step to accomplish sas to hadoop connectivity to pull data from hadoop to sas.   Can I run below libname statements from SAS EG to accomplish this ?   For Hadoop servers, we have multiple servers, we have high availability for Hive server2 so how does the multiple servers would fit in below libname statement for server = ? libname hdp hadoop server=hxpduped port=10000 schema=default user=myusr1 password=mypwd1; ​ libname hdp hadoop server=hxpduped hive_principal='hive/_HOST@HD.COMPANY.COM';   # /opt/odbc/unixodbc/bin/isql hivedb +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> show tables; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tab_name | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | csvinternal | | cvsexternal | | sample_07       ... View more

After performing below steps, everything went well..but I got stuck at the last step when connecting to the DB. I encountered with the below error when testing the connectivity to verify whether am able to list the database and access the table data Can you advice me where am going wrong in this [S1000][unixODBC][Hortonworks][Hardy] (76) Error connecting to ZooKeeper. Please ensure the ZooKeeper host(s) and other connection information are configured correctly. [ISQL]ERROR: Could not SQLConnect >Installed and Configured the Hive Driver and unixodbc drivers with no issues ./configure --prefix=/opt/odbc/unixodbc --exec-prefix=/opt/odbc/unixodbc/oth --bindir=/opt/odbc/unixodbc/bin --sbindir=/opt/odbc/unixodbc/sbin --libexecdir=/opt/odbc/unixodbc/libexec --sysconfdir=/opt/odbc/unixodbc/etc --libdir=/opt/odbc/unixodbc/lib --includedir=/lib --includedir=/lib64 make make install >Ensure that the libraries installed (if UnixODBC was installed from source files) are included in LD_LIBRARY_PATH export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/lib64:/opt/odbc/unixodbc/lib >Copied the files from hive installation directory into this location # cp /usr/lib/hive/lib/native/hiveodbc/Setup/odbc.ini /opt/odbc/unixodbc/etc/odbc.ini # cp /usr/lib/hive/lib/native/hiveodbc/Setup/odbcinst.ini /opt/odbc/unixodbc/etc/odbcinst.ini   >Configured the odbc.ini file [hivedb] Driver=/usr/lib/hive/lib/native/Linux-amd64-64/libhortonworkshiveodbc64.so HOST=node1.hortonworks.com PORT=10000 HiveServerType=2 AuthMech=1 UID=hive KrbHostFQDN=kerb.hortonworks.com KrbServiceName=hive KrbRealm=HWX.COM >Exported the variables to ensure that only our configured configuration files are being used export ODBCINI=/opt/odbc/unixodbc/odbc.ini export ODBCSYSINI=/opt/odbc/unixodbc export HORTONWORKSHIVEINI=/usr/lib/hive/lib/native/Linux-amd64-64/hortonworks.hiveodbc.ini >Tested the connectivity Got the ticket from Hive and Kerberos using keytab file. # kinit -k -t /tmp/hive.service.keytab hive/node1.hortonworks.com@HWX.COM # klist Once the ticket is granted, executed the following command to test connectivity # /opt/odbc/unixodbc/bin/isql hivedb -v but I encountered with the below error when testing the connectivity to verify whether am able to list the database and access the table data [S1000][unixODBC][Hortonworks][Hardy] (76) Error connecting to ZooKeeper. Please ensure the ZooKeeper host(s) and other connection information are configured correctly. [ISQL]ERROR: Could not SQLConnect ... View more

Thanks for the links   Since we don't we have SAS Access interface to Hadoop license, and we will have to try with SAS Access interface to ODBC. What version of Hadoop ODBC driver I need to install from below links   So below would be the steps right i need to follow to make the connection from SAS to Hadoop and vice versa.   > Install Hadoop ODBC driver on Unix server on compute machine   > Configure the environment variables and are there any other files similar to tnsnames and odbci.ini files in oracle and sqlserver that i need to configure for Hadoop   > Once the above steps done test with the libname statement and do i need to install any Hadoop servers in sas management console for this testing     would appreciate if you could point me to link with the steps for this set up via odbc driver   ... View more

Could you please share with any link with all the steps to accomplish this task ? ... View more