Thanks, Vladimir ~ Yes, Calcite does not support hints now but we start working out a framework to let user customize the content of their hints implementation. I have written a design doc[2] and fire a PR[3].
We did have a long discussion about the design, and I think we can merge the code soon. Let me know If this syntax of framework satisfy your needs, thanks ~ [1] https://issues.apache.org/jira/browse/CALCITE-482 [2] https://docs.google.com/document/d/1mykz-w2t1Yw7CH6NjUWpWqCAf_6YNKxSc59gXafrNCs/edit?usp=sharing [3] https://github.com/apache/calcite/pull/1354 Best, Danny Chan 在 2019年10月28日 +0800 PM5:09，Vladimir Ozerov <[email protected]>，写道： > Hi colleagues, > > I am working on Calcite integration with Hazelcast. One particular problem > is that we need query hints. I found a couple of tickets [1] [2], and it > seems that hints are not readily available at the moment. So I have two > questions: > 1) Is it true that there is no built-in way to provide query hints at the > moment? Are there any plans to finally add hints to the engine? > 2) As a possible solution, I am considering extending SELECT syntax with a > custom parser extension. Do you know any example of extended SELECT syntax > in existing Calcite integrations? I found an example of SqlInsert command > extension in Apache Flink, but maybe somebody already extended SELECT as > well? > > Thank you, > Vladimir. > > [1] https://issues.apache.org/jira/browse/CALCITE-482 > [2] https://issues.apache.org/jira/browse/CALCITE-495
