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
- Tags:
- Data Processing
- Hive
Labels:
- Labels:
-
Apache Hive
08-29-2018
11:22 PM
@Jay Kumar SenSharma The md5 values match.
... View more
08-29-2018
10:24 PM
@Jay Kumar SenSharma - Here is the vmware image I downloaded.... HDP_2.6.5_vmware_180622.ova I am concerned that it is packaged incorrectly.... Here is the screen shot and I am selecting the vmware image!
... View more
08-29-2018
10:18 PM
@Jay Kumar SenSharma...yup, that is the problem...Thanx
... View more
08-29-2018
10:03 PM
@Jay Kumar SenSharma...I have the standard download HDP_2.6.5_vmware_180622 installed and none of these users are within this vmware image. sandbox-hdf login: root
root@sandbox-hdf.hortonworks.com's password:
Last login: Wed Aug 29 18:40:32 2018
[root@sandbox-hdf ~]# su marie_dev
su: user marie_dev does not exist
[root@sandbox-hdf ~]# su - raj_ops
su: user raj_ops does not exist
[root@sandbox-hdf ~]#
Also, not sure how to close the other posting?
... View more
08-29-2018
09:30 PM
Labels:
- Labels:
-
Hortonworks Data Platform (HDP)