On 12/18/2014 04:43 PM, Serge Monkewitz wrote: > On Dec 18, 2014, at 4:32 PM, Daniel L. Wang <[log in to unmask]> wrote: > >> Hi Fabrice, >> >> I don't know about the loader, but the data model and query execution don't care if the primary key of a table is multi-column, EXCEPT for the director table. We may reject equi-joins between partitioned tables if the join column is not the director's key column. > I’d use stronger language: if we do not reject an equi-join between a child and director table that isn’t written in terms of the director’s key column, then that is a bug in the query analysis code I added not too long ago, and you should file a bug. In this case AvgForcedPhotYearly is a child table whose director should be DeepSource. > > Serge > Thanks, DeepSource si a view, shouldn't it be RunDeepSource the director table? Furthermore, it seems dirTable and dirColName are optional for now, isn't it? Andy doesn't set it in test case01 and 02 and it works. ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1