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 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, May 8, 2017 3:17 AM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 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: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540