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 <james.war...@stanfordalumni.org> 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
