sathishkumar_go
Partner - Specialist
2016-09-06
01:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
279 Views
0 Replies