Thanks Edward, That worked.
2011/4/7 Edward Capriolo <edlinuxg...@gmail.com> > On Thu, Apr 7, 2011 at 8:38 AM, Jasper Knulst <jasper.knu...@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
<<image001.gif>>
