Re: [DISCUSS] New community section for articles/blogs/papers

2022-01-26 Thread Jing Zhang
Hi, Stamatis Thanks for driving this discussion. I would like to create a PR for the community content in the following days of this week. Best, Jing Zhang Stamatis Zampetakis 于2022年1月27日周四 06:12写道: > Many thanks to everyone for the feedback. > > I think the nature of the content fits slightly

Failed to import gradle

2022-01-26 Thread Aitozi
Hi community: I'm new to calcite community and gradle. When I followed the Howto.md to import the calcite project, It always failed with the following error. After some search in Google and calcite dev mail list, I stiil can't not figure it out. Is there anyone can help me out? thanks in advanc

Re: MaterializedViewRule is not applied for queries on aggregate views that truncate timestamp

2022-01-26 Thread Thomas D'Silva
Justin, Thanks for your response. If I change the query predicate to "floor(ts to minute) >= timestamp'2018-01-01 00:01:00' AND floor(ts to minute) < timestamp'2018-01-01 00:05:00'" it does end up querying the view. However I want to be able to query an arbitrary time range and have the union rewr

Re: [DISCUSS] New community section for articles/blogs/papers

2022-01-26 Thread Stamatis Zampetakis
Many thanks to everyone for the feedback. I think the nature of the content fits slightly better under the community section rather than docs that others mentioned so I would say to start by putting things there. People have mentioned "External resources", "Learning resources" and I am fine with a

MaterializedViewRule is not applied for queries on aggregate views that truncate timestamp

2022-01-26 Thread Thomas D'Silva
Hi, The existing MaterializedViewRule is not applied when the materialized view does not have a view predicate but the query contains a predicate. For eg for the following materialized view SELECT eventid, floor(ts to minute), count(*) as cnt FROM events GROUP BY eventid, floor(ts TO minut

Re: Apache Calcite - Usage of Querable table/Querable/RawQueryable/etc interfaces

2022-01-26 Thread Gavin Ray
Julian, sounds very interesting! > " I wonder whether we can remove the need to create those Foo-specific classes and rules. Could people just write a FooQuery relational expression that had a sequence of lightweight relational operations inside it?" What might something like this look like, out

Re: [REVIEW REQUEST]: Review Request for CALCITE-4987

2022-01-26 Thread Yanjing Wang
Hi community, This is a continuous review request for CALCITE-4987, I think it's helpful for generating valid ORDER BY clause on various engine, and federated queries will benefit from it, hence I'm honestly hoping this change will be merged soon. Yanjing Wang 于2022年1月18日周二 19:56写道: > Hi commun

Re: Apache Calcite - Usage of Querable table/Querable/RawQueryable/etc interfaces

2022-01-26 Thread Nicola Vitucci
Hi Julian, That would be excellent. It would help simplify the development quite a bit, and reduce repetition too. Do you already have any ideas on how to do it? Nicola Il mar 25 gen 2022, 20:33 Julian Hyde ha scritto: > This reminds me that there’s an opportunity to make it easier to write >