Hi Senthil, Thanks for the link i followed the link and stuck with error.Do you know where should i download slf4j from ?
Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory at org.apache.thrift.transport.TIOStreamTransport.<clinit>(TIOStreamTransport.java:38) at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:91) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at HiveJdbcClient.main(HiveJdbcClient.java:22) Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) ... 6 more On Thu, Jul 5, 2012 at 11:33 AM, Senthil Kumar < senthilku...@thoughtworks.com> wrote: > Hi, > > The following link tells how to run HQL that are generated from application > using Hive JDBC driver > > https://cwiki.apache.org/confluence/display/Hive/HiveClient > > Regards > Senthil > > On Thu, Jul 5, 2012 at 9:00 PM, Sandeep Reddy P < > sandeepreddy.3...@gmail.com > > wrote: > > > Hi Michael, > > No i didn't we have a 5 node cluster with hive running on one of the > nodes. > > > > On Thu, Jul 5, 2012 at 11:26 AM, Michael Segel < > michael_se...@hotmail.com > > >wrote: > > > > > Have you tried using Hive's thrift server? > > > > > > On Jul 5, 2012, at 10:20 AM, Sandeep Reddy P wrote: > > > > > > > We use hive Jdbc drivers to connect to RDMS. But we need our > > application > > > > which generates HQL to connect directly to Hive. > > > > > > > > On Thu, Jul 5, 2012 at 11:12 AM, Bejoy KS <bejoy.had...@gmail.com> > > > wrote: > > > > > > > >> Hi Sandeep > > > >> > > > >> You can connect to hdfs from a remote machine if that machine is > > > reachable > > > >> from the cluster, and you have the hadoop jars and right hadoop > > > >> configuration files. > > > >> > > > >> Similarly you can issue HQL programatically from your application > > using > > > >> hive jdbc driver. > > > >> > > > >> ------Original Message------ > > > >> From: Sandeep Reddy P > > > >> To: common-user@hadoop.apache.org > > > >> To: cdh-u...@cloudera.org > > > >> Cc: t...@cloudwick.com > > > >> ReplyTo: common-user@hadoop.apache.org > > > >> Subject: Hive/Hdfs Connector > > > >> Sent: Jul 5, 2012 20:32 > > > >> > > > >> Hi, > > > >> We have some application which generates SQL queries and connects to > > > RDBMS > > > >> using connectors like JDBC for mysql. Now if we generate HQL using > our > > > >> application is there any way to connect to Hive/Hdfs using > > connectors?? > > > I > > > >> need help on what connectors i have to use? > > > >> We dont want to pull data from Hive/Hdfs to RDBMS instead we need > our > > > >> application to connect to Hive/Hdfs. > > > >> > > > >> -- > > > >> Thanks, > > > >> sandeep > > > >> > > > >> > > > >> > > > >> Regards > > > >> Bejoy KS > > > >> > > > >> Sent from handheld, please excuse typos. > > > >> > > > > > > > > > > > > > > > > -- > > > > Thanks, > > > > sandeep > > > > > > > > > > > > -- > > Thanks, > > sandeep > > > -- Thanks, sandeep