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
