hive-funnel-udf

hive-funnel-udf copied to clipboard

When the dataset is small, the results are accurate, but when the amount of data becomes larger, the results of the funnel function become inaccurate

lsx0310

same user had different result

4

os environment hive version: Hive 1.1.0-cdh5.5.2 cdh version: cdh 5.5.2 when i query one day like: select ouid, funnel(tag1, game_time, array('activity'), array('yaozujianglin'), array('huangjinyuchang')) as funnel from sscq.odl_act_detail_info_sscq_qq where ds =...

ft20082

Conversion window support

1

Specify how much time a user has to complete the funnel from the moment they enter it.

tomsheep

Stored funnels can be converted into integers, where 0 is match to funnel 0, 1 is match to funnel 1, etc. This will greatly reduce the storage size of the...

joshwalters

It may be possible to add vectorized query support, which would increase performance.

joshwalters