You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Matt Burgess <ma...@apache.org> on 2016/12/05 16:27:25 UTC
Good resources about planners
Hello all,
I'm interested in digging into Calcite (and have been dabbling in
other places like Pig, Hive, and Drill), but I only have a rudimentary
knowledge of planners (logical, physical, transformations,
optimizations). I know what they are and what their purpose is, but
haven't really seen any docs that explain the various approaches. Are
there any good resources out there for this? I tried searching the web
but didn't really see much there.
Thanks in advance,
Matt
Re: Good resources about planners
Posted by Michael Mior <mm...@uwaterloo.ca>.
You might find it helpful to read one of the original papers about Volcano
which Calcite has used as the basis of one of its planners.
https://paperhub.s3.amazonaws.com/dace52a42c07f7f8348b08dc2b186061.pdf
--
Michael Mior
michael.mior@gmail.com
2016-12-05 11:27 GMT-05:00 Matt Burgess <ma...@apache.org>:
> Hello all,
>
> I'm interested in digging into Calcite (and have been dabbling in
> other places like Pig, Hive, and Drill), but I only have a rudimentary
> knowledge of planners (logical, physical, transformations,
> optimizations). I know what they are and what their purpose is, but
> haven't really seen any docs that explain the various approaches. Are
> there any good resources out there for this? I tried searching the web
> but didn't really see much there.
>
> Thanks in advance,
> Matt
>
Re: Good resources about planners
Posted by Matt Burgess <ma...@apache.org>.
Awesome, thanks very much to both of you!
On Mon, Dec 5, 2016 at 12:43 PM, Colm McHugh <co...@gmail.com> wrote:
> Check out http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf for a
> good overview of database implementation concerns, including query
> planning. Lots of references to follow.
>
> On Mon, Dec 5, 2016 at 8:27 AM, Matt Burgess <ma...@apache.org> wrote:
>
>> Hello all,
>>
>> I'm interested in digging into Calcite (and have been dabbling in
>> other places like Pig, Hive, and Drill), but I only have a rudimentary
>> knowledge of planners (logical, physical, transformations,
>> optimizations). I know what they are and what their purpose is, but
>> haven't really seen any docs that explain the various approaches. Are
>> there any good resources out there for this? I tried searching the web
>> but didn't really see much there.
>>
>> Thanks in advance,
>> Matt
>>
Re: Good resources about planners
Posted by Colm McHugh <co...@gmail.com>.
Check out http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf for a
good overview of database implementation concerns, including query
planning. Lots of references to follow.
On Mon, Dec 5, 2016 at 8:27 AM, Matt Burgess <ma...@apache.org> wrote:
> Hello all,
>
> I'm interested in digging into Calcite (and have been dabbling in
> other places like Pig, Hive, and Drill), but I only have a rudimentary
> knowledge of planners (logical, physical, transformations,
> optimizations). I know what they are and what their purpose is, but
> haven't really seen any docs that explain the various approaches. Are
> there any good resources out there for this? I tried searching the web
> but didn't really see much there.
>
> Thanks in advance,
> Matt
>