question sqoop custom lines terminated by parameter in Archives of Support Questions (Read Only)

sqoop custom lines terminated by parameter

2rajukv — Fri, 18 Aug 2017 23:14:54 GMT

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.

Re: sqoop custom lines terminated by parameter

ssubhas — Mon, 21 Aug 2017 11:07:48 GMT

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

Re: sqoop custom lines terminated by parameter

2rajukv — Tue, 22 Aug 2017 09:57:08 GMT

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