Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sathishkumar_go
Partner - Specialist
Partner - Specialist

Issue while extracting the data from hive tables

HI All,

I am facing the issue while extracting the data from hive tables.

Hive Table structure

   

Field1Field2Field3
1TRUETEST CAR RACE FORMULA F1 CODE|TEST CAR RACE FORMULA F1 CODE|TEST CAR RACE FORMULA F1 CODE|TEST CAR RACE FORMULA F1 CODE|TEST CAR RACE FORMULA F1 CODE|TEST CAR RACE FORMULA F1 CODE|TEST CAR RACE FORMULA F1 CODE
2FALSETEST
3TRUECAR RACE

I tried to read the data from Hive table by using qlikview (QV 11 SR2)

I am getting output like this:

   

Field1Field2Field3
1TRUE
2FALSETEST
3TRUE

CAR RACE


Why its showing blank values? it has to show the data? but the same field Field3 is showing other values means TEST, CAR RACE

Its because of length?

same I have tried to pull these values from csv and excel file its working fine.

In HIve tables, Field3 type as string

Any idea?

-Sathish

0 Replies