從mysql增量導入資料到hive的sqoop語句

ERROR:org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

sqoop job --create sojob -- import --connect jdbc:mysql://node02:3306/sales_source \
--driver com.mysql.jdbc.Driver \
--username root --password 123456 \
--table sales_order \
--m 1 \
--hive-import \
--hive-overwrite \
--hive-database sales_rds \
--hive-table sales_order \
--fields-terminated-by '\t' \
--check-column 'order_number' \
--last-value '0' \
--incremental append \
;
           

sqoop job --exec sojob
           

資料庫連接配接池逾時：連接配接的等待時間(wait_timeout)預設為8小時。

使用centos7指令重新開機mysql

systemctl restart mysql;