You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Shuxiong Ye (JIRA)" <ji...@apache.org> on 2015/08/14 16:20:45 UTC

[jira] [Updated] (PHOENIX-2163) Measure performance of Phoenix/Calcite querying

     [ https://issues.apache.org/jira/browse/PHOENIX-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shuxiong Ye updated PHOENIX-2163:
---------------------------------
    Attachment: PHOENIX-2163.patch

Some test cases still fail to pass.

Some testcases which I comment out, need to implement. They are(see boolean switch in the end of SqlOperatorBaseTest):

1. TODO_CASE_RELATED_TEST_FINISHED. (Case and Case/Where)
2. TODO_ARRAY_VALUE_CONSTRUCTOR_TEST_FINISHED. (Select Array['foo', 'bar'])
3. TODO_CAST_DOUBLE_TO_INTEGER_TEST_FINISHED and TODO_COMPARE_BETWEEN_REAL_INTEGER_FINISHED seems to be bugs in CalciteUtils.



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