You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by "arvind@cloudera.com" <ar...@cloudera.com> on 2011/08/09 18:07:57 UTC

Re: [sqoop-user] sqoop having equal number of parse as executions

[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 <im...@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.
>