hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tishan pubudu kanishka dahanayakage <dtishanpub...@gmail.com>
Subject Re: Define field delimiters for output files
Date Tue, 19 Jun 2012 07:56:49 GMT
Hi Bejoy,
Thanks. Will an external table also do the same thing?

On Tue, Jun 19, 2012 at 12:35 PM, Bejoy KS <bejoy_ks@yahoo.com> 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 <dtishanpubudu@gmail.com>
> *Date: *Tue, 19 Jun 2012 12:17:42 +0530
> *To: *<user@hive.apache.org>
> *ReplyTo: * user@hive.apache.org
> *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

Mime
View raw message