-Re: Does Sqoop acquire any locks when importing from SQL Server?
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 . We're currently working on getting new version 1.4.3, that will contain this feature.
On Thu, Feb 21, 2013 at 08:54:47PM +0000, Tim Goodman wrote:
> 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) ?
> - Tim