---------- Forwarded message ---------- From: Alok Kumar <alok...@gmail.com> Date: Thu, Nov 24, 2011 at 7:18 PM Subject: Re: what changes required in hive conf xml when working with hive jdbc To: Vikas Srivastava <vikas.srivast...@one97.net>
Hi, Its working fine at $hive shell. No error, Able to create tables... I'm trying to connect using hive jdbc following this https://cwiki.apache.org/confluence/display/Hive/HiveClient , a java sample code is there user@ubuntu:~$ java -cp $CLASSPATH HiveJdbcClient Exception in thread "main" java.lang.NoClassDefFoundError: HiveJdbcClient Caused by: java.lang.ClassNotFoundException: HiveJdbcClient 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) Could not find the main class: HiveJdbcClient. Program will exit. i've set the correct $CLASSPATH and error was gone... but *control never returned to $Shell*.. i looked in my $hive shell with* show tables; *command... there wasn't any table created "testHiveDriverTable" as in my java sample code frm https://cwiki.apache.org/confluence/display/Hive/HiveClient.. ny idea..? Thanks, Alok On Thu, Nov 24, 2011 at 6:37 PM, Vikas Srivastava < vikas.srivast...@one97.net> wrote: > Wat Error you are getting when run show tables; or create table * > > On Thu, Nov 24, 2011 at 6:01 PM, Alok Kumar <alok...@gmail.com> wrote: > >> Hi All, >> >> Thanks for reply. >> >> @Vikas : I've just run, >> user@ubuntu:~$ sudo netstat -plten | grep 10000 >> tcp6 0 0 :::10000 :::* >> LISTEN 1000 253333 22444/java >> >> i thnk thrift server is running >> >> i run "*ant test -Dtestcase=TestHiveServer -Dstandalone=true*" from " >> https://cwiki.apache.org/confluence/display/Hive/HiveServer"; >> which says BUILD FAILED..! >> while "*ant test -Dtestcase=TestJdbcServer -Dstandalone=true*" is >> Successful >> >> my hive-default.xml contains... >> ************************************** >> <property> >> <name>javax.jdo.option.ConnectionURL</name> >> <!-- <value>jdbc:hive://localhost:10000/default</value>-->// I tried >> switching to this, but no help >> <value>jdbc:derby:;databaseName=metastore_db;create=true</value> >> <description>JDBC connect string for a JDBC metastore</description> >> </property> >> >> <property> >> <name>javax.jdo.option.ConnectionDriverName</name> >> <value>org.apache.derby.jdbc.EmbeddedDriver</value> >> <!-- <value>org.apache.hadoop.hive.jdbc.HiveDriver</value>--> >> <description>Driver class name for a JDBC metastore</description> >> </property> >> *************************************************** >> do i need to change anything here? >> my jdbc client sample code is trying to connect to "jdbc:hive: >> //localhost:10000/default" >> >> what's ur opinion? >> >> Thanks, >> Alok >> >> >> On Thu, Nov 24, 2011 at 5:37 PM, Vikas Srivastava < >> vikas.srivast...@one97.net> wrote: >> >>> for thrift sever u can check that >>> >>> by netstat -plten | grep 10000 >>> >>> it runs of 10000 port >>> >>> On Thu, Nov 24, 2011 at 5:28 PM, shashwat shriparv < >>> dwivedishash...@gmail.com> wrote: >>> >>>> https://cwiki.apache.org/confluence/display/Hive/HiveClient >>>> >>>> https://cwiki.apache.org/confluence/display/Hive/HiveJDBCInterface >>>> >>>> https://cwiki.apache.org/confluence/display/Hive/Home >>>> >>>> >>>> On Thu, Nov 24, 2011 at 3:37 PM, Alok Kumar <alok...@gmail.com> wrote: >>>> >>>>> >>>>> Hi, >>>>> >>>>> Do I need to make any change in hive configuration file when working >>>>> with hive-jdbc? >>>>> >>>>> I'm trying to configure Hive Jdbc following this link >>>>> https://cwiki.apache.org/confluence/display/Hive/HiveClient.<https://cwiki.apache.org/confluence/display/Hive/HiveClient> >>>>> >>>>> hive is up n running. I'm able to create table (or) execute queries at >>>>> $hive> >>>>> >>>>> jps returns : >>>>> user@ubuntu:~$ jps >>>>> 14202 JobTracker >>>>> 14624 HMaster >>>>> 16137 JUnitTestRunner >>>>> 13809 DataNode >>>>> 14864 RunJar >>>>> 16392 Jps >>>>> 15414 HiveJdbcClient >>>>> 14077 SecondaryNameNode >>>>> 13573 NameNode >>>>> 14441 TaskTracker >>>>> 16011 Launcher >>>>> 15251 RunJar >>>>> 15161 Main >>>>> >>>>> I've run Hive server as >>>>> $HIVE_HOME: bin/hive --service hiveserver >>>>> Starting Hive Thrift Server >>>>> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. >>>>> Please use org.apache.hadoop.log.metrics.EventCounter in all the >>>>> log4j.properties files. >>>>> >>>>> (Not sure if hive-server is running!) >>>>> >>>>> and run "$ java -cp $CLASSPATH HiveJdbcClient" for hive client from >>>>> this https://cwiki.apache.org/confluence/display/Hive/HiveClient. >>>>> I've set $CLASSPATH like >>>>> (export >>>>> CLASSPATH=$CLASSPATH:.:$HIVE_HOME/lib/*:$HADOOP_HOME/hadoop-0.20.2-core.jar) >>>>> after doing this "$ java -cp $CLASSPATH HiveJdbcClient", it just stuck >>>>> there!! >>>>> It should create a table "testHiveDriverTable" in hive, but "show >>>>> tables;" on $hive returns no such table. >>>>> >>>>> Please help.. any1 working with Hive Jdbc, am I missing any >>>>> configuration....? >>>>> >>>>> Regards, >>>>> Alok >>>>> >>>>> >>>> >>>> >>>> -- >>>> Shashwat Shriparv >>>> 09900059620 >>>> 09663531241 >>>> >>>> >>>> >>>> <iframe src=" >>>> http://rcm.amazon.com/e/cm?t=shriparv-20&o=1&p=48&l=ur1&category=kindlerotating&f=ifr"; >>>> width="728" height="90" scrolling="no" border="0" marginwidth="0" >>>> style="border:none;" frameborder="0"></iframe> >>>> >>>> >>>> >>> >>> >>> -- >>> With Regards >>> Vikas Srivastava >>> >>> DWH & Analytics Team >>> Mob:+91 9560885900 >>> One97 | Let's get talking ! >>> >>> >> >> >> -- >> Alok Kumar >> >> >> > > > -- > With Regards > Vikas Srivastava > > DWH & Analytics Team > Mob:+91 9560885900 > One97 | Let's get talking ! > > -- Alok Kumar -- Alok Kumar
