You can set classpath like this
export
CLASSPATH=$CLASSPATH:.:$HIVE_HOME/lib/*:$HADOOP_HOME/hadoop-0.20.2-core.jar
(if using java 6)
Amlan
On Thu, Feb 17, 2011 at 12:24 PM, Amlan Mandal <am...@fourint.com> wrote:
> $HIVE_HOME/lib/ will contain the jar hive-jdbc-0.6.0.jar
>
>
>
>
> On Thu, Feb 17, 2011 at 12:06 PM, Stuart Scott <stuart.sc...@e-mis.com>wrote:
>
>> Thanks for the reply.. (I’m new to Hive).
>>
>> I can’t find the driver class. Do you know which files I should be looking
>> for?
>>
>> Regards
>>
>> Stuart
>>
>>
>>
>> by the sound of the error ... it sounds like you don't have HiveDriver in
>> your path
>> Can you locate the calss that supposedly has the HiveDriver class?
>>
>> Cheers,
>> Ajo
>>
>> On Wed, Feb 16, 2011 at 2:03 PM, Stuart Scott <stuart.sc...@e-mis.com>
>> wrote:
>>
>> Hi,
>>
>>
>>
>> Does anyone know how to get a Windows client to Connect to Hive
>> successfully? I’ve tried the code below:
>>
>>
>>
>> Class.*forName*("org.apache.hadoop.hive.jdbc.HiveDriver");
>>
>> Connection con = DriverManager.*getConnection*("jdbc:hive://
>> 192.168.1.1:10000/default", "", "");
>>
>> Statement stmt = con.createStatement();
>>
>> stmt.executeQuery("select * from x");
>>
>>
>>
>>
>>
>> But get the following error:
>>
>>
>>
>> Exception in thread "main" *java.lang.ClassNotFoundException*:
>> org.apache.hadoop.hive.jdbc.HiveDriver
>>
>>
>>
>> Is it possible to do this?
>>
>> Any help would be really appreciated.
>>
>>
>>
>> Regards
>>
>>
>>
>> Stuart Scott
>>
>> System Architect
>> *em**i**s **intellectual technology *
>> Fulford Grange, Micklefield Lane
>> Rawdon Leeds LS19 6BA
>> E-mail: stuart.sc...@e-mis.com
>> Website: www.emisit.com
>>
>> Privileged and/or Confidential information may be contained in this
>> message. If you are not the original addressee indicated in this message (or
>> responsible for delivery of the message to such person), you may not copy or
>> deliver this message to anyone. In such case, please delete this message,
>> and notify us immediately. Opinions, conclusions and other information
>> expressed in this message are not given or endorsed by EMIS nor can I
>> conclude contracts on its behalf unless otherwise indicated by an authorised
>> representative independently of this message.
>>
>> EMIS reserves the right to monitor, intercept and (where appropriate) read
>> all incoming and outgoing communications. By replying to this message and
>> where necessary you are taken as being aware of and giving consent to such
>> monitoring, interception and reading.
>>
>>
>> EMIS is a trading name of Egton Medical Information Systems Limited.
>> Registered in England. No 2117205. Registered Office: Fulford Grange,
>> Micklefield Lane, Rawdon, Leeds, LS19 6BA
>>
>>
>>
>>
>>
>>
>>
>
>
