topic Re: SAS ODBC Hadoop kerberos vs knox issues with column names in SAS Programming

SAS ODBC Hadoop kerberos vs knox issues with column names

Rveerepalli — Tue, 06 Apr 2021 14:01:51 GMT

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.

Re: SAS ODBC Hadoop kerberos vs knox issues with column names

ChrisNZ — Wed, 07 Apr 2021 00:44:44 GMT

This look like something to do with the ODBC driver configuration. Have you looked there?

Re: SAS ODBC Hadoop kerberos vs knox issues with column names

Rveerepalli — Thu, 08 Apr 2021 14:08:05 GMT

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.

Re: SAS ODBC Hadoop kerberos vs knox issues with column names

SASKiwi — Thu, 08 Apr 2021 20:31:26 GMT

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.