mysql - While starting Hive I am getting SSL error. Its working but I cant perform bucketing until I resolve the error -


below error:

tue sep 12 03:21:00 ist 2017 warn: establishing ssl connection without  server's identity verification not recommended. according mysql  5.5.45+, 5.6.26+ , 5.7.6+ requirements ssl connection must  established default if explicit option isn't set. compliance  existing applications not using ssl verifyservercertificate  property set 'false'. need either explicitly disable ssl  setting usessl=false, or set usessl=true , provide truststore  server certificate verification. 

how can resolve issue.any idea

this ssl warning can fixed putting "?usessl=false" in jdbc connection string present @ hive-site.xml.

ie

  <property>    <name>javax.jdo.option.connectionurl</name>    <value>jdbc:mysql://localhost/metastore?usessl=false</value>    <description>metadata stored in mysql server</description> 


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -