Re: Define field delimiters for output files

2012-06-19 Thread Bejoy KS
Bejoy KS Sent from handheld, please excuse typos. -Original Message- From: tishan pubudu kanishka dahanayakage Date: Tue, 19 Jun 2012 13:26:49 To: ; Reply-To: user@hive.apache.org Subject: Re: Define field delimiters for output files Hi Bejoy, Thanks. Will an external table also do the

Re: Define field delimiters for output files

2012-06-19 Thread tishan pubudu kanishka dahanayakage
Hi Bejoy, Thanks. Will an external table also do the same thing? On Tue, Jun 19, 2012 at 12:35 PM, Bejoy KS wrote: > ** > Hi Tishan > > AFAIK there is no way to specify the delimiter in INSERT OVERWRITE > command. The delimiter could be specified on table creation only. > > You can get your requ

Re: Define field delimiters for output files

2012-06-19 Thread Bejoy KS
Hi Tishan AFAIK there is no way to specify the delimiter in INSERT OVERWRITE command. The delimiter could be specified on table creation only. You can get your requirement done my creating an intermediate table . 1) Define the intermediate table with the required delimiter of your choice. 2) L