sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chalcy <cha...@gmail.com>
Subject Re: Does Sqoop acquire any locks when importing from SQL Server?
Date Fri, 22 Feb 2013 01:06:07 GMT
Yes, there is a way to with(nolock).  Use --query tag and specify the next
to it like 'select * from mytable where $CONDITIONS with(nolock)'

This is the only way we do sqoop imports.

Cheers,
Chalcy

On Thu, Feb 21, 2013 at 3:54 PM, Tim Goodman <tim@hooklogic.com> wrote:

>  Hi,****
>
> ** **
>
> I'm using Sqoop to import from SQL Server. I'm wondering if any locks are
> acquired on the table I'm importing from, and if so, is there a way to do
> the equivalent of WITH(NOLOCK) ?****
>
> ** **
>
> Thanks,****
>
> ** **
>
> - Tim****
>
> ** **
>

Mime
View raw message