Sqoop, mail # user - Does Sqoop acquire any locks when importing from SQL Server?

Does Sqoop acquire any locks when importing from SQL Server?

Tim Goodman 2013-02-21, 20:54

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

Re: Does Sqoop acquire any locks when importing from SQL Server?

Chalcy 2013-02-22, 01:06

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 <[EMAIL PROTECTED]> 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****
>
> ** **
>

RE: Does Sqoop acquire any locks when importing from SQL Server?

Tim Goodman 2013-02-22, 06:19

Thank you. I guess I'll go that route until version 1.4.3.

- Tim

From: Chalcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2013 8:06 PM

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 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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

Re: Does Sqoop acquire any locks when importing from SQL Server?

Jarek Jarcec Cecho 2013-02-22, 00:02

Hi Tim,
Sqoop is issuing usual select queries, so it does the same locks as the query would. No extra additional locking is performed by Sqoop.

We've recently improved build-in Microsoft SQL Connector to support table hints, please check out SQOOP-724 [1]. We're currently working on getting new version 1.4.3, that will contain this feature.

Jarcec

Links:
1: https://issues.apache.org/jira/browse/SQOOP-724

On Thu, Feb 21, 2013 at 08:54:47PM +0000, Tim Goodman 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
>