hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Vary <pv...@cloudera.com>
Subject Re: LINES TERMINATED BY only supports newline '\n' right now
Date Thu, 02 Jun 2016 17:29:14 GMT
Hi,

According to the documentation you should write and set your own
Inputformat when creating the table.

Mike Sukmanowsky solved a similar problem here, this might help you:
http://stackoverflow.com/questions/7692994/custom-inputformat-with-hive

Regards,
Peter
For some of the columns '\n' character is there as part of value, i want to
create a hive table for this data i tried by creating the hive table with
US as the line separator but it showing the below message

Ex:
CREATE EXTERNAL TABLE IF NOT EXISTS emp (name String,id int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '28'
LINES TERMINATED BY '31'
LOCATION 'emp.txt file path';

FAILED: SemanticException 4:20 LINES TERMINATED BY only supports newline
'\n' right now. Error encountered near token ''31''

how can we create hive table with out removing the \n character as part of
column value ( requirement data need to maintain as it is)

can any one implemented hive tables with line separated other than \n

Thanks & Regards
   Radha krishna

Mime
View raw message