[
https://issues.apache.org/jira/browse/PHOENIX-5231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16848163#comment-16848163
]
Daniel Wong commented on PHOENIX-5231:
--------------------------------------
[~lhofhansl] I am not able to recreate your issue with SQLLine. Can you give
me some more information? What is your output of jar tf on your client jar?
This was my output following mvn package.
{code:java}
dev@OnePageGamesDevBox:~/dev/phoenix$ jar tf
./phoenix-client/target/phoenix-client-5.1.0-HBase-2.0-SNAPSHOT.jar | grep
"GuidePostsCacheFactory"
org/apache/phoenix/query/ITGuidePostsCacheFactory.class
org/apache/phoenix/query/GuidePostsCacheFactory.class
org/apache/phoenix/query/DefaultGuidePostsCacheFactory.class
META-INF/services/org.apache.phoenix.query.GuidePostsCacheFactory
META-INF/services/META-INF/services/org.apache.phoenix.query.GuidePostsCacheFactory
{code}
After starting up the sandbox minicluster i was able to connect with SQLLine.
{code:java}
dev@OnePageGamesDevBox:~/dev/phoenix$ bin/sqlline.py localhost:56453
Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost:56453 none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost:56453
19/05/25 04:41:18 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
Connected to: Phoenix (version 5.1)
Driver: PhoenixEmbeddedDriver (version 5.1)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true
to skip)...
154/154 (100%) Done
Done
sqlline version 1.7.0
0: jdbc:phoenix:localhost:56453> select * from system.catalog limit 1;
+-----------+-------------+------------+-------------+---------------+---------------+------------+---------+--------------+--+
| TENANT_ID | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | COLUMN_FAMILY |
TABLE_SEQ_NUM | TABLE_TYPE | PK_NAME | COLUMN_COUNT | |
+-----------+-------------+------------+-------------+---------------+---------------+------------+---------+--------------+--+
| | SYSTEM | CATALOG | | | 0
| s | PK | 64 | |
+-----------+-------------+------------+-------------+---------------+---------------+------------+---------+--------------+--+
{code}
I which branch or phoenix build were you having issue with?
> Configurable Stats Cache
> ------------------------
>
> Key: PHOENIX-5231
> URL: https://issues.apache.org/jira/browse/PHOENIX-5231
> Project: Phoenix
> Issue Type: Test
> Reporter: Daniel Wong
> Assignee: Daniel Wong
> Priority: Major
> Fix For: 4.15.0, 5.1.0
>
> Attachments: 5231-quickfix-v2.txt, 5231-quickfix.txt,
> PHOENIX-5231.4.x-HBase-1.3.patch, PHOENIX-5231.4.x-HBase-1.3.v2.patch,
> PHOENIX-5231.4.x-HBase-1.3.v3.patch, PHOENIX-5231.master.v3.patch,
> PHOENIX-5231.master.v4.patch
>
> Time Spent: 8h 40m
> Remaining Estimate: 0h
>
> Currently, the phoenix stats cache is per
> ConnectionQuerySerivce/ConnectionProfile, which leads to duplicated cached
> entry (the guideposts) and waste resources if these separate connections are
> querying the same underlying table. It would be good to be able to provide a
> configurable stats cache as control the cache level so it could be per JVM.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
