> Hi all, > > I am trying to use Transform in Hive, but I do not find a way to change > the separator between fields of input records in Transform. > > I create a table A by specify ROW FORMAT DELIMITED FIELDS TERMINATED BY > '\0' > > However, while using > SELECT TRANSFORM(id,name) USING 'python script.py' > AS (id,name) > FROM A > > I find that the separator of input is TAB instead of '\0' , > does anyone know how to change it to '\0'? Thanks. >
How to change the separator of INSERT OVERWRITE LOCAL DIRECTORY
I believe it is bug not able to change field seperator when sinking data to files. It is already fixed in version 0.11.0. See https://issues.apache.org/jira/browse/HIVE-3682. On Wed, May 29, 2013 at 4:37 PM, Felix.徐 <[EMAIL PROTECTED]> wrote:
> Hi all, > > I am wondering how to change the fields separator of INSERT OVERWRITE > LOCAL DIRECTORY , does anyone have experience doing this ? thanks! >
-- Regards, Ted Xu
RE: How to change the separator of INSERT OVERWRITE LOCAL DIRECTORY
Works for me like this, using the most recent Hive on AWS, using a ~ delimiter:
> create external table mydata (<your schema here>) row format delimited fields terminated by '~' stored as textfile location 's3://mybucket/path/to/data'; > insert overwrite table mydata select * from otherdata;
From: Felix.徐 [mailto:[EMAIL PROTECTED]] Sent: 29 May 2013 09:38 To: [EMAIL PROTECTED] Subject: How to change the separator of INSERT OVERWRITE LOCAL DIRECTORY
I am wondering how to change the fields separator of INSERT OVERWRITE LOCAL DIRECTORY , does anyone have experience doing this ? thanks!
********************************************************************** Please consider the environment before printing this email or attachments
This email and any attachments are confidential, protected by copyright and may be legally privileged. If you are not the intended recipient, then the dissemination or copying of this email is prohibited. If you have received this in error, please notify the sender by replying by email and then delete the email completely from your system. Neither Sporting Index nor the sender accepts responsibility for any virus, or any other defect which might affect any computer or IT system into which the email is received and/or opened. It is the responsibility of the recipient to scan the email and no responsibility is accepted for any loss or damage arising in any way from receipt or use of this email. Sporting Index Ltd is a company registered in England and Wales with company number 2636842, whose registered office is at Gateway House, Milverton Street, London, SE11 4AP. Sporting Index Ltd is authorised and regulated by the UK Financial Services Authority (reg. no. 150404) and Gambling Commission (reg. no. 000-027343-R-308898-001). Any financial promotion contained herein has been issued and approved by Sporting Index Ltd.
Outbound email has been scanned for viruses and SPAM
All projects made searchable here are trademarks of the Apache Software Foundation.
Service operated by Sematext