Re: Draft board report for October 2018

2018-10-01 Thread Michael Mior
Good catch! That's definitely what I intended to say. Will fix. -- Michael Mior mm...@apache.org Le lun. 1 oct. 2018 à 18:06, Francis Chuang a écrit : > Hey Michael, > > Thanks for preparing the board report, it looks great! For Avatica Go, > 3.1.0 was released in early Se

Re: Calcite Streaming and Mongo

2018-10-03 Thread Michael Mior
eams and tables. -- Michael Mior mm...@apache.org Le mar. 2 oct. 2018 à 20:43, Andrei Sereda a écrit : > Hello, > > Since version 3.6 mongo introduced collection change streams > <https://docs.mongodb.com/v3.6/changeStreams/> which allow to observe > real-time chan

Re: Generic Map type (_MAP) and select star (*)

2018-10-04 Thread Michael Mior
/apache/calcite/blob/c39bfaa02a06ac91575076a6e74f29863923f5eb/elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/ElasticsearchProject.java#L67 -- Michael Mior mm...@apache.org Le jeu. 4 oct. 2018 à 14:47, Andrei Sereda a écrit : > Hello, > > I would like to understand how exactly generic map ty

Re: Calcite IN operator handling

2018-10-10 Thread Michael Mior
You should be able to work around this by setting inSubQueryThreshold to Integer.MAX_VALUE.. -- Michael Mior mm...@apache.org Le mer. 10 oct. 2018 à 10:04, Mykola Zerniuk a écrit : > Hello calcite devs! > My name is Mykola, a am software engineer. We actively use calcite > framewo

Re: Exception-handling in built-in functions

2018-10-17 Thread Michael Mior
a contributor is burned out or interpersonal conflicts get heated. -- Michael Mior mm...@apache.org Le mer. 17 oct. 2018 à 14:58, Julian Hyde a écrit : > Vladimir, > > You’ve made your points. And I hear them. > > However I get the impression that you are not open to persuasion. Which >

Re: [DISCUSS] Where do we draw the line?

2018-10-18 Thread Michael Mior
ments intended to be humorous how they will be perceived. -- Michael Mior mm...@apache.org Le jeu. 18 oct. 2018 à 15:37, Julian Hyde a écrit : > I’m not too concerned about the "Do you aim to get an entry in > accidentallyquadratic?” comment — it could be interpreted humorously, if i

Re: [DISCUSS] Towards Calcite 1.18

2018-10-21 Thread Michael Mior
Thanks for continuing to push releases forward! Unfortunately I won't be able to volunteer to be release manager this time around, but I'll try to set aside some time to go through some PRs. On Sat, Oct 20, 2018, 02:21 Julian Hyde wrote: > OK, it's now exactly 3 months since 1.17. I think it's t

Re: Access SELECT and WHERE Clause column names in SQL Query

2018-10-30 Thread Michael Mior
What have you tried? You should be able to build a SqlParser and call the parseQuery method. With the resulting SqlNode, you may want to try implementing the SqlVisitor interface to get the data you need. -- Michael Mior mm...@apache.org Le mar. 30 oct. 2018 à 02:02, Shashwat Kumar a écrit

Re: Looking for help on query optimization statistics

2018-11-05 Thread Michael Mior
Just providing an immutable link for posterity. (You can get one by pressing y on most GitHub pages.) https://github.com/apache/drill/blob/56c8f0a7f97c3796ba90976fdbb6d90c5f2229a5/exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/DefaultSqlHandler.java#L405 -- Michael Mior

[DISCUSS] State of the project 2018

2018-11-05 Thread Michael Mior
: 1) What else are we doing well in the project? 2) What areas do we need to do better? Please take some time to share your thoughts! -- Michael Mior mm...@apache.org

Re: [DISCUSS] Towards Calcite 1.18

2018-11-06 Thread Michael Mior
release manager for Avatica if no one else is > interested. > > On 21/10/2018 6:13 PM, Michael Mior wrote: > > Thanks for continuing to push releases forward! Unfortunately I won't be > > able to volunteer to be release manager this time around, but I'll try to >

CockroachDB optimizer

2018-11-08 Thread Michael Mior
The folks from Cockroch Labs just shared an interesting blog post on the development of their optimizer. Could be some interesting lessons in their code base. https://www.cockroachlabs.com/blog/building-cost-based-sql-optimizer/ -- Michael Mior mm...@apache.org

Re: CockroachDB optimizer

2018-11-09 Thread Michael Mior
They're not using Calcite. Their code base is in Go and they wrote their own in Go. If you read the blog post, they describe a DSL they built for expressing optimizer rules which is kind of nice although not terribly different from what we're doing with Calcite. -- Michael Mior mm...@

Re: JSON support

