how to hint cardinality of JdbcTable

2022-01-08 Thread Константин Новиков
Hi,   I’m providing some cardinality estimates for JDBC tables. From the API, I can easily implement a metadata handler for RowCount. But I’m encountering the following exception:   RelSubset [rel#32:RelSubset#0.ENUMERABLE] has wrong best cost {5.90709E8 rows, 5.90719E8 cpu, 0.0 io}.

how to represent and optimize a query over partitioned storage

2021-12-10 Thread Константин Новиков
Hi,   Given some partitioned storage, we can omit the scan of some partitions when a filter is present. How can the lower cost of the scan be represented? As far as I can tell the current approach only allows providing a single cost for the TableScan and Filter can only add to that. Should my

Types.NULL not handled in AbstractCursor

2021-06-08 Thread Константин Новиков
Hi,   Is there any explanation for missing handling of Types.NULL in AbstractCursor.createAccessor()? I have a query which includes NULL in the projection (eg, select 1 as x, NULL, ...) and this is causing an exception. Thanks.