AnsweredAssumed Answered

Hive: LINES TERMINATED BY only supports newline '\n' right now.

Question asked by antonio.zornoza on Dec 20, 2014
Latest reply on Dec 23, 2014 by mikeengland
hello,

I have files where the column is delimited by char(30) and the lines are delimited by char(31). I'm using these delimiters mainly because the columns may contain newline (\n), so the default line delimiter for hive is not useful for us.

I have tried to change the line delimiter in hive but get the error below:

LINES TERMINATED BY only supports newline '\n' right now.

Any suggestion?

Write custom SerDe may work?
is there any plan to enhance this functionality in hive in new releases?

thanks

Outcomes