calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vladimir Sitnikov <sitnikov.vladi...@gmail.com>
Subject Re: Unclear hard-coding in planner and other parts of source code
Date Fri, 24 Jul 2015 20:56:43 GMT
Costing model indeed begs improvements.
However, to improve it some real-life cases are required.

It happens so that even current formulas work (Julian-only-knows-how)
for current unittest/etc cases.

This is not completely new topic, no-one just came up with test cases and fixes.

>To set cost I overrode computeSelfCost method where cpu cost and io cost
was multiplied by length of row. But it didn't help.

Your next battle would probably be "costing of computation pushdown".
In other words, costing of computations in java vs costing of the same
operations performed in your storage.
I've noticed that Calcite prefers "to just full scan the data sources"
and join/aggregate in java, however your mileage may vary.

Vladimir

Mime
View raw message