Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
tsagarrao
Contributor
Contributor

Problem in retriving the data from Hive database using QV ODBC connection

Hi,

I am trying to pull the data from Hive database, but One of the row in field ABC has data string more than 256 characters. So the field row showing as blank.For the rest of the rows which are having less than 256 characters, It is pulling the data perfectly. I have used Concat(substr(x,1,250),substr(x,251,400)) as ABC in QVD generator to overcome the problem as temporary solution. I would like to know is there any other solution to avoid this problem while pulling the data like select * from HDB table without using concat?

0 Replies