Home | About | Sematext search-lucene.com search-hadoop.com
 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?
Nitin kak 2012-05-22, 16:42
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
>>
>
>