sqoop custom lines terminated by parameter

[#1]

We are using hdp 2.5.3 and sqoop version "1.4.6.2.5.3.0-37". Please let us know if any one used custom delimiter for line(record) other than default newline '\n' delimiter ?

Sqoop guide no details mentioned on this.

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html

--lines-terminated-by <char> Sets the end-of-line character

We have requirement to use octal character 016 as record delimiter.

[#2 · Accepted solution]

@RajuKV

The table definition "LINES TERMINATED BY" only supports newline '\n' right now. This is a known issue and Jira Hive 11996 has already been raised for the issue.

[#3]

Thanks @Sindhu we wish soon this JIRA will get a fix.