phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Wong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5231) Configurable Stats Cache
Date Sat, 25 May 2019 11:43:00 GMT

    [ 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)

Mime
View raw message