sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin kak <nitinkak...@gmail.com>
Subject Re: Configuring the number of rows per insert statement?
Date Tue, 22 May 2012 16:42:26 GMT
Thats awesome. Thanks Chalcy.

On Tue, May 22, 2012 at 11:48 AM, Chalcy <chalcy@gmail.com> 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 <nitinkak001@gmail.com> 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
>>
>
>

Mime
View raw message