Nulls in hive tables after loaded data into hdfs

Five Stars

Nulls in hive tables after loaded data into hdfs

Hi all,

      Am trying to get the records from mssql to hive using hdfs path (.txt file)

 

      tmssqlCDCinput ---->thdfsoutput

 

     tpostjob --->thiveconn ---> thiveload

 

by this design now am getting "nulls" in hive tables.can you please help us to resolve this issue

 

Thanks,

Sai babu

 

Forteen Stars

Re: Nulls in hive tables after loaded data into hdfs

@saibabu ,it could be data type issue,what are you creating in hive table and the data what you are getting into thdfsoutput.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: Nulls in hive tables after loaded data into hdfs

Thanks for your reply .i resolved the issue bcoz of this error " predicate 'user' identifier column". now am getting values in hive tables

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch