topic Re: Reading a long string from Hive using Qlikview in QlikView

Reading a long string from Hive using Qlikview

sravankv — Sat, 16 Nov 2024 01:06:18 GMT

Hi All,

I have a view in hive db which contains a single field and it contains only one record with length 1,055,112 characters.

When I try to read this data, I am getting empty field.

But, when I tried to read the same from a .txt file, it is getting loaded without any issue.

So, is there any string limit in qlikview while reading data from hive and can you help me in resolving this issue.

I am just using select * from HIVE 'db'.'view';

Edge — Mon, 09 Mar 2020 13:39:26 GMT

Did you try to read a short string from same DB?

Maybe issue in connection.

sravankv — Mon, 09 Mar 2020 14:39:59 GMT

@Edge Yes, I tried with short string and it loaded perfectly.

Any how i found a thread hope this will resolve my issue.

I will update again, if this works thanks.