topic Re: SQL Script column case issue in QlikView

SQL Script column case issue

ma258827 — Sat, 16 Nov 2024 21:38:50 GMT

Hello Everyone,

we are trying to connect to hive database from Qlikview.

Example Script as:

SQL Select row_key as COLUMN1_KEY from table name;

When reload completes i see the loaded column name as column1_key(Small case) where as i was expecting it to be upper case.

Any suggestion why is it happening.

Thanks,

Manish Madan

Re: SQL Script column case issue

rupamjyotidas — Mon, 07 Jan 2019 16:46:31 GMT

Try Preceding Load:

Load row_key as COLUMN1_KEY ;

SQL Select row_key

from table name;

Re: SQL Script column case issue

ma258827 — Mon, 07 Jan 2019 18:06:44 GMT

Thanks Rupam.. i have implemented the solution already now i am looking for root cause.

Re: SQL Script column case issue

marcus_sommer — Tue, 08 Jan 2019 12:49:16 GMT

Maybe it's a feature/setting form your DB respectively your used driver.

- Marcus

Re: SQL Script column case issue

Brett_Bleess — Tue, 23 Jul 2019 20:53:21 GMT

Marcus would be on the right track for root cause on this one, we are simply passing the SQL Select info directly to the database connector driver, so the issue here should be in the driver settings...

Regards,
Brett