calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Is there a list of valid properties for avatica's OpenConnectionRequest info map?
Date Tue, 12 Apr 2016 07:03:38 GMT
Glad you've got things working. FYI, you can also control the default of
auto commit across all connections through
the phoenix.connection.autoCommit property in your client-side
hbase-site.xml file.

    James

On Mon, Apr 11, 2016 at 11:37 PM, F21 <f21.groups@gmail.com> wrote:

> Thanks, James! That was very helpful.
>
> For those interested, the PhoenixRuntime.java file is here:
> https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/util/PhoenixRuntime.java
>
> In my case, I used (JSON equivalent):
>
> {
>     "AutoCommit":  "true",
>     "Consistency": "8",
>
> }
>
>
>
> On 12/04/2016 4:29 PM, James Taylor wrote:
>
>> This map corresponds to the properties in the
>> DriverManager.getConnection()
>> call [1]. The possible values are dependent on the particular driver with
>> which you're interacting. For Phoenix, these can be HBase connection
>> property/values (if a connection being opened needs to have different
>> values than the default configuration), or in support of other features
>> such as multi-tenancy (TenantId), the max time stamp for flashback queries
>> (CurrentSCN), and a few other not too well documented options (see
>> PhoenixRuntime.java).
>>
>> Thanks,
>> James
>>
>>
>> [1]
>>
>> https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html#getConnection(java.lang.String,%20java.util.Properties)
>>
>> On Mon, Apr 11, 2016 at 10:46 PM, F21 <f21.groups@gmail.com> wrote:
>>
>> The protobuf documentation for avatica says we can send a map along with
>>> the connection id when using an OpenConnectionRequest:
>>>
>>> https://calcite.apache.org/docs/avatica_protobuf_reference.html#openconnectionrequest
>>>
>>> Is there a list of keys that can go into the map? Perhaps this should be
>>> better documented.
>>>
>>> I tried sending a map (shown in JSON, but I was sending the golang
>>> protobuf equivalent):
>>> {
>>>      "auto_commit":           "true",
>>>      "has_auto_commit":       "true",
>>>      "transaction_isolation": "8",
>>> }
>>>
>>> However, the connection was not opened with auto_commit set to true.
>>>
>>>
>>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message