wpakkala
Explorer

Re: Error setting up hive on HDP 2.6.5.....timezon...

by Explorer in Support Questions
‎09-07-2018 09:33 AM
‎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

Error setting up hive on HDP 2.6.5.....timezone on...

by Explorer in Support Questions
‎09-07-2018 01:01 AM
‎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:

Re: where are the tutorial users or how do I creat...

by Explorer in Support Questions
‎08-29-2018 11:22 PM
‎08-29-2018 11:22 PM
@Jay Kumar SenSharma The md5 values match. ... View more

Re: where are the tutorial users or how do I creat...

by Explorer in Support Questions
‎08-29-2018 10:24 PM
‎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

Re: where are the tutorial users or how do I creat...

by Explorer in Support Questions
‎08-29-2018 10:18 PM
‎08-29-2018 10:18 PM
@Jay Kumar SenSharma...yup, that is the problem...Thanx ... View more

Re: where are the tutorial users or how do I creat...

by Explorer in Support Questions
‎08-29-2018 10:03 PM
‎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
Contact Me
Online
Offline
Last Visited
‎09-07-2018 01:31 PM
Public Statistics
Date Registered ‎08-29-2018 07:58 PM
Last Visited ‎09-07-2018 01:31 PM
Total Messages Posted 8