BookmarkSubscribeRSS Feed
deepika2
Fluorite | Level 6

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

1 REPLY 1
Kurt_Bremser
Super User

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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 971 views
  • 0 likes
  • 2 in conversation