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?
Hi Tim,
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 [1]. We're currently working on getting new version 1.4.3, that will contain this feature.

Jarcec

Links:
1: https://issues.apache.org/jira/browse/SQOOP-724

On Thu, Feb 21, 2013 at 08:54:47PM +0000, Tim Goodman 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