Print

Print


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.

-Daniel



On 12/18/2014 04:21 PM, Fabrice Jammes wrote:
> Hello,
>
> Do you know if I can specify a multi-column primary key in the id 
> field of a cfg file?
> Indeed, for AvgForcedPhotYearly
> PRIMARY KEY is (`deepSourceId`,`year`),
>
> Cheers,
>
> Fabrice
>
> ########################################################################
> 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

########################################################################
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