SAS ODBC Hadoop kerberos vs knox issues with column names

[Rveerepalli]

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.

[ChrisNZ]

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

[Rveerepalli]

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. 

[SASKiwi]

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.