You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by wd <wd...@wdicc.com> on 2011/05/18 05:46:15 UTC

Use spacial chars in hive split

Hi,

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

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

Re: Use spacial chars in hive split

Posted by Jasper Knulst <ja...@vlc.nl>.

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" <wd...@wdicc.com> het volgende:
> Hi,
>
> Can I use a spacial char like '^B' as the split pattern ?
>
> I've tried '\002', '^B', '0x02', all failed.