The dev list is a perfect place for the back and forth part of this
conversation. Could I encourage both of your to record some of your
queries and thoughts as they become more more well-formed on the wiki
itself?
Even the simple query that I have retained down below would be interesting
as a first look at Drill.
On Sun, Jan 20, 2013 at 2:39 PM, Siprell, Stefan
<stefan.siprell@exxeta.de>wrote:
> Hi Jacques,
> maybe I am over confident, but I think we have a great discussion going on
> here. Should we continue it using the developer mailing list, do we already
> have a policy on this?
> ...
> Looking at the sub select recordsPerRevision, I wonder how the query
> builder would know that we want one entry per page. Is this calculated by
> the fact that in the path mediawiki.page.title and mediawiki.page.id both
> have mediawiki.page as the last non scalar path entry? What would happen,
> if we need two columns with different path depths? I would at least suggest
> to model this more explicitly using:
>
> select
> title as pageTitle,
> id as pageId,
> flatten(revision) as rev
> from mediawiki.page
>
|