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.
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.
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.
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.