Qlik Sense ODBC driver for Hive limits 255 symbols in field

[lylererger]

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!

Qlik Sense Business 

[Frank_S · Accepted solution]

@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-...

Also checkout this github thread:

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

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

Kind regards...

[lylererger]

It works. Thanks