Re: Parsing multiple SQL statements using Calcite

2022-01-27 Thread Laksh Singla
Thanks Julian for clearing up the doubt. Regards Laksh On Sat, Jan 22, 2022 at 12:48 AM Julian Hyde wrote: > You are right. We support parsing multiple statements [1] but we don’t > support multi-statement validation, multi-statement planning or > multi-statement execution. > > Julian > > >

Re: How to handle the fact that different databases have different ideas of what a "db"/"schema" are?

2022-01-27 Thread Gavin Ray
The filesystem hierarchy is a great analogy, I understand it much better now I think -- thank you. This seems like a problem with potentially very brittle solutions. Using your explanation I was able to get it to work, with very terrible logic that says "If catalogs are all null, then it's

Re: Failed to import gradle

2022-01-27 Thread Julian Hyde
Can someone log a bug for this? I don’t run into it personally. (I just click open on the directory. I never invoke ‘import gradle’.) But people shouldn’t have to edit their Gradle files. > On Jan 27, 2022, at 6:55 AM, Gavin Ray wrote: > > It didn't work for me either. > > I had to remove

Re: How to handle the fact that different databases have different ideas of what a "db"/"schema" are?

2022-01-27 Thread Julian Hyde
Let’s not worry about the names, and say that some DBs have two namespace levels and others have just one. Calcite’s word for a namespace is ’schema’. Calcite schemas are arranged in a hierarchy, like a filesystem, so there is no preferred depth. Any schema can contain both tables and

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

2022-01-27 Thread Thomas D'Silva
Stamatis, For the materialized view and query that I had mentioned in the earlier email, I got the following final plan that used the table : EnumerableCalc(expr#0..2=[{inputs}], EXPR$0=[$t1], EXPR$1=[$t2]) EnumerableAggregate(group=[{0, 1}], EXPR$1=[COUNT()])

How to handle the fact that different databases have different ideas of what a "db"/"schema" are?

2022-01-27 Thread Gavin Ray
My RDBMS experience is nearly exclusively Postgres While working on this project, I've made the assumption that the structure of a database is: Database -> Schema -> Table It turns out that this isn't accurate. In MySQL for instance, "Schema" is an alias for "DB". >From the below StackOverflow

Re: Failed to import gradle

2022-01-27 Thread Gavin Ray
It didn't work for me either. I had to remove some of the Gradle tasks, related to checks IIRC. What I did that made it work was: 1. Modify "gradle.properties" in the root of the repo, adding the following line: skipAutostyle=true 2. Modify every instance of "val skipAutostyle by

Re: [ANNOUNCE] New Calcite PMC chair: Ruben Q L

2022-01-27 Thread Fan Liya
Congratulations, Ruben! Haisheng, thanks for your great work! Best, Liya Fan Jing Zhang 于2022年1月24日周一 11:30写道: > Congrats Ruben! > Haisheng, thanks a lot for serving as a chair! > > > Enrico Olivelli 于2022年1月23日周日 05:17写道: > > > Congrats! > > > > Enrico > > > > Il Sab 22 Gen 2022, 03:03

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

2022-01-27 Thread Stamatis Zampetakis
Hey Thomas, Can you post the plan/query that you were expecting after the rewriting? Is the behavior you observed specific to timestamps? Best, Stamatis On Thu, Jan 27, 2022 at 4:07 AM Thomas D'Silva wrote: > Justin, > > Thanks for your response. If I change the query predicate to "floor(ts

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

2022-01-27 Thread Jing Zhang
Hi, Stamatis I have created a PR [1] to add a new section in the community page, welcome to review. [1] https://github.com/apache/calcite/pull/2703 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

Re: Failed to import gradle

2022-01-27 Thread Thomas Rebele
Hello, the Calcite mailing list removes pictures. Could you please post the error message in text form? Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Thu, Jan 27, 2022 at 7:38 AM Aitozi wrote: > Hi community: > I'm new to calcite community