hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jasper Knulst <jasper.knu...@vlc.nl>
Subject Re: Text output separator for Hive Output
Date Thu, 07 Apr 2011 15:53:50 GMT
Thanks Edward,

That worked.



2011/4/7 Edward Capriolo <edlinuxguru@gmail.com>

> On Thu, Apr 7, 2011 at 8:38 AM, Jasper Knulst <jasper.knulst@vlc.nl>
> wrote:
> > Hi,
> > How would I set the field separator for Hive output to files?
> > I see that the default is a space  (or tab, don't know exactly) but I
> would
> > like to use another character to facilitate loading of the output in
> another
> > system.
> > I already tried
> > set mapred.textoutputformat.separator='~';
> > But this doesn't work.
> > Thanks
> >
> > --
> > Kind Regards
> >
> > Jasper
>
> When you are doing output to the console \T is your only option. The
> best way to handle this is create another table with the delimiters
> you wish and then select into that table. You can do this with CTAS.
>
> Edward
>



-- 
Kind Regards \ Met Vriendelijke Groet,





Jasper Knulst

BI Consultant





VLC Den Haag
Gildeweg 5B
2632 BD  Nootdorp


M: +31 (0)6 19 66 75 11

T: +31 (0)15 764 07 50
------------------------------------------------------------

Skype: jasper_knulst_vlc

Mime
View raw message