-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.
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.
On Thu, Feb 21, 2013 at 3:54 PM, Tim Goodman <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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) ?