Re: Calcite example code

2020-02-06 Thread Kevin Risden
Vladimir since on a different thread you asked about playground. As a side note, it might be interesting to have Calcite playground. > It could be like https://rextester.com/l/postgresql_online_compiler but > with Calcite inside. > Michael had setup one with jupyter and binder. Its not exactly

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 really just a JSON

Re: Calcite example code

2018-12-19 Thread Michael Mior
Yes the notebook contains the output (it's really just a JSON file). It doesn't necessarily have to have output, but it's much more useful if it does since it means whoever is viewing doesn't need to execute it. It would certainly be possible to use this for tests although it would require an

Re: Calcite example code

2018-12-19 Thread Kevin Risden
I like the idea a lot. Notebooks are interactive ways to work with code and results. The notebook typically contains both input and output although you can save it without the output. The notebook can be used interactively with Jupyter or one of the options below. I was going to share this as

Re: Calcite example code

2018-12-19 Thread Francis Chuang
+1 for jupyter notebooks @Julian: I have not used Jupyter notebooks myself, but read about them a few months ago. My understanding is that you can open the ipynb files using the opensource Jupyter web app and change the code interactively using code editors or widgets such as sliders etc.

Re: Calcite example code

2018-12-19 Thread Julian Hyde
For old idiots like me, can you explain how the notebook works? The file you checked into GitHub, does it contain the input and output or just the input? Is there a way to edit or use the notebook interactively? It certainly seems a better way to introduce people to examples than saying “go

Re: Calcite example code

2018-12-19 Thread Walaa Eldin Moustafa
Michael, I would definitely encourage you and anyone else to participate. That is an awesome idea, especially sometimes there are multiple ways to do the same thing. For example, instantiating a RelNode converter can be done by the planner or by constructing everything by hand. Similarly adding

Calcite example code

2018-12-19 Thread Michael Mior
After seeing so many people ask for example code to do certain basic things in Calcite, I've been trying to find a good literate programming solution for Java as I like this approach for demoing. I recently came across the IJava (https://github.com/SpencerPark/IJava) kernel for Jupyter notebooks.