hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gayathri Swaroop <g3.vasude...@gmail.com>
Subject Re: Row Delimiter in Create table
Date Thu, 18 Dec 2014 10:13:40 GMT
Thank you.

On Wed, Dec 17, 2014 at 8:55 PM, Navis류승우 <navis.ryu@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.vasudevan@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
>>
>

Mime
View raw message