Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Configuring the number of rows per insert statement?


Copy link to this message
-
Re: Configuring the number of rows per insert statement?
Thats awesome. Thanks Chalcy.

On Tue, May 22, 2012 at 11:48 AM, Chalcy <[EMAIL PROTECTED]> wrote:

> Hi Nitin,
>
> Using sqoop.export.records.per.statement , you can set the number of rows
> desired.
>
> --Chalcy
>
> On Tue, May 22, 2012 at 10:15 AM, Nitin kak <[EMAIL PROTECTED]> wrote:
>
>> Hi All,
>>
>>      I am actually working on Sqoop export functionality(Hadoop->RDBMS).
>> I can see that Sqoop supports multi-row insert statements at 100
>> rows/statement. Is this number configurable? If not, is there some work
>> going on in this direction.
>>
>> I found out that each mapper exporting data to RDBMS does it in a
>> separate transaction. My question is do the transactions commit in parallel
>> on the RDBMS side?
>>
>> Thanks in advance,
>> Nitin Kak
>>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB