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
