Afaik, it was restricted by implementation of hadoop. But now hadoop-2 supports custom delimiter, hopefully it also can be implemented in hive.
I'm not sure but currently possible way of do that is setting "textinputformat.record.delimiter" in table properties. Thanks, Navis 2014-12-18 6:20 GMT+09:00 Gayathri Swaroop <g3.vasude...@gmail.com>: > > Hi, > > I am trying to create table for a text file who has a row delimiter other > than new line character. I know hive create table does not support anything > other than new line. I have columns where in data contains new line so i > specified a new line character in my sqoop. What are the best options as > far as i googled or looked at the manual a transformation is required but > my table is real huge. > > Thanks, > G >
