Re: Row Delimiter in Create table

2014-12-18 Thread Gayathri Swaroop
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.re

Re: Row Delimiter in Create table

2014-12-17 Thread Navis류승우
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+

Row Delimiter in Create table

2014-12-17 Thread 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 a