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 <[email protected]>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 >
