sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Goodman <...@hooklogic.com>
Subject RE: Does Sqoop acquire any locks when importing from SQL Server?
Date Fri, 22 Feb 2013 06:19:15 GMT
Thank you.  I guess I'll go that route until version 1.4.3.

- Tim

From: Chalcy [mailto:chalcy@gmail.com]
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 <tim@hooklogic.com<mailto: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