Hi,

Hive uses TextInputFormat by default and which treats '\n' AND '\r' as
a line separator.
However I don't want '\r' to be treated as a separator.
Does Hive provide a way to set custom InputFormat?
I tried 'STORED AS file_format' to do this but it seems it didn't work for me.
I use 0.4.0.

Thanks

Akira,

   did you try LINES TERMINATED BY ?

-- amr

On 6/3/2010 6:45 AM, Akira Kitada wrote:
> Hi,
>
> Hive uses TextInputFormat by default and which treats '\n' AND '\r' as
> a line separator.
> However I don't want '\r' to be treated as a separator.
> Does Hive provide a way to set custom InputFormat?
> I tried 'STORED AS file_format' to do this but it seems it didn't work for me.
> I use 0.4.0.
>
> Thanks
>

STORED AS file_format didn't work just because my TextInputFormat was
based on Hadoop new API.
After rewriting it with old API it just worked.

Thanks.
On Thu, Jun 3, 2010 at 10:45 PM, Akira Kitada <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Hive uses TextInputFormat by default and which treats '\n' AND '\r' as
> a line separator.
> However I don't want '\r' to be treated as a separator.
> Does Hive provide a way to set custom InputFormat?
> I tried 'STORED AS file_format' to do this but it seems it didn't work for me.
> I use 0.4.0.
>
> Thanks
>