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 <demia...@gmail.com<mailto:demia...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Monday, April 1, 2013 1:43 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> 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.
