Hello community:
I am stuck an optimizer error while working on Calcite-3272. I am less
familiar with Calcite's optimizer and struggled to debug the following
error message. Is there some hints on what direction I should go? I can
also provide more information if that is helpful.
> java.sql.SQLException: Error while executing SQL "select * FROM
TABLE(TUMBLE(TABLE ORDERS, 'ROWTIME', INTERVAL '1' MINUTE))": There are not
enough rules to produce a node with desired properties:
convention=ENUMERABLE, sort=[]. All the inputs have relevant nodes, however
the cost is still infinite.
> Root: rel#26:Subset#2.ENUMERABLE.[]
> Original rel:
> LogicalProject(ROWTIME=[$0], ID=[$1], PRODUCT=[$2], UNITS=[$3],
wstart=[$4], wend=[$5]): rowcount = 100.0, cumulative cost =
{1.7976931348623157E308 rows, 1.7976931348623157E308 cpu,
1.7976931348623157E308 io}, id = 12
> LogicalTableFunctionScan(invocation=[TUMBLE($3, 'ROWTIME',
60000:INTERVAL MINUTE)], rowType=[RecordType(TIMESTAMP(0) ROWTIME, INTEGER
ID, VARCHAR(10) PRODUCT, INTEGER UNITS, TIMESTAMP(0) wstart, TIMESTAMP(0)
wend)]): rowcount = 100.0, cumulative cost = {1.7976931348623157E308 rows,
1.7976931348623157E308 cpu, 1.7976931348623157E308 io}, id = 10
> LogicalProject(ROWTIME=[$0], ID=[$1], PRODUCT=[$2], UNITS=[$3]):
rowcount = 100.0, cumulative cost = {200.0 rows, 501.0 cpu, 0.0 io}, id = 8
> LogicalTableScan(table=[[ORINOCO, ORDERS]]): rowcount = 100.0,
cumulative cost = {100.0 rows, 101.0 cpu, 0.0 io}, id = 2
-Rui
