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 <dtishanpub...@gmail.com> Date: Tue, 19 Jun 2012 12:17:42 To: <user@hive.apache.org> Reply-To: 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
