phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <gabriel.r...@gmail.com>
Subject Re: Connection params on phoenix
Date Wed, 18 Mar 2015 07:38:28 GMT
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.
>

Mime
View raw message