Hello all,
When using knox gateway for ODBC connection to Hadoop from SAS 9.4, I see column names normally. However, when I use ODBC connection using kerberos (and zookeeper) , SAS is seeing columns names differently. It is appending table name as prefix to column name.
Did anyone encounter similar issues. Any solutions?
Tried multiple validvarnames combinations in libname statement in vain.
This look like something to do with the ODBC driver configuration. Have you looked there?
As indicated, only connection type is changed here. Everything else remains the same. If connected using knox, it works normally. It shows this behaviour only when using zookeeper with kerberos.
This looks like a problem best handled by SAS Tech Support if you haven't raised a track already. This is a very niche topic.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.