Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Define field delimiters for output files


Copy link to this message
-
Re: Define field delimiters for output files
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.

-----Original Message-----
From: tishan pubudu kanishka dahanayakage <[EMAIL PROTECTED]>
Date: Tue, 19 Jun 2012 12:17:42
To: <[EMAIL PROTECTED]>
Reply-To: [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