I am facing the issue while extracting the data from hive tables.
Hive Table structure
Field1
Field2
Field3
1
TRUE
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|TEST CAR RACE FORMULA F1 CODE
2
FALSE
TEST
3
TRUE
CAR RACE
I tried to read the data from Hive table by using qlikview (QV 11 SR2)
I am getting output like this:
Field1
Field2
Field3
1
TRUE
2
FALSE
TEST
3
TRUE
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.