Qserv group by question


(Mike Read) #1

Hi

It seems that you can’t have more than one attribute in a group by clause eg

this works

select multiframeID,min(extNum),count(*) from MultiframeDetector where multiframeID < 100000 group by multiframeID

this does not

select multiframeID,extNum,count(*) from MultiframeDetector where multiframeID < 100000 group by multiframeID,extNum

-> ERROR 4120 (Proxy): Unable to return query results:

Is this expected behaviour?

Cheers
Mike


(Fritz Mueller) #2

Hi Mike,

No, that should work – we’re looking into it for you now and will update here (we’re also looking at the director match table issue previously reported, now that we’re back from the holiday break.)

cheers,
–FritzM.