spark_运行spark-shell报错_javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database.

error:

# ./spark-shell

Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://sd-9c1f-2eac:3306/hive?createDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

 

resolve method: 

启动mysql

# service mysql start

 Starting MySQL.... [ OK ]

 

重新运行spark-shell

# ./spark-shell

Using Spark's default log4j profile: org/apache/spark/log4j-defaults.properties
Setting default log level to "WARN".
To adjust logging level use sc.setLogLevel(newLevel). For SparkR, use setLogLevel(newLevel).
17/03/14 23:28:39 WARN NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
17/03/14 23:28:42 WARN HiveConf: HiveConf of name hive.server2.thrift.client.user does not exist
17/03/14 23:28:42 WARN HiveConf: HiveConf of name hive.server2.thrift.client.password does not exist
17/03/14 23:28:43 WARN HiveConf: HiveConf of name hive.server2.thrift.client.user does not exist
17/03/14 23:28:43 WARN HiveConf: HiveConf of name hive.server2.thrift.client.password does not exist
17/03/14 23:28:46 WARN ObjectStore: Failed to get database global_temp, returning NoSuchObjectException
Spark context Web UI available at http://168.72.200.213:4040
Spark context available as 'sc' (master = local[*], app id = local-1489548520514).
Spark session available as 'spark'.
Welcome to
____ __
/ __/__ ___ _____/ /__
_\ \/ _ \/ _ `/ __/ '_/
/___/ .__/\_,_/_/ /_/\_\ version 2.1.0
/_/

Using Scala version 2.11.8 (Java HotSpot(TM) Server VM, Java 1.8.0_112)
Type in expressions to have them evaluated.
Type :help for more information.

scala>

posted @ 2017-03-15 11:33  天天好心情啊  阅读(5375)  评论(0编辑  收藏  举报