Re: Row Delimiter in Create table
Thank you. On Wed, Dec 17, 2014 at 8:55 PM, Navis류승우 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 : >> >> 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 >> >
Re: Row Delimiter in Create table
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 : > > 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 >
Row Delimiter in Create table
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