did you try LINES TERMINATED BY ?
On 6/3/2010 6:45 AM, Akira Kitada wrote:
> 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.