[
https://issues.apache.org/jira/browse/PHOENIX-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14715185#comment-14715185
]
James Taylor commented on PHOENIX-2163:
---------------------------------------
Closer, [~shuxi0ng], but still not what we need. I think what we need is
simpler that what you've done. Instead of adding a new bar in the result chart,
we *only* want to run the EXPLAIN. We do not want to run the query.
For example, this isn't what we want to run:
{code}
select count(*) from AGGREGATION_TABLE
2.03s(0s) 4.5.0-CALCITE
2.03s WITHOUT EXPLAIN
1.57s 4.5.0-HBASE-1.1
{code}
Instead, this is:
{code}
EXPLAIN select count(*) from AGGREGATION_TABLE
{code}
We want to run this for both 4.5.0-CALCITE and 4.5.0-HBASE-1.1. If need be,
just tweak the phoenix grammar for your local build to use EXPLAIN PLAN FOR if
that's the syntax that works for Calcite.
Also, if you can change the units to milliseconds instead of seconds, that
might be easier to read since as you've noticed, the time will be very low for
only doing compilation.
> Measure performance of Phoenix/Calcite querying
> -----------------------------------------------
>
> Key: PHOENIX-2163
> URL: https://issues.apache.org/jira/browse/PHOENIX-2163
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: Shuxiong Ye
> Attachments: PHOENIX-2163.patch, calcite-test-mac.tar.gz
>
>
> The work to integrate Phoenix with Calcite has come along far enough that
> queries both against the data table and through a secondary index is
> functional. As a checkpoint, we should compare performance of as many queries
> as possible in our regression suite for the calcite branch against the latest
> Phoenix release (4.5.0). The runtime of these two systems should be the same,
> so this will give us an idea of the overhead of query parsing and compilation
> for Calcite. This is super important, as it'll identify outstanding work
> that'll be necessary to do prior to any releases on top of this new stack.
> Source code of regression suite is at
> https://github.com/mujtabachohan/PhoenixRegressor
> Connection string location:
> https://github.com/mujtabachohan/PhoenixRegressor/blob/master/src/main/resources/settings.json
> Instructions on how to compile and run:
> https://github.com/mujtabachohan/PhoenixRegressor/blob/master/README.md
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
