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 RE: Sqoop Export with Netezza
Date Thu, 31 May 2012 14:42:53 GMT
Any suggestions/comments ?

From: Neelavar Rao, Rakesh
Sent: Tuesday, May 29, 2012 5:29 PM
To: user@sqoop.apache.org
Subject: Sqoop Export with Netezza


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.


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.

View raw message