FAQ
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 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
emis intellectual technology
Fulford Grange, Micklefield Lane
Rawdon Leeds LS19 6BA
E-mail: stuart.scott@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

Search Discussions

  • Amlan Mandal at Feb 17, 2011 at 6:55 am
    $HIVE_HOME/lib/ will contain the jar hive-jdbc-0.6.0.jar


    On Thu, Feb 17, 2011 at 12:06 PM, Stuart Scott 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 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.scott@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





  • Amlan Mandal at Feb 17, 2011 at 6:56 am
    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 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 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.Scott@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.scott@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





Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedFeb 17, '11 at 6:36a
activeFeb 17, '11 at 6:56a
posts3
users2
websitehive.apache.org

2 users in discussion

Amlan Mandal: 2 posts Stuart Scott: 1 post

People

Translate

site design / logo © 2022 Grokbase