Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Does Sqoop acquire any locks when importing from SQL Server?


Copy link to this message
-
RE: Does Sqoop acquire any locks when importing from SQL Server?
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