topic Re: Qlik Sense ODBC driver for Hive limits 255 symbols in field in App Development

Qlik Sense ODBC driver for Hive limits 255 symbols in field

lylererger — Mon, 03 Oct 2022 15:19:58 GMT

Hello friends!

We have 2 ways to connect to Hive (using an ODBC driver and using a native Hive driver).
Have you encountered the problem of loading a character string with a dimension of more than 256 characters from Hive? When we use the native Have driver, all the characters of the string field are loaded, but too slowly. And when using an ODBC connection, the field values are empty. Moreover, if you limit the number of characters of the field to 256 like that

tmp_1:
SQL SELECT
gp_id as gp_id_1,
substr(gp_text,0,256) as gp_text_1,
gp_type as gp_type_id1
FROM scheme.global_problems
WHERE gp_id in ('abc123');

, then they are successfully loading and displayed, everything that is more - simply does not load.
What to do in this situation, how to make the ODBC driver load more than 255 characters from Hive in the field?

Any ideas?

Thank you in advance for the answer!

Re: Qlik Sense ODBC driver for Hive limits 255 symbols in field

Frank_S — Mon, 03 Oct 2022 17:38:29 GMT

@lylererger

Perhaps this external link that 'appears' to be similar to your issue may help?

Please have a look at your convenience. The link is safe but check it at your discretion as well.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Field-Size-Limitation-when-connecting-to-Hive-Server/td-p/59838

Also checkout this github thread:

https://github.com/dotnet/runtime/issues/63630

If not, perhaps others here may be able to assist.

Kind regards...

Re: Qlik Sense ODBC driver for Hive limits 255 symbols in field

lylererger — Tue, 06 Dec 2022 19:34:21 GMT

It works. Thanks