HI All,
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.
In HIve tables, Field3 type as string
Any idea?
-Sathish
