Usually hive treats \n as newline character and everytime we ingest the data it will split single line into multiple lines depending on no of \n in the text.
Step1: Create a table and try ingesting the data using insert into table command.
Step2: List the contents of table. We will observe that single line with '\n' in between is split in two lines.
There are two ways to ingest data containing newline character
1. Using escape character
2. Using load data inpath command
Solution1: When we use escape character "\" with "\n", hive will ignore \n as newline but will treat it as string. (abcd\ndefg)
querying the table
Solution 2: Using "load data inpath" command.
Step1: Upload the file on HDFS
Step2: Load data from file to table
Thanks for this @rchaman
Do you have a best practice suggestion for for \n ingestion via SAS - via libname?