Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sravankv
Partner - Contributor III
Partner - Contributor III

Reading a long string from Hive using Qlikview

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.Long string.PNG

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';

Labels (2)
1 Solution

Accepted Solutions
sravankv
Partner - Contributor III
Partner - Contributor III
Author

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

View solution in original post

2 Replies
Edge
Creator
Creator

Hey @sravankv

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

Maybe issue in connection.

sravankv
Partner - Contributor III
Partner - Contributor III
Author

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