Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB