Issue while extracting the data from hive tables

sathishkumar_go — Tue, 06 Sep 2016 17:35:54 GMT

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:

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

topic Issue while extracting the data from hive tables in QlikView