[
https://issues.apache.org/jira/browse/PHOENIX-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shuxiong Ye updated PHOENIX-2163:
---------------------------------
Attachment: calcite-test-mac.tar.gz
Hi [~jamestaylor], I update the code, and now it contains the explain time.
It shows the cost of explain is nearly 0.
Hi [~maryannxue], is there any special setting for calcite? When doing this
test, I use the default setting of Properties. When getting CalciteConnection,
and in order to get the right connection, according to the Calcite Integration
test, I get it as below:
{code}
final Connection connection =
DriverManager.getConnection("jdbc:phoenixcalcite:", new Properties());
final CalciteConnection calciteConnection =
connection.unwrap(CalciteConnection.class);
final String url = "jdbc:phoenix:localhost";
Map<String, Object> operand = Maps.newHashMap();
operand.put("url", url);
SchemaPlus rootSchema = calciteConnection.getRootSchema();
rootSchema.add("phoenix", PhoenixSchema.FACTORY.create(rootSchema,
"phoenix", operand));
calciteConnection.setSchema("phoenix");
{code}
> 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)
