BookmarkSubscribeRSS Feed
yf_nf
Fluorite | Level 6

Hello everyone, I’m currently using SAS Viya and able to successfully connect to Hive using the following libname statement:

libname var hadoop user='user' pwd='{SAS002}xxxxxxxxxxxxxxxxxx' server='10.10.10.10' port=10000 schema=schema_name;

 

I would like to know if it’s possible to establish a similar connection between SAS Viya and ClickHouse.

 

Any guidance or shared experience would be appreciated!

1 REPLY 1
LinusH
Tourmaline | Level 20

Given the information on their web page, ODBC seems like the option to use for you:

Drivers and Interfaces | ClickHouse Docs

Data never sleeps

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
Discussion stats
  • 1 reply
  • 1312 views
  • 0 likes
  • 2 in conversation