RE: [Question]Does Trafodion support median() function as Oracle?

2017-05-08 Thread Sean Broeder
There is a getMedian() aggregator function in our endpoint coprocessor implementation and also in the TransactionalAggregationClient, so I would think we have support for this function. I haven't tested it personally. Regards, Sean From: Liu, Yuan (Yuan) [mailto:yuan@esgyn.cn] Sent: Monday

RE: [Question]Does Trafodion support median() function as Oracle?

2017-05-08 Thread Dave Birdsall
I don't see any support for MEDIAN in the Trafodion SQL parser. From: Sean Broeder [mailto:sean.broe...@esgyn.com] Sent: Monday, May 8, 2017 9:15 AM To: user@trafodion.incubator.apache.org Subject: RE: [Question]Does Trafodion support median() function as Oracle? There is a getM

RE: [Question]Does Trafodion support median() function as Oracle?

2017-05-08 Thread Eric Owhadi
@trafodion.incubator.apache.org Subject: RE: [Question]Does Trafodion support median() function as Oracle? I don't see any support for MEDIAN in the Trafodion SQL parser. From: Sean Broeder [mailto:sean.broe...@esgyn.com] Sent: Monday, May 8, 2017 9:15 AM To: user@trafodion.incubator.apach

RE: [Question]Does Trafodion support median() function as Oracle?

2017-05-08 Thread Hans Zeller
M To: user@trafodion.incubator.apache.org Subject: RE: [Question]Does Trafodion support median() function as Oracle? Some ways to compute median without support for dedicated aggregate function: http://sqlblog.com/blogs/adam_machanic/archive/2006/12/18/medians-row-numbers-and-performance.aspx Hope this h

RE: [Question]Does Trafodion support median() function as Oracle?

2017-05-09 Thread Liu, Yuan (Yuan)
owh...@esgyn.com] Sent: Monday, May 8, 2017 9:42 AM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: [Question]Does Trafodion support median() function as Oracle? Some ways to compute median without support for dedicated aggregate function: ht