hive统计函数《归因统计》

需求：统计对用户曝光的数据多久后用户点击

统计百分比：
用法：percentile_approx(数值类型、array(需要统计的百分比…))
注意该函数是聚合函数

percentile_approx((click_time - show_time),array(0.01,0.02,0.03,0.04,0.05,0.06,0.07,0.08,0.09,0.1,0.11,0.12,0.13,0.14,0.15,0.16,0.17,0.18,0.19,0.2,
0.21,0.22,0.23,0.24,0.25,0.26,0.27,0.28,0.29,0.3,0.31,0.32,0.33,0.34,0.35,0.36,0.37,0.38,0.39,0.4,
0.41,0.42,0.43,0.44,0.45,0.46,0.47,0.48,0.49,0.5,0.51,0.52,0.53,0.54,0.55,0.56,0.57,0.58,0.59,
0.6,0.61,0.62,0.63,0.64,0.65,0.66,0.67,0.68,0.69,0.7,0.71,0.72,0.73,0.74,0.75,0.76,0.77,0.78,0.79,0.8,
0.81,0.82,0.83,0.84,0.85,0.86,0.87,0.88,0.89,0.9,0.91,0.92,0.93,0.94,0.95,0.96,0.97,0.98,0.99))

测试统计1-100之间的数据：

统计num的比例：

[1.0,2.0,3.0,4.0,5.0,6.0,7.000000000000001,8.0,9.0,10.0,11.0,12.0,13.0,14.000000000000002,15.0,16.0,
17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.000000000000004,28.999999999999996,30.0,31.0,
32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,
53.0,54.0,55.00000000000001,56.00000000000001,56.99999999999999,57.99999999999999,59.0,60.0,61.0,62.0,
63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,
83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0]

如果只有22条数据:

[1.0,1.0,1.0,1.0,1.1,1.3199999999999998,1.54,1.76,1.98,2.2,2.42,2.6399999999999997,2.8600000000000003,
3.08,3.3,3.52,3.74,3.96,4.18,4.4,4.62,4.84,5.0600000000000005,5.279999999999999,5.5,5.720000000000001,
5.94,6.16,6.38,6.6,6.82,7.04,7.260000000000001,7.48,7.699999999999999,7.92,8.14,8.36,8.58,8.8,9.02,9.24,
9.459999999999999,9.68,9.9,10.120000000000001,10.34,10.559999999999999,10.78,11.0,11.22,11.440000000000001,
11.66,11.88,12.100000000000001,12.32,12.54,12.76,12.979999999999999,13.2,13.42,13.64,13.86,14.08,14.3,
14.520000000000001,14.74,14.96,15.18,15.399999999999999,15.62,15.84,16.06,16.28,16.5,16.72,16.94,17.16,
17.380000000000003,17.6,17.82,18.04,18.259999999999998,18.48,18.7,18.919999999999998,19.14,19.36,
19.580000000000002,19.8,20.02,20.240000000000002,20.46,20.68,20.9,21.119999999999997,21.34,21.56,21.78]