Qserv group by question

qserv
Tags: #<Tag:0x00007f61a626a2a0>

(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.


(K-T Lim) #3

This is DM-17092, which is about to be fixed.


(Vaikunth Thukral) #4

This bug fix has been implemented and will be available in the next weekly release on Monday.