-Re: does sqoop support SQL_BUFFER_RESULT to help with long running queries?
Arvind Prabhakar 2012-01-05, 18:08
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.
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,