Build failed in Jenkins: Calcite » Calcite-snapshots #57

See Changes: [Stamatis Zampetakis] Site: Add external resources section in the community page -- [...truncated 357.69 KB...]  15.4sec,

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

Xurenhe, Thank you for the detailed response and pointers. The use case you describe for OLAP streaming queries is similar to what our team is trying to accomplish. We use calcite to query data stored in kudu [1]. We use kafka streams to maintain materialized views that contain pre-aggregated

Re: Calcite can't generate code for one of the query

I guess you’re using ReflectiveSchema. I don’t think we support columns of (Java) type Character or char. You should convert relkind to a String and I think things will be better. > On Jan 28, 2022, at 4:44 AM, Dmitry Sysolyatin > wrote: > > I found a way how to make the query work. But I

Re: Calcite can't generate code for one of the query

I found a way how to make the query work. But I don't understand the reason: If `relkind` is JavaType(char) (primitive type) then the query does not work If `relkind` is JavaType(java.lang.Character) then the query works. On Fri, Jan 28, 2022 at 12:59 PM Dmitry Sysolyatin wrote: > Hi! > > I am

Calcite can't generate code for one of the query

Hi! I am implementing a wrapper over calcite in order to use it like Postgres server. But I have a problem with one of a query that Postgres driver sends to the server. The query: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR

Re: [DISCUSS] Apache Calcite Online Meetup January 2022

Hi Stamatis, I created a PR https://github.com/apache/calcite/pull/2704 . Thanks for the guidance. Regards, -- Eugen Stan +40770 941 271 / https://www.netdava.combegin:vcard fn:Eugen Stan n:Stan;Eugen email;internet:eugen.s...@netdava.com tel;cell:+40720898747 x-mozilla-html:FALSE

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

It’s useful in OLAP. Time ’s prediction bottom `Aggregate` could be pulled-up, because of Time’s granularity in Aggregate’s group. By the way, the query can be rewritten by mv, when the query's granularity is coarser than mv’s. eg: -- mv: SELECT eventid, floor(ts TO minute), count(*) as cnt

Re: Questions With Materialized Views

Hi luchen.xu SubstitutionVisitor: based on pattern, and bottom-up visit. MaterializedViewRule: analyze semantics with relnode, such as SPJA I have focused on the way of SubstitutionVisitor, let me talk about the advantages and disadvantages: Advantages: 1. Expand easily: you can define a custom