Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of arijit72@gmail.com designates
 209.85.216.204 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=WzdrKVGHo21WJyDlz2JJHp+WDdAdJ55DZg/iQWrz9+4SUmi1LsaLbOXhkAoSRvaiGH
         vGzFXAeMZIjCMkLp64n45Br53CCdiUW3MCqtUcPuIh/lfZM7sYX8Yp5ydxt0tVo+sQw4
         z+q8gKlsmE23GzDmjfvZ+tpNiMzogfo4BDeOQ=
MIME-Version: 1.0
In-Reply-To: <4cfc4d490910202135j406ff959n8a7ce06192024a2d@mail.gmail.com>
References: <4cfc4d490910200154i3b58415bsfdaf95af406fcb07@mail.gmail.com>
	 <4cfc4d490910200210p37f0df79lbfd3738ff6ed7165@mail.gmail.com>
	 <4cfc4d490910200414n5524e805s43eb849708e4cd25@mail.gmail.com>
	 <449b48760910200927w5cf423e6qe49d03a54b721d55@mail.gmail.com>
	 <4cfc4d490910202135j406ff959n8a7ce06192024a2d@mail.gmail.com>
Date: Wed, 21 Oct 2009 10:48:46 +0530
Message-ID: <4cfc4d490910202218i6c07e2eew437489d93419f239@mail.gmail.com>
Subject: Re: Hive query web service
From: Arijit Mukherjee <arijit72@gmail.com>
To: hive-user@hadoop.apache.org, billgraham@gmail.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Update: I did a clean/build/deploy - the config files are within the
Web Service WEB-INF/classes folder, and the libraries (including the
jpox ones) are inside WEB-INF/lib - which are standard for any web
application. But the config related exception is still there:-((

Arijit

2009/10/21 Arijit Mukherjee <arijit72@gmail.com>:
> Thanx Bill. I copied the jpox jars from the 0.3.0 distribution and
> added them to the web service archive, and they are in the classpath,
> but the config related exception is still there. Let me do a clean
> build/deploy and I'll get back again.
>
> Arijit
>
> 2009/10/20 Bill Graham <billgraham@gmail.com>:
>> The Hive JDBC client can run in two different modes: standalone and
>> embedded.
>>
>> Standalone mode is where the client connects to a separate standalone
>> HiveServer by specifying the host:port of the server in the jdbc URL lik=
e
>> this: jdbc:hive://localhost:10000/default. In this case the hive configs=
 are
>> not needed by the client, since the client is making thrift requests to =
the
>> server which has the Hive configs. the Hive Server knows how to resolve =
the
>> metastore.
>>
>> Embedded mode is where the JDBC client "connects to itself" so to speak
>> using a JDBC url like this: jdbc:hive://. It's as if the client is runni=
ng
>> an embedded server that only it communicates with. In this case the clie=
nt
>> needs the Hive configs since it needs to resolve the metastore, amongst
>> other things. The metastore dependency in this case is what will cause y=
ou
>> to see jpox errors appear if those jars aren't found.
>>
>> HTH,
>> Bill
>>
>> On Tue, Oct 20, 2009 at 4:14 AM, Arijit Mukherjee <arijit72@gmail.com>
>> wrote:
>>>
>>> BTW - the service is working though, in spite of those exceptions. I'm
>>> able to run queries and get results.
>>>
>>> Arijit
>>>
>>> 2009/10/20 Arijit Mukherjee <arijit72@gmail.com>:
>>> > I created a hive-site.xml using the outline given in the Hive Web
>>> > Interface tutorial - now that file is in the classpath of the Web
>>> > Service - and the service can find the file. But, now there's another
>>> > exception -
>>> >
>>> > 2009-10-20 14:27:30,914 DEBUG [httpSSLWorkerThread-14854-0]
>>> > HiveQueryService - connecting to Hive using URL:
>>> > jdbc:hive://localhost:10000/default
>>> > 2009-10-20 14:27:30,969 DEBUG [httpSSLWorkerThread-14854-0]
>>> > Configuration - java.io.IOException: config()
>>> > =A0 =A0 =A0 =A0at
>>> > org.apache.hadoop.conf.Configuration.<init>(Configuration.java:176)
>>> > =A0 =A0 =A0 =A0at
>>> > org.apache.hadoop.conf.Configuration.<init>(Configuration.java:164)
>>> > =A0 =A0 =A0 =A0at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveCon=
f.java:287)
>>> > =A0 =A0 =A0 =A0at
>>> > org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java=
:63)
>>> > =A0 =A0 =A0 =A0at
>>> > org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:109)
>>> > =A0 =A0 =A0 =A0at java.sql.DriverManager.getConnection(DriverManager.=
java:582)
>>> > =A0 =A0 =A0 =A0at java.sql.DriverManager.getConnection(DriverManager.=
java:185)
>>> > =A0 =A0 =A0 =A0at
>>> > com.ctva.poc.hive.service.HiveQueryService.getConnection(HiveQuerySer=
vice.java:134)
>>> > =A0 =A0 =A0 =A0at
>>> > com.ctva.poc.hive.service.HiveQueryService.connectDB(HiveQueryService=
.java:43)
>>> >
>>> > Apparently, something goes wrong during the config routine. Do I need
>>> > something more within the service?
>>> >
>>> > Regards
>>> > Arijit
>>> >
>>> > 2009/10/20 Arijit Mukherjee <arijit72@gmail.com>:
>>> >> Hi
>>> >>
>>> >> I'm trying to create a Web Service which will access Hive (0.4.0
>>> >> release) using JDBC. I used to sample JDBC code from the wiki
>>> >>
>>> >> (http://wiki.apache.org/hadoop/Hive/HiveClient#head-fd2d8ae9e17fdc3d=
9b7048d088b2c23a53a6857d),
>>> >> but when I'm trying to connect the the DB using the DriverManager,
>>> >> there's an exception which seems to relate to hive-site.xml (HiveCon=
f
>>> >> - hive-site.xml not found.). But I could not find any hive-site.xml =
in
>>> >> $HIVE_HOME/conf - there's only hive-default.xml. The wiki page also
>>> >> speaks about couple of jpox JAR files, which aren't in the lib folde=
r
>>> >> either.
>>> >>
>>> >> Am I missing something here?
>>> >>
>>> >> Regards
>>> >> Arijit
>>> >>
>>> >> --
>>> >> "And when the night is cloudy,
>>> >> There is still a light that shines on me,
>>> >> Shine on until tomorrow, let it be."
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> > "And when the night is cloudy,
>>> > There is still a light that shines on me,
>>> > Shine on until tomorrow, let it be."
>>> >
>>>
>>>
>>>
>>> --
>>> "And when the night is cloudy,
>>> There is still a light that shines on me,
>>> Shine on until tomorrow, let it be."
>>
>>
>
>
>
> --
> "And when the night is cloudy,
> There is still a light that shines on me,
> Shine on until tomorrow, let it be."
>


--=20
"And when the night is cloudy,
There is still a light that shines on me,
Shine on until tomorrow, let it be."