sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "arvind@cloudera.com" <arv...@cloudera.com>
Subject Re: [sqoop-user] sqoop having equal number of parse as executions
Date Tue, 09 Aug 2011 16:07:57 GMT
[bcc:sqoop-user@cloudera.org (deprecated),
to:sqoop-user@incubator.apache.org. Please continue the discussion on
Apache mailing lists - for more information see [1]].

Hi Sonal,

Sqoop does use prepared statements and batch insert semantics. Look at
the implementation of DBInputFormat/DBOutputFormat [2] for details on
how the import/export semantics work.

Thanks,
Arvind

[1] https://cwiki.apache.org/confluence/display/SQOOP/Mailing+Lists
[2] https://svn.apache.org/repos/asf/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/db/

On Tue, Aug 9, 2011 at 7:58 AM, Sonal <imsonalkumar@gmail.com> wrote:
> Hi,
>
> I have a simple sqoop export which loads 900k rows in a table.
> But in database , I can see number of  parses and execution are same.
> Instead of doing it once.
> Is it not using PreparedStatement?
> Does it support batchsize/fetchsize ?
>
>
> Thanks & Regards,
> Sonal Kumar
>
> --
> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of Apache Sqoop
mailing list sqoop-user@incubator.apache.org. Please subscribe to it by sending an email to
incubator-sqoop-user-subscribe@apache.org.
>

Mime
View raw message