topic Re: hive.resultset.use.unique.column.names = false not working in SAS Programming

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

angie16 — Tue, 03 May 2022 16:58:42 GMT

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;

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

ChrisNZ — Fri, 13 May 2022 10:13:55 GMT

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 ?

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

angie16 — Fri, 13 May 2022 14:57:14 GMT

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.

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

ChrisNZ — Wed, 18 May 2022 06:30:48 GMT

Run

%put %sysfunc(sysget(SAS_HADOOP_CONFIG_PATH));

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