Convert sqlnode to relRoot cost 14s

2020-12-06 Thread 过 冰峰 
Dear calcite developer community：

   I am a user of Apache Calcitite，Recently I discovered that it took 
nearly 14 seconds for a simple query to convert sqlnode to relRoot. The reason 
was that my query contained about 100 unions. Then I added a relnode cache in 
it, and cost time reduced to 300ms. level. Can I open an issue to contribute 
this cache back to calcite to deal with poor performance when there are many 
unions.


thanks

Re: [CALCITE-3589]

2019-12-12 Thread 过 冰峰 
Thank you so much, I am very excited now, thank the apache calcite community

在 2019/12/12 下午7:30，“Francis Chuang” 写入:

Hey,

I've added you as a contributor to the project and assigned you to the 
issue. Please go ahead and open a PR on Github for review.

Francis

On 12/12/2019 9:43 pm, 过 冰峰 wrote:
> Dear calcite developer community：
> 
> https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-3589. I am 
a member of Apache Kylin and a user of Apache Calcitite，This issue was 
mentioned by me, can i fix it by myself。
> 
> thanks
>

[CALCITE-3589]

2019-12-12 Thread 过 冰峰 
Dear calcite developer community：

https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-3589. I am a 
member of Apache Kylin and a user of Apache Calcitite，This issue was mentioned 
by me, can i fix it by myself。

thanks