代码:
val spark: SparkSession = SparkSession.builder().master("local[*]").appName("SparkSQL") .config("spark.sql.warehouse.dir","file:///D://sparkTest").getOrCreate()
//必须配置config("spark.sql.warehouse.dir","file:///D://sparkTest")
val sc: SparkContext = spark.sparkContext
val sqlContext = new SQLContext(sc)
val jdbcDF = sqlContext.read.format("jdbc").options(Map("url"->"jdbc:mysql://192.168.43.49:3306/world?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","driver"->"com.mysql.cj.jdbc.Driver","dbtable"->"city","user"->"root","password"->"******")).load()
jdbcDF.show(5)
问题一
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet successfully received from the server was 319 milliseconds ago. The last packet sent successfully to the server was 319 milliseconds ago.
问题二
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException:
The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
问题一解决方法
//首先进入MySQL Server的bin目录下,命令行输入mysql -hlocalhost -uroot -p
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -hlocalhost -uroot -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.7.30-log MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
//mysql设置wait_timeout
mysql> set global WAIT_TIMEOUT=1814400;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'wait_timeout';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| wait_timeout | 1814400 |
+---------------+---------+
1 row in set, 1 warning (0.00 sec)
问题二解决方法
serverTimezone=UTC//一定要有