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 18:22:46 GMT
Tried that, no difference. I think for now we'll stick to the hive jdbc
driver.

- Nasron

On Fri, Sep 8, 2017 at 12:09 PM, Alexander Behm <alex.behm@cloudera.com>
wrote:

> Try setting useNativeQuery=1 in the Cloudera JDBC driver, i.e. connect
> with something like this:
>
> jdbc:impala://impaladhost:21050/mydatabase;UseNativeQuery=1;
>
> Not sure if it's possible to get the query profile through JDBC, maybe
> someone else can chime in.
>
> On Fri, Sep 8, 2017 at 7:30 AM, Nasron Cheong <nasron.cheong@upsight.com>
> wrote:
>
>> 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