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] 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
