[KYLIN-5452] Constant query performance optimization

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0-alpha
• Fix Version/s: 5.0-alpha
• Component/s: Query Engine
• Assignee: Ruixuan Zhang
• Reporter: Ruixuan Zhang
• Created: 16/Feb/23 09:39
• Updated: 27/Feb/23 08:46
• Resolved: 27/Feb/23 08:46

Description

Design

Optimize org.apache.calcite.adapter.enumerable.EnumerableInterpretable#getBindable with cache.

Cherry-pick from https://github.com/apache/calcite/pull/950, Calcite 1.19 uses Guava cache on Bindable instances.

Similar to calcite.bindable.cache.maxSize and calcite.bindable.cache.concurrencyLevel, two KYLIN configs are added as follows:

 

# Cache max size, default value is 10
kylin.query.calcite.bindable.cache.maxSize
# controll the concurrency level of cache, default value is 5
kylin.query.calcite.bindable.cache.concurrencyLevel