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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.