Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Problem when trying to connect to hive server using jdbc


Copy link to this message
-
Re: Problem when trying to connect to hive server using jdbc
Hi

First of if u r planning to run YARN on 4.2.0 then stay with 4.1.2.

I installed 4.2.0 but had to roll back :-( Hit upon this error https://issues.cloudera.org/browse/DISTRO-461. If u r not using yarn then it will not affect u.

When u install Cloudera Manager, it installs Hive. But Hive-server and hive-metastore you have to install your self. I have installed CM on Centos and Ubuntu. Never had to copy around any hive jars. Only jar to be copied is mysql.

I am assuming u have setup (https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-ConfiguringHiveServer2) all MYSQL related stuff in the hive-site.xml specially
hive.metastore.uris
javax.jdo.option.ConnectionURL
javax.jdo.option.ConnectionDriverName
javax.jdo.option.ConnectionUserName
javax.jdo.option.ConnectionPassword
datanucleus.autoCreateSchema
datanucleus.fixedDatastore

Does hive CLI start successfully ? U can see debug messages by starting hive CLI this way
$HIVE_HOME/bin/hive -hiveconf hive.root.logger=INFO,console

In CLI Execute command "Show Tables"

Check Mysql server machine
---------------------------------------
If MySQL is on another Server that what Hive is installed .Then on the MySQL box check the /etc/hosts
<Ipaddress_mysql_server>  FQDV_mysql_server  alias_11
<Ipaddress_hive_box>  FQDV_hive_box  alias_22

In my.cnf
bind-address            = 0.0.0.0
Check if some old PATH and env variables are pointing to improper location.

Try an older version of mysql jar..I use 5.1.22
Thanks

sanjay
From: demian rosas <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Monday, April 1, 2013 1:43 PM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Problem when trying to connect to hive server using jdbc

Hi,

I am using hive from CDH4.2 in a fresh installation. I want to set a mysql metastore.

When trying to connect to hive server using jdbc I am getting this error:

Exception in thread "main" java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at Conn.main(Conn.java:8)
I have copied the jdbc hive jar (hive-jdbc-0.10.0-cdh4.2.0.jar) into my CLASSPATH, as well as my mysql connector jar (mysql-connector-java-5.1.24-bin.jar).

I would appreciate a lot if you could tell me what I am missing here.

Thanks a lot,
Demian

CONFIDENTIALITY NOTICE
=====================This email message and any attachments are for the exclusive use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message along with any attachments, from your computer system. If you are the intended recipient, please be advised that the content of this message is subject to access, review and disclosure by the sender's Email System Administrator.