2018-11-09 Thread Michael Mior
Just wanted to put out a thanks to Hongze on this thread for the numerous changes that went into the initial pull request which has now landed! Happy to see this completed. -- Michael Mior mm...@apache.org Le mer. 29 août 2018 à 16:11, Julian Hyde a écrit : > Somehow I missed this… we hav

Re: CockroachDB optimizer

2018-11-09 Thread Michael Mior
All fair points. Thanks for the insight :) -- Michael Mior mm...@uwaterloo.ca Le ven. 9 nov. 2018 à 14:03, Julian Hyde a écrit : > I’m not very impressed with this work. A DSL for query transformation > rules has been tried in the past - all the way back to EXODUS[1] - but > there ar

Re: Calcite traces visual analyzer application

2018-11-11 Thread Michael Mior
Very cool! Thanks for sharing :) On Sun, Nov 11, 2018, 07:43 Anton Haidai Hello, > here is a small utility that gives an ability to view a visual > representation of Calcite traces: Rels, Subsets, Sets, so it is possible to > explore not only the best plan, but also dead end options generated by

Re: Avoid SqlParser.toSqlString() adding double quotes to select identifiers

2018-11-11 Thread Michael Mior
Have you tried using MysqlSqlDialect instead? On Sun, Nov 11, 2018, 09:21 Shashwat Kumar I am trying to modify a SQL statement using SQL Parser and implementing > SQLVisitor interface to modify select column variables. > However after modification when I am trying to convert back to sql > stateme

Potential student projects

2018-11-12 Thread Michael Mior
never seen Calcite before. https://issues.apache.org/jira/browse/CALCITE-481 https://issues.apache.org/jira/browse/CALCITE-1440 https://issues.apache.org/jira/browse/CALCITE-1737 https://issues.apache.org/jira/browse/CALCITE-1861 https://issues.apache.org/jira/browse/CALCITE-2141 -- Michael Mior mm...@apache.org

Re: count(distinct col) can't recognize distinct

2018-11-13 Thread Michael Mior
Can you give a specific example of a query that doesn't do what you expect it to do? -- Michael Mior mm...@apache.org Le mar. 13 nov. 2018 à 07:56, 大明 a écrit : > Hi Guys: > > > I got a question why it can't recognize DISTINCT tag on COUNT(DISTINCT > col) aggre

Re: Potential student projects

2018-11-13 Thread Michael Mior
Good thought. I'll keep that in mind as well. There's probably far more projects (and students) than I'll be able to supervise, but hopefully Calcite will be able to get some mileage from this. -- Michael Mior mm...@apache.org Le mar. 13 nov. 2018 à 13:04, Julian Hyde a écr

Re: Potential student projects

2018-11-13 Thread Michael Mior
Agreed. Students only have a few months to take this project from start to finish so anything which helps them get up to speed is a plus. -- Michael Mior mm...@apache.org Le mar. 13 nov. 2018 à 14:39, Julian Hyde a écrit : > I think it’s important that the project should start off with s

Re: Potential student projects

2018-11-13 Thread Michael Mior
the work is not as interesting as the > ones available in Calcite, but I'll see if I can find some interesting > other interesting issues for Avatica too. > > Francis > > On 14/11/2018 6:46 am, Michael Mior wrote: > > Agreed. Students only have a few months to take th

Re: Unable to build Avatica release: An API incompatibility was encountered while executing org.apache.maven.plugins:maven-release-plugin:2.5.3:prepare

2018-11-16 Thread Michael Mior
Looks like this is an issue with maven-scm-provider 1.11.1. https://www.mail-archive.com/issues@maven.apache.org/msg137630.html A temporary solution seems to be to downgrade to 1.10.0. -- Michael Mior mm...@apache.org Le ven. 16 nov. 2018 à 03:31, Francis Chuang a écrit : > Hi all, >

WITH RECURSIVE implementation

2018-11-17 Thread Michael Mior
rtainly a challenge since there's no obvious way to know how many times the recursive query will need to run. Specific suggestions would probably be best placed on the corresponding issue. Thanks! https://issues.apache.org/jira/browse/CALCITE-129 -- Michael Mior mm...@apache.org

Re: Avatica CI test failures

2018-11-18 Thread Michael Mior
Thanks Francis! I updated the configuration on Jenkins and triggered a rebuild and looks like things pass now. -- Michael Mior mm...@apache.org Le dim. 18 nov. 2018 à 17:20, Francis Chuang a écrit : > This is the latest test failure for Avatica on Jenkins: > > https://builds.apach

Re: Avatica CI test failures

