Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

sqoop custom lines terminated by parameter

avatar
Rising Star

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.

1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2

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

avatar
Rising Star

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