How to load csv file to Hive table with \n symbols inside text columns

Question

I'm trying to load CSV file to Hive table and my file contains '\n' - carriage return symbols inside some text columns.

Is there an easy way to import this to Hive? I know I can write custom format for this, but possibly there is easier way?

UPDATED

sample data (CSV) 2 lines:

"1","title","some text","more detailed text \n with some carriage returns\n\n\n"
"2","title2","some text2","more detailed text2222 \n with some carriage returns\n\n\n"

schema:

CREATE EXTERNAL TABLE train (
    id BIGINT, title string, content string, details string
)

Any help will be much appreciated. Thanks.

show sample data and schema you want for your table – Balaswamy Vaddeman Oct 21 '13 at 12:49 — Balaswamy Vaddeman, Oct 21 '13 at 12:49
I've updated question with this. – Maxim Galushka Oct 22 '13 at 12:03 — Maxim Galushka, Oct 22 '13 at 12:03

score 0 · Accepted Answer · edited May 23 '17 at 11:57

0

step 1. replace \n with some character using tr or sed in local file

cat filename|tr "\n" " " >>new_filename.csv

step 2 create table in hive using create statement

edited May 23 '17 at 11:57

Community

1
1

answered Oct 22 '13 at 13:00

Balaswamy Vaddeman

8,360
3
30
40

How to load csv file to Hive table with \n symbols inside text columns

1 Answers1