2018-11-19 Thread Michael Mior
No problem. I also gave you access so you should be able to do this yourself in the future. Let me know if that doesn't seem to have worked. -- Michael Mior mm...@apache.org Le dim. 18 nov. 2018 à 21:10, Francis Chuang a écrit : > Thanks, Michael! > > On 19/11/2018 11:37 am

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-19 Thread Michael Mior
How about making use of https://github.com/olukyrich/githook-maven-plugin? A post-commit hooks in git seems to be an easy way to achieve this. Unfortunately, it would require that each fresh clone of the repository has a one-time command run to install the hook. -- Michael Mior mm...@apache.org

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-19 Thread Michael Mior
Sorry, that link should have been https://github.com/phillipuniverse/githook-maven-plugin. Anyway, I don't have experience with any particular plugin, but git hooks seem to be the obvious way to go and that's the first one I found. -- Michael Mior mm...@apache.org Le lun. 19 nov. 20

Re: [DISCUSS] [Calcite-2683] ProjectMergeRule should not be performed when Nondeterministic udf has been referenced more than once

2018-11-19 Thread Michael Mior
ce that's least likely to cause problems. If we allow other semantics, I would suggest that strict should be the default unless we can clearly prove that other semantics will always produce correct results. -- Michael Mior mm...@apache.org Le lun. 19 nov. 2018 à 13:45, Julian Hyde a écrit

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-19 Thread Michael Mior
Sure, a shell script would work just fine as well. Really we just need to create a symlink in the .git/hooks directory that points to a script which performs whatever checks we want. -- Michael Mior mm...@apache.org Le lun. 19 nov. 2018 à 16:11, Francis Chuang a écrit : > Will a shell scr

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-21 Thread Michael Mior
Git hooks run client-side, so there's nothing to do on the server. Unfortunately, to work on Windows, I believe we would need to write two versions of the hook. -- Michael Mior mm...@apache.org Le lun. 19 nov. 2018 à 16:21, Julian Hyde a écrit : > Are we allowed to create hooks in A

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-21 Thread Michael Mior
I could be wrong, but my understanding was that on Windows (as on other platforms), hooks are simply scripts that are executed. Given that we can't run a bash script on Windows (without making unnecessary assumptions about the environment), it seems a second script would be needed. -- Mi

Re: Vote for SQLLine release 1.6.0

2018-11-21 Thread Michael Mior
Sounds excellent! Thanks to Julian (and other SQLLine committers) for continuing to push this forward :) -- Michael Mior mm...@apache.org Le mer. 21 nov. 2018 à 17:12, Julian Hyde a écrit : > Calcite developers and users, > > I have just started a vote for sqlline-1.6.0 on the SQ

Re: Issue with extending SqlAbstractConformance

2018-11-26 Thread Michael Mior
You seem to only be showing the first line of the error. There should be a longer message below that would probably be helpful for debugging. -- Michael Mior mm...@apache.org Le lun. 26 nov. 2018 à 06:54, Devjyoti Patra a écrit : > Hi, I am trying to build the parser config using

Re: [DISCUSS] Towards Calcite 1.18

2018-12-01 Thread Michael Mior
just don’t have > enough active committers to deal with the number of incoming contributions. > > Julian > > [1] https://github.com/apache/calcite/pulls > > > > On Nov 6, 2018, at 4:24 AM, Michael Mior wrote: > > > > Not strictly necessary I believe, but I know

Re: [DISCUSS] Towards Avatica 1.13.0

2018-12-04 Thread Michael Mior
Thanks Francis! -- Michael Mior mm...@apache.org Le dim. 2 déc. 2018 à 21:13, Francis Chuang a écrit : > Avatica 1.13.0 has been tagged and released. I am holding off the formal > announcement until the release artifacts propagate across all mirrors. > > The Hypersql docker im

Mirroring JIRA/GitHub comments

2018-12-04 Thread Michael Mior
check if someone has reviewed there. If there are no objections, I'll file a ticket with INFRA. -- Michael Mior mm...@apache.org

Re: Mirroring JIRA/GitHub comments

2018-12-04 Thread Michael Mior
ks it will be more productive. If it makes things worse, especially for those who invest much more time than I such as Julian, then I would revoke this suggestion. -- Michael Mior mm...@apache.org Le mar. 4 déc. 2018 à 20:00, Julian Hyde a écrit : > I suspect that my practices are out of s

Re: [VOTE] Release apache-calcite-1.18.0 (release candidate 0)

2018-12-04 Thread Michael Mior
+1 (binding) Downloaded and checked hash and signature. Built and ran tests on Ubuntu 18.04 with Java 8. Thanks Julian! -- Michael Mior mm...@apache.org Le mar. 4 déc. 2018 à 04:00, Julian Hyde a écrit : > Hi all, > > I have created a build for Apache Calcite 1.18.0, release ca

Re: [VOTE] Release apache-calcite-1.18.0 (release candidate 0)

