--hive
select '20210202' as log_date, percentile_approx(prob,array(0.25,0.5,0.75,0.95),9999) from ai.push_recsys_open_status_pred_buvid where log_date='20210202';
--presto
select '20210202' as log_date, approx_percentile(prob,array[0.25,0.5,0.75,0.95]) from ai.push_recsys_open_status_pred_buvid where log_date='20210202';
--element_at
版权声明：本文为yangnianjinxin原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。