sqoop1从mysql向hive导入数据

  1 sqoop import \
  2     --connect jdbc:mysql://node1:3306/ycbk?dontTrackOpenResources=true\&defaultFetchSize=10000\&useCursorFetch=true\&useUnicode=yes\&characterEncoding=utf8 \
  3     --driver com.mysql.cj.jdbc.Driver \
  4     --username root \
  5     --password 12345678 \
  6     --delete-target-dir \
  7     --table area_info \
  8     --num-mappers 1 \
  9     --hive-import \
 10     --hive-database default \
 11     --hive-table TO_YCBK_AREA_D \
 12     --hive-overwrite \
 13     --fields-terminated-by '\t'