phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhilash L L <abhil...@capillarytech.com>
Subject Re: Connection params on phoenix
Date Wed, 18 Mar 2015 07:55:16 GMT
Thanks Gabriel.

We see if we can move to 3.3 from 3.0


Regards,
Abhilash L L
Capillary Technologies
M:919886208262
abhilash@capillarytech.com | www.capillarytech.com

On Wed, Mar 18, 2015 at 1:08 PM, Gabriel Reid <gabriel.reid@gmail.com>
wrote:

> You can't set auto-commit via the connection properties or JDBC url in
> version 3.0.0. However, this is possible (via the AutoCommit property) as
> of version 3.3 and 4.3.
>
> Other client-side properties can be set via the Properties object passed
> in to DriverManager.connect.
>
> - Gabriel
>
>
> On Wed, Mar 18, 2015 at 6:09 AM Abhilash L L <abhilash@capillarytech.com>
> wrote:
>
>> Yea, server side has to be on the site.xml.
>>
>> What about the client side ones?
>>
>> I tried checking usages of setAutoCommit() function in the phoenix
>> connection..  but couldnt find it properly..  For now calling it on the
>> connection directly but would be better if the driver/connections takes
>> care of it
>>
>> Also..  in the phoenix code found a constant for
>> phoenix.query.timeoutMs
>> but not for
>> phoenix.connection.autoCommit
>>
>> So, not sure if its supported. I can see that mutate batch size is being
>> read from the props in the constructor of phoenix connection though.
>>
>> * Interface to group together services needed during querying. The
>>
>> * parameters that may be set in {@link org.apache.hadoop.conf.Configuration}
>> * are documented here: https://github.com/forcedotcom/phoenix/wiki/Tuning
>>
>>
>> Found this on top of the org.apache.phoenix.query.QueryServices
>>
>> It says only hadoop conf is supported...
>>
>>
>>
>>
>>
>> Regards,
>> Abhilash L L
>> Capillary Technologies
>> M:919886208262
>> abhilash@capillarytech.com | www.capillarytech.com
>>
>> On Wed, Mar 18, 2015 at 6:43 AM, Fulin Sun <sunfl@certusnet.com.cn>
>> wrote:
>>
>>> Hi,
>>> Not sure about that. But if you want to check in for some server-side
>>> config, you may not want to
>>> pass those through JDBC props approach.
>>>
>>> Thanks,
>>> Sun.
>>>
>>> ------------------------------
>>> ------------------------------
>>>
>>> CertusNet
>>>
>>>
>>> *From:* Abhilash L L <abhilash@capillarytech.com>
>>> *Date:* 2015-03-17 20:09
>>> *To:* user <user@phoenix.apache.org>
>>> *Subject:* Connection params on phoenix
>>> Hello,
>>>
>>>    Is it possible to pass settings listed here
>>>
>>> http://phoenix.apache.org/tuning.html
>>>
>>>    on the jdbc connection and not have it on the hbase-site.xml?
>>>
>>>
>>> Using this API of the phoenix driver
>>>
>>> Connection phoenixConnection =
>>>  PhoenixDriver.INSTANCE.connect(getPhoenixJDBCUrl(), props);
>>>
>>> Are we missing anything ?
>>>
>>> We are using phoenix 3.0.0-incubating
>>>
>>>
>>> Regards,
>>> Abhilash L L
>>> Capillary Technologies
>>> M:919886208262
>>> abhilash@capillarytech.com | www.capillarytech.com
>>>
>>> Email from people at capillarytech.com may not represent official
>>> policy of Capillary Technologies unless explicitly stated. Please see our
>>> Corporate-Email-Policy for details.Contents of this email are confidential.
>>> Please contact the Sender if you have received this email in error.
>>>
>>>
>>
>> Email from people at capillarytech.com may not represent official policy
>> of Capillary Technologies unless explicitly stated. Please see our
>> Corporate-Email-Policy for details.Contents of this email are confidential.
>> Please contact the Sender if you have received this email in error.
>>
>

-- 
Email from people at capillarytech.com may not represent official policy of 
Capillary Technologies unless explicitly stated. Please see our 
Corporate-Email-Policy for details.Contents of this email are confidential. 
Please contact the Sender if you have received this email in error.

Mime
View raw message