2018-12-05 Thread Michael Mior
Thanks Sergey! CassandraUnit has known issues on Java 9 ( https://github.com/jsevellec/cassandra-unit/issues/249). Perhaps we should disable that test on Java 9+ until this is fixed? -- Michael Mior mm...@apache.org Le mer. 5 déc. 2018 à 06:53, Sergey Nuyanzin a écrit : > Downloaded

Re: [VOTE] Release apache-calcite-1.18.0 (release candidate 0)

2018-12-05 Thread Michael Mior
Interesting. I didn't realize the issue was Windows-only. Regardless, hopefully this will be resolved soon but I'm not worried about it blocking the release. -- Michael Mior mm...@apache.org Le mer. 5 déc. 2018 à 11:00, Sergey Nuyanzin a écrit : > Michael, thank you for link

Re: [VOTE] Release apache-calcite-1.18.0 (release candidate 1)

2018-12-06 Thread Michael Mior
+1 (binding) checked hashes and signature and compiled and ran tests. Thanks for the fixes! -- Michael Mior mm...@apache.org Le jeu. 6 déc. 2018 à 03:19, Julian Hyde a écrit : > OK, let's try again. > > I have created a build for Apache Calcite 1.18.0, release candidate 1.

Fwd: [NOTICE] Mandatory relocation of Apache git repositories on git-wip-us.apache.org

2018-12-07 Thread Michael Mior
to a decision on our strategy relatively soon so we can start thinking about what might need to change and when. Thanks! -- Michael Mior mm...@apache.org -- Forwarded message - From: Daniel Gruno Date: ven. 7 déc. 2018 à 11:54 Subject: [NOTICE] Mandatory relocation of Apache git rep

Re: Can’t seem to parse DDL staements

2018-12-17 Thread Michael Mior
Support for some DDL is missing. See for example https://issues.apache.org/jira/browse/CALCITE-2663 -- Michael Mior mm...@apache.org Le lun. 17 déc. 2018 à 15:40, Dilip Raj Baral a écrit : > Hi, Ted. > > Thanks for the information. That was very helpful. I was not aware of > ca

Re: Relational algebra and signal processing

2018-12-17 Thread Michael Mior
Perhaps you've thought of this already, but it sounds like streaming relational algebra could be a good fit here. https://calcite.apache.org/docs/stream.html -- Michael Mior mm...@apache.org Le dim. 16 déc. 2018 à 18:39, Julian Feinauer a écrit : > Hi Calcite-devs, > > I j

Re: Relational algebra and signal processing

2018-12-18 Thread Michael Mior
nked below from Julian Hyde has a nice overview https://www.slideshare.net/julianhyde/streaming-sql-62376119 -- Michael Mior mm...@apache.org Le mar. 18 déc. 2018 à 02:28, Julian Feinauer a écrit : > Hi Michael, > > yes, our workloads are usually in the context of streaming (but fo

Re: [VOTE] Release apache-calcite-1.18.0 (release candidate 2)

2018-12-18 Thread Michael Mior
+1 (binding) Checked signature and hashes and compiled and ran tests. Thanks Julian! -- Michael Mior mm...@apache.org Le mar. 18 déc. 2018 à 15:00, Julian Hyde a écrit : > Hi all, > > I have created a build for Apache Calcite 1.18.0, release candidate 2. > > Since the p

Re: Info need on the lib encryption

2018-12-18 Thread Michael Mior
ely easily. -- Michael Mior mm...@apache.org Le mar. 18 déc. 2018 à 17:38, Hemakumar Gokulakannan a écrit : > Hello Team, > > We are trying to use Apache Calcite core 1.17.0(including > avatica-core-1.12.0, avatica-metrics-1.12.0 and calcite-linq4j-1.17.0) in > our application, however we

Calcite example code

2018-12-19 Thread Michael Mior
suggestions on what should be included. Eventually, I'd like to get CI set up for this repository so I can re-run the notebooks at will. I would then aim to check this on every release so we can have a repository of code samples which we know run correctly. -- Michael Mior mm...@apache.org

Re: Calcite example code

2018-12-19 Thread Michael Mior
get when running locally. The notebook consists of a series of "cells" which you can run individually and edit as you wish. This would also make it easy for people to play around with Calcite a little without having to install anything. -- Michael Mior mm...@apache.org Le mer. 19 déc. 201

Re: Calcite example code

2018-12-20 Thread Michael Mior
Here's another one focused on basic query optimization https://github.com/michaelmior/calcite-notebooks/blob/master/query-optimization.ipynb -- Michael Mior mm...@apache.org Le mer. 19 déc. 2018 à 18:21, Michael Mior a écrit : > Yes the notebook contains the output (it's reall

[ANNOUNCE] New Calcite PMC chair: Francis Chuang

2018-12-20 Thread Michael Mior
Calcite community members, I am pleased to announce that we have a new PMC chair and VP. I have resigned, and Francis was duly elected by the PMC and approved unanimously by the Board. Please join me in congratulating Francis! -Michael PS - This should not be indicative of a lack of continued i

Re: [ANNOUNCE] Apache Calcite 1.18.0 released

2018-12-25 Thread Michael Mior
Thanks for serving as RM yet again Julian! Now that the release is out and we have some slower time during the holidays, I'll ping INFRA about the voluntary migration to the new git server. -- Michael Mior mm...@apache.org Le ven. 21 déc. 2018 à 19:25, Julian Hyde a écrit : > Th

Re: [NOTICE] Mandatory relocation of Apache git repositories on git-wip-us.apache.org

2018-12-25 Thread Michael Mior
Since there have been no objections and the release is now complete, I've requested the migration. https://issues.apache.org/jira/browse/INFRA-17498 -- Michael Mior mm...@apache.org Le ven. 7 déc. 2018 à 11:54, Daniel Gruno a écrit : > [IF YOUR PROJECT DOES NOT HAVE GIT REPOSITORIE

Re: [NOTICE] Mandatory relocation of Apache git repositories on git-wip-us.apache.org

2018-12-25 Thread Michael Mior
The migration is already done to my surprise. I'll try to update the site and send out an announcement to committers later today. On Tue, Dec 25, 2018, 16:15 Francis Chuang Thanks for sorting this out, Michael! Can't wait to try it! > > On 26/12/2018 2:13 am, Michael Mior wrote:

Re: New JIRA label "pull-request-available"

2018-12-25 Thread Michael Mior
base so I find most PRs are in code I'm really not comfortable with reviewing. As I work on the notebooks I posted earlier, I'm hoping to expand my familiarity so I'll be more comfortable with some other pieces. -- Michael Mior mm...@apache.org Le mar. 25 déc. 2018 à 16:19, Franc

Re: calcite git commit: Site: Update PMC chair

2018-12-25 Thread Michael Mior
Thanks for this Francis. Slipped my mind when I made the announcement. -- Michael Mior mm...@apache.org Le sam. 22 déc. 2018 à 17:47, a écrit : > Repository: calcite > Updated Branches: > refs/heads/master 5447b9ce6 -> a4bcea8c5 > > > Site: Update PMC chair > >

Re: PLC4X Adapter for Calcite

2018-12-25 Thread Michael Mior
Great! Thanks for sharing Julian. -- Michael Mior mm...@apache.org Le mar. 25 déc. 2018 à 14:23, Julian Feinauer a écrit : > Hi all, > > I am kind of cross posting this but I think it could be interesting for > both communities, see my original post on the plc4x dev ML [1]. >

Re: [NOTICE] Mandatory relocation of Apache git repositories on git-wip-us.apache.org

2018-12-25 Thread Michael Mior
I've made commits to master to update the site but somehow my site branch seems to be out of sync with what's deployed. If someone who has deployed the site recently has a chance to check it out that would be great. -- Michael Mior mm...@apache.org Le mar. 25 déc. 2018 à 16:20, Micha

Re: [NOTICE] Mandatory relocation of Apache git repositories on git-wip-us.apache.org

2018-12-28 Thread Michael Mior
be in both master and site branches. > >>> > >>> On Tue, Dec 25, 2018 at 9:48 PM Francis Chuang < > francischu...@apache.org> > >>> wrote: > >>> > >>>> When I deployed the changes to update the PMC Chair, I deployed the > >&

Re: [NOTICE] Mandatory relocation of Apache git repositories on git-wip-us.apache.org

2018-12-28 Thread Michael Mior
Yup, that did the trick. Thanks! -- Michael Mior mm...@apache.org Le ven. 28 déc. 2018 à 14:33, Julian Hyde a écrit : > The release news was disappearing because I’d forgotten to commit it to > master. The problem should be fixed. When you regenerate the site using > Jekyll, the onl

Re: Support of Regex in CalciteAssert

2019-01-02 Thread Michael Mior
+1 to what Julian said. -- Michael Mior mm...@apache.org Le mer. 2 janv. 2019 à 19:57, Julian Hyde a écrit : > I wouldn’t do regex by default. Quite a few characters are regex meta > characters (e.g. “(“ and “.”) and it’s a pain to have to remember to escape > them when copy-pasti

Re: [DISCUSS] Draft board report for January 2019

2019-01-02 Thread Michael Mior
x27;s an option we didn't have before.) 2. The merge button on PR pages. To make use of this we would have to do away with the policy of adding the contributor's name to the commit message in this case. However, since the commit would be made by the author of the PR, I don't

Re: [Review request] (CALCITE-2554) Enrich enumerable join operators with order preserving information

2019-01-03 Thread Michael Mior
Stamatis, I left a comment on the PR. Overall it looks great to me although I wonder if we want to resolve CALCITE-2582 first to avoid disabling the subquery tests. Thanks! -- Michael Mior mm...@apache.org Le jeu. 3 janv. 2019 à 11:09, Stamatis Zampetakis a écrit : > Hello, > > Can

Re: Disabling of "merge commits" and "squash merge" on Github

2019-01-04 Thread Michael Mior
s ready to merge but the original contributor is no longer available. This shouldn't hold us back. That said, I don't have a particular problem with disabling the button on GitHub. -- Michael Mior mm...@apache.org Le ven. 4 janv. 2019 à 03:37, Francis Chuang a écrit : > Hey Stamat

Re: Disabling of "merge commits" and "squash merge" on Github

2019-01-04 Thread Michael Mior
I wasn't advocating this, just explaining what has been done in the past. If the squash merge button on GitHub keeps authorship, I would prefer to keep that enabled. -- Michael Mior mm...@apache.org Le ven. 4 janv. 2019 à 12:06, Julian Hyde a écrit : > > > > On Jan 4, 2019, at

Re: Using materialized view rewrites to route queries to different backend engines

2019-01-04 Thread Michael Mior
Would this example of query optimization using Calcite help? https://github.com/michaelmior/calcite-notebooks/blob/master/query-optimization.ipynb If not, sharing the code you have so far and specifically pointing out the problem you're having would be helpful. -- Michael Mior mm...@apach

Re: Disabling of "merge commits" and "squash merge" on Github

2019-01-04 Thread Michael Mior
That comment makes it sound like it will be the authorship information for whoever presses the button, which is not what we want. If that's the case, keeping the button disabled makes sense to me. -- Michael Mior mm...@apache.org Le ven. 4 janv. 2019 à 13:14, Vladimir Sitnikov a

Re: Help wit Calcite

2019-01-07 Thread Michael Mior
play with it yourself. https://github.com/michaelmior/calcite-notebooks -- Michael Mior mm...@apache.org Le lun. 7 janv. 2019 à 12:59, Tom Shashaty a écrit : > Hi, > > > > I am trying to find resources to help me understand Calcite better. > > > > I am mainly look

Re: "Patch" flag vs. "pull-request-available" label

2019-01-08 Thread Michael Mior
+1 for standardizing. No opinion on which one we use. -- Michael Mior mm...@apache.org Le lun. 7 janv. 2019 à 16:13, Julian Hyde a écrit : > There seem to be two mechanisms to indicate that a pull-request is > available for a JIRA case. > > 1. The “Patch” flag (13 issues);

Re: Planner state vs CannotPlanException vs humans

2019-01-28 Thread Michael Mior
it's worth thinking through some more collectively. -- Michael Mior mm...@apache.org Le lun. 28 janv. 2019 à 07:43, Stamatis Zampetakis a écrit : > > Hi Vladimir, > > Anton Haidai did a nice visualizer [1] for sets, subsets, and rels using > Calcite's logging mec

Re: getting all the equivalent query plans of an sql query

2019-02-04 Thread Michael Mior
planning phase. You could construct your own visitor which will produce multiple alternative plans. -- Michael Mior mm...@apache.org Le ven. 1 févr. 2019 à 12:41, asma zgolli a écrit : > > Hello , > > my use case is building the search space of a special optimizer and I which >

Re: Release managers

2019-02-04 Thread Michael Mior
Great idea. I was intending to volunteer as RM last time, but with the time pressure, I didn't respond soon enough. I'm happy to take the April release (1.20). -- Michael Mior mm...@apache.org Le jeu. 31 janv. 2019 à 18:54, Andrei Sereda a écrit : > > Release Target date

Re: Planner state vs CannotPlanException vs humans

2019-02-04 Thread Michael Mior
at properties the missing node should have that are missing from the nodes which have been previously generated. In any case, what you have is definitely much better than what we have now. I don't see a good reason not to commit and we can always improve later. Thanks Vladimir -- Michael Mi

Re: Error connecting Calcite to Elasticsearch

2019-02-04 Thread Michael Mior
This looks like a bug. Could you try adding another key "userConfig": "{}" under "operand" in your model file and see if that runs? -- Michael Mior mm...@apache.org Le lun. 4 févr. 2019 à 14:29, Allan Keers a écrit : > > Hi there, > I can connect my Cal

Re: Error connecting Calcite to Elasticsearch

2019-02-05 Thread Michael Mior
Thanks Andrei! Allan, if you add the key as I suggested above, this should solve your problem for now and then you should be able to remove this after the next version of Calcite is release. -- Michael Mior mm...@apache.org Le mar. 5 févr. 2019 à 11:27, Andrei Sereda a écrit : > > I have r

Re: Calcite - Step into debug (IntelliJ)

2019-02-05 Thread Michael Mior
Daniel, Have you checked the IntelliJ setup instructions in the HOWTO? https://calcite.apache.org/docs/howto.html#setting-up-intellij-idea -- Michael Mior mm...@apache.org Le mar. 5 févr. 2019 à 17:03, Daniel Dubovski a écrit : > > Hi dear devs! > > I'm interested in adding

Re: Calcite's CBO

2019-02-05 Thread Michael Mior
ill pick a plan which is generally quite close to the optimal, but we have no guarantee of this. [0] https://pdfs.semanticscholar.org/a817/a3e74d1663d9eb35b4baf3161ab16f57df85.pdf [1] https://arxiv.org/pdf/1802.10233.pdf -- Michael Mior mm...@apache.org Le mar. 5 févr. 2019 à 15:52, Lekshmi a é

Re: Calcite Validator Customization

2019-02-06 Thread Michael Mior
g String.concat. Unfortunately, I don't think you can override the behaviour of built-in operators without making your build of Calcite. -- Michael Mior mm...@apache.org Le mer. 6 févr. 2019 à 17:07, Paul Trepagnier a écrit : > > I am using Calcite to try to be a federated database server for a

Re: Calcite's CBO

2019-02-06 Thread Michael Mior
his, but few do. -- Michael Mior mm...@apache.org Le mer. 6 févr. 2019 à 05:22, Lekshmi a écrit : > > Hi, > In [0], they suggest, "the optimizer implementer can choose the cost to be > a number or record". Which does one Apache Calcite use? I found, it as a > record, when I run

Re: Calcite's CBO

2019-02-07 Thread Michael Mior
rs of queries. So if the estimated number of rows is 100 and filters are applied that remove an estimated 95% and 30% of rows, then the estimated rows produced by the query will be 3.5. -- Michael Mior mm...@apache.org Le jeu. 7 févr. 2019 à 04:55, Lekshmi a écrit : > > Dear Michael Mior, >

Re: Broken Travis

2019-02-08 Thread Michael Mior
Thanks Kevin! -- Michael Mior mm...@apache.org Le ven. 8 févr. 2019 à 16:48, Kevin Risden a écrit : > > Master is backed to fixed after committing CALCITE-2836 > > https://travis-ci.org/apache/calcite/builds/490737420 > > Kevin Risden > > > On Fri, Feb 8, 2019 at

Re: Calcite's CBO

2019-02-08 Thread Michael Mior
finds the cheapest plan using essentially the same algorithm as used in the Volcano planner which I referenced earlier. You can see the code in VolcanoPlanner#findBestExp. -- Michael Mior mm...@apache.org Le ven. 8 févr. 2019 à 14:34, Lekshmi a écrit : > > Hi, > I understand... If we are overr

Re: [DISCUSS] Move site repositories from svn to gitbox

2019-02-11 Thread Michael Mior
+1 for me as well and another +1 for automation if we can have this happen from the "site" branch. -- Michael Mior mm...@apache.org Le lun. 11 févr. 2019 à 05:01, Francis Chuang a écrit : > > Hey all, > > ASF project sites have the ability to use git instead of subversion

Re: Pushing to site (in svn)

2019-02-11 Thread Michael Mior
7;s better than the previous approach of carefully selecting what to commit to SVN manually :) -- Michael Mior mm...@apache.org Le lun. 11 févr. 2019 à 08:28, Stamatis Zampetakis a écrit : > > Commiting to master, site, and svn is the way to go I think. > > It is not a problem if mast

Re: [DISCUSS] Towards Calcite 1.19.0

2019-02-11 Thread Michael Mior
Thanks for getting the ball rolling Kevin! -- Michael Mior mm...@apache.org Le lun. 11 févr. 2019 à 09:51, Kevin Risden a écrit : > > Calcite 1.18.0 was released on 2018-12 (coming up on 2 months ago). It is > time to get the ball rolling for the Calcite 1.19.0 release since there &g

Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to Rule Them All"

2019-02-12 Thread Michael Mior
Excellent! Really glad to see all the work that has been happening on streaming SQL in the Apache community get recognized. -- Michael Mior mm...@apache.org Le mar. 12 févr. 2019 à 08:11, Edmon Begoli a écrit : > > Dear Calcite community, > > I want to let you know that another signi

Re: new Adapter Contribution

2019-02-14 Thread Michael Mior
hat case, there's nothing stopping contributors for maintaining adapters external to the Calcite code base :) -- Michael Mior mm...@apache.org Le jeu. 14 févr. 2019 à 04:57, Hanan Yehudai a écrit : > > Hi all, > we are developing a calcite based adapter, are there any pre-requi

Re: [DISCUSS] Move site repositories from svn to gitbox

2019-02-15 Thread Michael Mior
o have the entire history of the site to push a change. -- Michael Mior mm...@apache.org Le ven. 15 févr. 2019 à 05:29, Francis Chuang a écrit : > > Hey everyone, > > I have now created the calcite-site repo in Gitbox. It is now available > via Github and the Gitbox endpoint, but

Re: Contribution to calcite elastic search development

2019-02-18 Thread Michael Mior
Note that in the interim, you can define a view on top of the raw schema that will let you expand columns from the _MAP column into tables which are more convient to query. -- Michael Mior mm...@apache.org Le lun. 18 févr. 2019 à 12:21, Andrei Sereda a écrit : > > Hi Kumar, > > Curre

Re: Calcite Avatica - JIRA version cleanup?

2019-02-21 Thread Michael Mior
Kevin, I'm guessing you're right that this should be cleaned up. I've added you as an admin to the Calcite JIRA project so you should be able to make changes yourself. -- Michael Mior mm...@apache.org Le sam. 9 févr. 2019 à 09:45, Kevin Risden a écrit : > > I was lookin

Re: support more UDFs

2019-02-22 Thread Michael Mior
Issues can also be assigned to contributors and I've added you as a contributor and assigned the issue to you. Thanks! -- Michael Mior mm...@apache.org Le jeu. 21 févr. 2019 à 12:56, Ilia Gorelikhin a écrit : > > Hello! I would like to help with task > https://issues.apache.o

Re: Supportin PostgreSQL OID casts

2019-02-26 Thread Michael Mior
. -- Michael Mior mm...@apache.org Le mar. 26 févr. 2019 à 05:55, Muhammad Gelbana a écrit : > > I'm willing to implement running PostgreSQL queries involving OID casts > > *For example:* > SELECT * FROM pg_attribute > WHERE attrelid = 'mytable'::regclass; >

Re: Supportin PostgreSQL OID casts

2019-02-26 Thread Michael Mior
your query and use the RexShuttle implementation to visit every RexNode which should cover both cases. -- Michael Mior mm...@apache.org Le mar. 26 févr. 2019 à 10:50, Muhammad Gelbana a écrit : > > I believe > org.apache.calcite.prepare.CalcitePrepareImpl.createPlanner(Context, > Con

Re: [DISCUSS] Towards Calcite 1.19.0

2019-02-26 Thread Michael Mior
worked on. They can always be reopened in the future. -- Michael Mior mm...@apache.org Le lun. 25 févr. 2019 à 19:14, Julian Hyde a écrit : > > Hey everyone. > > There are 108 open pull requests. What are we going to do about it? > > Last release I reviewed and committed doze

Re: [DISCUSS] Move gitbox notification emails to another list?

2019-02-27 Thread Michael Mior
+1 Personally, I'm not concerned about emails that have already been sent. They're in the dev@ archive if we need them and if we need to search two list archives for emails within this couple months that sounds like less of a pain than forwarding all the past messages. -- Micha

Re: JIRAs and Pull Requests Cleanup

2019-02-28 Thread Michael Mior
sonally, I think the list of open PRs should things that are actively being worked on. Closed PRs can always be reopened anyway, so I don't think we're losing anything. -- Michael Mior mm...@apache.org Le mer. 27 févr. 2019 à 14:36, Kevin Risden a écrit : > > There are 105 open pu

Re: [calcite] branch master updated: [CALCITE-2827] Allow Convention.NONE planning with VolcanoPlanner

2019-02-28 Thread Michael Mior
Laurent did answer my objection and indicate he's willing to revert. I'm ok with the provided explanation. (Although an unrelated note, things like "Fix checkstyle error" and "Fix grammar errors" should not be part of the final commit message.) -- Michael Mior mm.

Re: JIRAs and Pull Requests Cleanup

2019-02-28 Thread Michael Mior
st of recent, unassigned PRs, it would make reviewing much easier. -- Michael Mior mm...@apache.org Le jeu. 28 févr. 2019 à 14:19, Julian Hyde a écrit : > > -1 Using a robot to close stale PRs is solving the wrong problem. > > The main reason that we have a lot of open PRs is that we

Re: Generating javadoc using Docker

2019-03-01 Thread Michael Mior
You may wish to try running mvn install in the repository first. If this solves your problem, we should document this. -- Michael Mior mm...@apache.org Le jeu. 28 févr. 2019 à 17:24, Siddharth Teotia a écrit : > > Hi, > > I am following the instructions here > https://github.com

<    1   2   3   4   5   6   7   8   9   >