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

Switch to Threaded View
Sqoop >> mail # user >> does sqoop support SQL_BUFFER_RESULT to help with long running queries?


Copy link to this message
-
Re: does sqoop support SQL_BUFFER_RESULT to help with long running queries?
Hi James,

This has not been tested before - but you could possibly use the
--query option to supply your own query that contains the necessary
optimization hints. If you find that not working, or limiting in some
way - you could also try extending the
org.apache.sqoop.manager.MySQLManager implementation to create your
own connector that does understand such optimizations.

Thanks,
Arvind

On Wed, Jan 4, 2012 at 4:45 PM, James Warren
<[EMAIL PROTECTED]> wrote:
> Greetings -
>
> Was wondering / hoping if it were possible to configure sqoop to use
> SQL_BUFFER_RESULT in the generated select queries.  From my understanding
> sqoop uses READ_COMMITTED as the isolation level, but I'd ideally like to
> release the write locks as soon as possible to help alleviate any
> replication lag.
>
> Many thanks,
> -jw