Thank you.
On Wed, Dec 17, 2014 at 8:55 PM, Navis류승우 <navis....@nexr.com> wrote: > > 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 >> >