hive.resultset.use.unique.column.names = false not working

[angie16]

I have a libname with this as an option and I am still getting the table name prefixing the variable name.  I am using SAS 9.4.

Here is the code.   Do I have something wrong in the syntax?

libname &lib_name. ODBC dsn=HiveODBC_PROD user=&user_id. password="&hive_pwd." schema=&schema_name.
DBLIBINIT='set hive.resultset.use.unique.column.names=false'
connection=sharedread;

[ChrisNZ]

Long shot. Have you tried adding a semicolon?

DBLIBINIT='set hive.resultset.use.unique.column.names=false;'  ?

Or change the value in file hive-site.xml ?

[angie16]

Unfortunately, the ; doesn't seem to help.

Or change the value in file hive-site.xml ? could you give me a bit more info on this.  I am not sure what you mean....

Attaching the proc contents so you can see all the versioning and specs.

[ChrisNZ]

Run

%put %sysfunc(sysget(SAS_HADOOP_CONFIG_PATH));

to see the location of the xml files that define your configuration.