How to ingest '\n' in data with hive

[#1]

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.

For eg.

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.

Workaround

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

[#2]

Thanks for this @rchaman

Do you have a best practice suggestion for for \n ingestion via SAS - via libname?