phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Young <>
Subject Re: Phoenix Query Server tenant_id
Date Tue, 21 Feb 2017 19:26:19 GMT
Hi Josh,

you are right, the TenantId property does get passed through when I run the
command by hand (see below).

Phoenix Version: phoenix-

org.apache.phoenix.queryserver.client.SqllineWrapper \
-d org.apache.phoenix.queryserver.client.Driver \
-u "jdbc:phoenix:thin:url=;serialization=PROTOBUF;TenantId=myTenant"
-n none -p none --color=true --fastConnect=false --verbose=true
--incremental=false --isolation=TRANSACTION_READ_COMMITTED

However, with Phoenix version (which comes with HDP
2.5), the python script doesn't pass any property along.   Here's the
obfuscated output when I connect to PQS:

[prompt]$ /usr/hdp/;TenantId=myTenant

Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect
jdbc:phoenix:thin:url=http://pqs1.mydomain:8765;serialization=PROTOBUF none
none org.apache.phoenix.queryserver.client.Driver
Connecting to jdbc:phoenix:thin:url=http://pqs1.mydomain:8765;serialization
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
SLF4J: Found binding in
SLF4J: See for an
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Connected to: Apache Phoenix (version unknown version)
Driver: Phoenix Remote JDBC Driver (version unknown version)
Autocommit status: true
Building list of tables and columns for tab-completion (set fastconnect to
true to skip)...
7603/7603 (100%) Done
sqlline version 1.1.8
0: jdbc:phoenix:thin:url=http://pqs1.mydomain> !list
1 active connection:
 #0  open     jdbc:phoenix:thin:url=http://pqs1.mydomain:8765;serialization

Is this something that has changed in newer versions of Phoenix?

On Mon, Feb 20, 2017 at 1:47 PM, Josh Elser <> wrote:

> See
> 8ecca8443077e7b7efa/avatica/core/src/main/java/org/apache/
> calcite/avatica/remote/
> This should be passed down just fine. If you can provide details as to how
> it isn't, that'd be great.
> Josh Elser wrote:
>> I thought arbitrary properties would be passed through, but I'm not sure
>> off the top of my head anymore....
>> Would have to dig through the Avatica JDBC driver to (re)figure this one
>> out.
>> Michael Young wrote:
>>> Is it possible to pass the TenantID attribute on the URL when using the
>>> phoenix query server? For example,
>>> /usr/hdp/
>>> This works fine for me when connecting via jdbc. Just didn't seem to
>>> work with the query server.
>>> Thanks,
>>> -Michael

View raw message