Member since
08-29-2018
8
Posts
0
Kudos Received
0
Solutions
09-07-2018
09:33 AM
Thx @Jay Kumar SenSharma, this solved my problem. I used your suggestion and modified the jdbc string.
... View more
09-07-2018
01:01 AM
I receive the following error after installing hive Metastore connection URL: jdbc:mysql://europa.diamond/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: hive
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.
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: java.sql.SQLException : The server time zone value 'EDT' 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.
SQL Error code: 0
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
How do I solve this issue?
... View more
Labels:
- Labels:
-
Apache Hive
08-29-2018
09:04 PM
Labels:
- Labels:
-
Hortonworks Data Platform (HDP)