impala-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nasron Cheong <nasron.che...@upsight.com>
Subject Re: Cloudera jdbc driver vs apache hive jdbc driver performance difference
Date Fri, 08 Sep 2017 14:30:22 GMT
Hi Jeszy,

The Hive driver appears faster - but it seems to be a static cost during
connection, but I need to confirm that.

Additionally, is there a way to easily tell from a jdbc query execution
which impala server was used, and/or what the query id is?

We do not have CM.

Thanks.

- Nasron

On Thu, Sep 7, 2017 at 4:48 PM, Jeszy <jeszyb@gmail.com> wrote:

> Hello,
>
> It's not possible unfortunately to get the profile directly through JDBC.
> Can you please clarify which driver is faster? I expect Cloudera's
> Impala (and not hive, that's untested) JDBC driver to be faster than
> the Apache Hive driver. Can you attach profiles for both runs? Even
> though you can't get them via JDBC, they are available through the web
> UI / CM (if you have that).
>
> Thanks!
>
> On 7 September 2017 at 22:43, Nasron Cheong <nasron.cheong@upsight.com>
> wrote:
> > Hi,
> >
> > I'm seeing a static several second performance difference between the
> hive
> > and cloudera jdbc drivers against our Impala installation.
> >
> > Are there settings that should be tuned on either the driver or the
> server
> > that would account for this?
> >
> > On a related question, is it possible to get PROFILE results from the
> > cloudera jdbc driver?
> >
> > Thanks.
>

Mime
View raw message