本地虚拟机安装有:jdk1.8、hadoop2.7.1、hive2.1.1、sqoop1.4.7、mysql5.7
阿里云RDSMysql版本为8.0
因为sqoop是要抽取阿里云Mysql8.0当中的数据,所以起初sqoop的lib目录下只放了mysql8.0的驱动,但是执行以下代码bin/sqoop list-databases --connect jdbc:mysql://rds:3306/ --username root -P
连接到阿里云mysql8.0时时依然遇到了提示:
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
解决方法:将mysql5.7的驱动也加入到其中
提示消失,问题解决: