Hi Bejoy, Thanks. Will an external table also do the same thing? On Tue, Jun 19, 2012 at 12:35 PM, Bejoy KS <[email protected]> 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 requirement done my creating an intermediate table . > > 1) Define the intermediate table with the required delimiter of your > choice. > 2) Load data from original table to this intermediate table. > 3) Do the Insert Overwrite to local directory from this table > > > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > ------------------------------ > *From: * tishan pubudu kanishka dahanayakage <[email protected]> > *Date: *Tue, 19 Jun 2012 12:17:42 +0530 > *To: *<[email protected]> > *ReplyTo: * [email protected] > *Subject: *Define field delimiters for output files > > Hi all, > Is there a way to define the field delimiter for output file when using > the command > INSERT OVERWRITE LOCAL DIRECTORY 'path' > > > -- > Regards, > Tishan > > -- Regards, Tishan
