Java使用mysql-jdbc连接MySQL出现如下警告:Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.在mysql连接字符串url中加入ssl=true或者false即可,如下所示。url=jdbc:mysql://127.0.0.1:3306/framework?characterEncoding=utf8&useSSL=true
1、查询语言不同:
hive是hql语言,mysql是sql语句;
2、数据存储位置不同:
hive是把数据存储在hdfs上,而mysql数据是存储在自己的系统中;
3、数据格式不同:
hive数据格式可以用户自定义,mysql有自己的系统定义格式;
4、数据更新不同:
hive不支持数据更新,只可以读,不可以写,而sql支持数据更新。
评论列表(0条)