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 helps, Eric
From: Dave Birdsall [mailto:[email protected]] Sent: Monday, May 8, 2017 11:25 AM To: [email protected] 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:[email protected]] Sent: Monday, May 8, 2017 9:15 AM To: [email protected]<mailto:[email protected]> Subject: RE: [Question]Does Trafodion support median() function as Oracle? 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:[email protected]] Sent: Monday, May 8, 2017 3:17 AM To: [email protected]<mailto:[email protected]> Subject: [Question]Does Trafodion support median() function as Oracle? Hi trafodioners, Can anyone please tell me does Trafodion support median function or similar window function as Oracle has? If not, do we have another way to realize this? Select median(fee_sum_before), avg(fee_sum_before),max(...), min(...) from ta_user_property; Best regards, Yuan Email: [email protected]<mailto:[email protected]> Cellphone: (+86) 13671935540
