Hi,

Can I use a spacial char like '^B' as the split pattern ?

I've tried '\002', '^B', '0x02', all failed.

Hi,

To my knowledge Hive currently only supports single byte separators in the
DELIMITED BY clause. So you can only pick one of the first 128 ASCII
characters.

Or use a custom Serde to map your data.

Jasper
Op 18 mei 2011 05:46 schreef "wd" <[EMAIL PROTECTED]> het volgende:
> Hi,
>
> Can I use a spacial char like '^B' as the split pattern ?
>
> I've tried '\002', '^B', '0x02', all failed.