[
https://issues.apache.org/jira/browse/PHOENIX-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14662293#comment-14662293
]
Maryann Xue commented on PHOENIX-2163:
--------------------------------------
[~shuxi0ng] I made a check-in that implemented POWER and SQRT in CalciteUtils.
The related tests in ExpressionFactoryValuesTest all pass now.
Some of the scalar functions like "FLOOR" have their own SqlKind, so you can
implement them the same way as we do EQUAL, PLUS, etc. Other scalar functions,
like POWER, SQRT or ABS, all have the same SqlKind: OTHER_FUNCTION, so instead
you check their SqlOperator. You can find a complete list of all Sql operators
or say functions in
"calcite-core/src/main/java/org/apache/calcite/sql/fun/SqlStdOperatorTable.java".
> 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
>
> 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)
