Eric Huang created SQOOP-1670:
---------------------------------
Summary: Propose to add banwidth control support when using Sqoop
import/export tools
Key: SQOOP-1670
URL: https://issues.apache.org/jira/browse/SQOOP-1670
Project: Sqoop
Issue Type: Improvement
Components: connectors
Reporter: Eric Huang
Fix For: 1.4.4
As far as I know, Sqoop can't Specify the maximum amount of DB bandwidth that
one Sqoop process can utilize for the import/export purpose in term of the
number of bytes per second. For some cases such as online applications, DB
bandwidth
is very important. If one Sqoop process uses most of DB bandwidth, other apps
based on the same DB will suffered a lot. So I want to provide a small patch,
which is very useful for my case. When starting sqoop import/export tasks, you
just need to give an argument (-Dsqoop.db.bandwidth=5242880, means specifying
bandwidth to 5M) after import or export tool name, for example:
$bin/sqoop import -Dsqoop.db.bandwidth=5242880 --connect
jdbc:mysql://192.168.1.28:9001/db_name --table t_order --hbase-table t_order
--column-family f --hbase-create-table --username 'root' --password 'root' --m 3
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
