Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of
 manish.malhotra.work@gmail.com designates 74.125.82.54 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1352882430.34440.YahooMailNeo@web193001.mail.sg3.yahoo.com>
References: <COL002-W113DA8F0AC180CAC106B833A1640@phx.gbl>
	<1352882430.34440.YahooMailNeo@web193001.mail.sg3.yahoo.com>
Date: Thu, 15 Nov 2012 02:45:52 -0800
Message-ID: 
 <CAJ0+5HYG5nyDz6=DWJvmcv60hq995MDJf2Wfx9uKUc8zY7vMnA@mail.gmail.com>
Subject: Re: Jaspersoft reports over Hive
From: Manish Malhotra <manish.malhotra.work@gmail.com>
To: user@hive.apache.org, BALAKRISHNAN VISWANATHAN <vbala81@yahoo.co.in>
Content-Type: multipart/alternative; boundary=0016e6de0053e46a0b04ce865ae2

--0016e6de0053e46a0b04ce865ae2
Content-Type: text/plain; charset=ISO-8859-1

Hi,

As per my understanding, the JDBC driver for hive is not scalable, it's a
single threaded model.
Though even if you get handle of Data Access API, the latency to generate
report would be high !!
If you are ok with that , then please checkout the Thrift API and CLI
Driver class code:

http://hive.apache.org/docs/r0.7.1/api/org/apache/hadoop/hive/cli/CliDriver.html
( this is bit older version link)

Most probably you need to build a server in between your client and HIVE
MetaStore.

Please this is my understanding, guys please correct me if I missed out
something.

Regards,
Manish


On Wed, Nov 14, 2012 at 12:40 AM, BALAKRISHNAN VISWANATHAN <
vbala81@yahoo.co.in> wrote:

> Hi,
> We are trying to run "Adhoc queries" from Jaspersoft by connecting to
> Hive. Can you please help us on running Adhoc queries over Datasources? I
> tried checking the user manual, but didn't get much of an idea on that.
>
> Any help is highly appreciated
> Thanks, Bala
>

--0016e6de0053e46a0b04ce865ae2
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<br><br>As per my understanding, the JDBC driver for hive is not scalabl=
e, it&#39;s a single threaded model. <br>Though even if you get handle of D=
ata Access API, the latency to generate report would be high !! <br>If you =
are ok with that , then please checkout the Thrift API and CLI Driver class=
 code: <br>
<br><a href=3D"http://hive.apache.org/docs/r0.7.1/api/org/apache/hadoop/hiv=
e/cli/CliDriver.html">http://hive.apache.org/docs/r0.7.1/api/org/apache/had=
oop/hive/cli/CliDriver.html</a>=A0 ( this is bit older version link) <br><b=
r>
Most probably you need to build a server in between your client and HIVE Me=
taStore. <br><br>Please this is my understanding, guys please correct me if=
 I missed out something. <br><br>Regards,<br>Manish<br><div class=3D"gmail_=
extra">
<br><br><div class=3D"gmail_quote">On Wed, Nov 14, 2012 at 12:40 AM, BALAKR=
ISHNAN VISWANATHAN <span dir=3D"ltr">&lt;<a href=3D"mailto:vbala81@yahoo.co=
.in" target=3D"_blank">vbala81@yahoo.co.in</a>&gt;</span> wrote:<br><blockq=
uote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc =
solid;padding-left:1ex">
<div><div style=3D"font-size:10pt;font-family:Courier New,courier,monaco,mo=
nospace,sans-serif"><div>Hi,</div><div>We are trying to run &quot;Adhoc que=
ries&quot; from Jaspersoft by connecting to Hive. Can you please help us on=
 running Adhoc queries over Datasources? I tried checking the user manual, =
but didn&#39;t get much of an idea on that.</div>
<div><br></div><div style=3D"font-style:normal;font-size:13px;background-co=
lor:transparent;font-family:&#39;Courier New&#39;,courier,monaco,monospace,=
sans-serif">Any help is highly appreciated</div><div style=3D"font-style:no=
rmal;font-size:13px;background-color:transparent;font-family:&#39;Courier N=
ew&#39;,courier,monaco,monospace,sans-serif">
Thanks, Bala</div>  </div></div></blockquote></div><br></div>

--0016e6de0053e46a0b04ce865ae2--