sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neelavar Rao, Rakesh" <Rakesh.Neelavar...@csgi.com>
Subject Sqoop Export with Netezza
Date Tue, 29 May 2012 21:29:20 GMT
Hi,

Wanted to know the experience of people who have used sqoop export from HDFS to Netezza RDBMS.
 Does it generate insert statements for each row to be inserted?  We did a small POC and saw
from the query logs individual insert statements. Since Netezza does not support multi row
inserts does it do individual insert statements?  Most of the netezza discussion forums advise
not to have individual inserts in netezza specially if you have large dataset to insert. 
Does Cloudera's Netezza connector do something under the hood to speed up this process?

Any feedback would be greatly appreciated.

[cid:image001.jpg@01CD3DBF.A5D61110]

Rakesh Neelavar Rao
Quaero, A CSG Solution
Big Data - Platform Architecture
(O) 704.687.5861 | (M) 704.840.2856
www.quaero.com<http://www.quaero.com/> | Follow Quaero's InsightIQ Blog<http://quaero.csgsystems.com/blog/>




________________________________
All emails in this message string and any attachments are the confidential information of
CSG Systems International, Inc. (CSG), or its affiliates and subsidiaries, and may contain
privileged and/or confidential material. If you are not an intended recipient, please delete
it immediately and notify the sender; unintended recipients are not authorized to read or
otherwise use the information contained herein.

Mime
View raw message