hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alok Kumar <alok...@gmail.com>
Subject Fwd: what changes required in hive conf xml when working with hive jdbc
Date Thu, 24 Nov 2011 13:48:45 GMT
---------- Forwarded message ----------
From: Alok Kumar <alokawi@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.srivastava@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.srivastava@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 <alokawi@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.srivastava@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 <
>>> dwivedishashwat@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 <alokawi@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

Mime
View raw message