Some question about lattices

[JiaTao Tao <ta...@gmail.com>]

Hi, community

I was investigating lattice recently and encountered some problems:
1. Lattice requires the estimated number of rows of cuboids (tiles) for
optimization. I've found the method: `TileSuggester.StatisticsProviderImpl
# getRowCount`, `LatticeStatisticProvider # cardinality`, but I found that
they were not used finally, can anyone tell where the code I should dig.

2. Are there any designs on how to automatically recommend the lattice (how
to make the initial recommendation, how to adjust the existing lattices
based on the query frequency / existing lattice), I can not find them
included in JIRA or doc(https://calcite.apache.org/docs/lattice.html)

Looking forward to hearing from you.

-- 

Regards!

Aron Tao

Re: Some question about lattices

[Julian Hyde <jh...@apache.org>]

(Removing users@. This only needs to be on one list.)

Have you tried reading LatticeTest? You can see how APIs are used. 

I added QuerySqlStatisticProvider recently. Maybe QuerySqlStatisticProvider.SILENT_CACHING_INSTANCE meets your purposes.

Julian


> On Dec 29, 2019, at 11:03 PM, JiaTao Tao <ta...@gmail.com> wrote:
> 
> Hi, community
> 
> I was investigating lattice recently and encountered some problems:
> 1. Lattice requires the estimated number of rows of cuboids (tiles) for
> optimization. I've found the method: `TileSuggester.StatisticsProviderImpl
> # getRowCount`, `LatticeStatisticProvider # cardinality`, but I found that
> they were not used finally, can anyone tell where the code I should dig.
> 
> 2. Are there any designs on how to automatically recommend the lattice (how
> to make the initial recommendation, how to adjust the existing lattices
> based on the query frequency / existing lattice), I can not find them
> included in JIRA or doc(https://calcite.apache.org/docs/lattice.html)
> 
> Looking forward to hearing from you.
> 
> -- 
> 
> Regards!
> 
> Aron Tao