Nitin kak 2013-02-04, 19:41
Jarek Jarcec Cecho 2013-02-04, 20:28
Nitin kak 2013-02-04, 20:31
Nitin kak 2013-02-04, 22:39
Jarek Jarcec Cecho 2013-02-05, 01:10
Mason 2013-02-06, 17:38
Jarek Jarcec Cecho 2013-02-06, 17:47
Mason 2013-02-06, 18:14
Connell, Chuck 2013-02-04, 19:43
Nitin kak 2013-02-04, 19:53
I mean to add a step, putting a Python piped script in the middle. So instead of
RDBMS --> Sqoop --> Hive
You would do
RDBMS --> some file format --> Python (replacing ctrl-a) --> modified files --> Sqoop --> Hive
Does that help?
From: Nitin kak [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2013 2:53 PM
To: [EMAIL PROTECTED]
Subject: Re: String replace functionality in Sqoop import using Oozie
Didn't get you. Could you please elaborate just a bit?
On Mon, Feb 4, 2013 at 2:43 PM, Connell, Chuck <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Do it first with Python??
From: Nitin kak [mailto:[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>]
Sent: Monday, February 04, 2013 2:42 PM
To: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
Subject: String replace functionality in Sqoop import using Oozie
Is there a way to replace (or drop) a character in one of the fields on the fly while importing data from an RDBMS system? I basically want to replace Ctrl-A characters in the fields. I know its possible to do that with Sqoop Hive Import(--hive-delims-replacement) but Hive Sqoop import is know not to work correctly with Oozie(hope this one gets remedied soon).