SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Remove Carriage Return in SAS dataset imported from Hive

Reply
New Contributor
Posts: 4

Remove Carriage Return in SAS dataset imported from Hive

Hi ,

 

I am trying to import a hive data into SAS using ODBC connection to HIVE server. In one of the columns of HIVE table there are carriage return characters.

When I import the data into SAS from HIVE table, the values of the column containing carriage return are moved to next column/row.

 

Can anyone please help me solve this.

 

 

Thanks

Super User
Posts: 8,055

Re: Remove Carriage Return in SAS dataset imported from Hive

Please post your import code. Normally, I would expect the ODBC to handle this correctly. I suspect that somewhere in between there's a conversion to a text file/stream where the CR's have their unpleasant effect.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 2 in conversation