hive hsql 漏斗模型_funnel: hive漏斗函数，forked https://github.com/yahoo/hive-funnel-udf

Hive Funnel Analysis UDFs

Funnel analysis is a method for

tracking user conversion rates across actions. This enables detection of actions

causing high user fallout.

These Hive UDFs enables funnel analysis to be performed simply and easily on any

Hive table.

Table of Contents

Requirements

Maven is required to build the funnel

UDFs.

How to build

There is a provided Makefile with all the build targets.

Build JAR

make jar

This creates a funnel.jar in the target/ directory.

Register JAR with Hive

To use the funnel UDFs, you need to register it with Hive.

With temporary functions:

ADD JAR funnel.jar;

CREATE TEMPORARY FUNCTION funnel AS 'com.yahoo.hive.udf.funnel.Funnel';

CREATE TEMPORARY FUNCTION funnel_merge AS 'com.yahoo.hive.udf.funnel.Merge';

CREATE TEMPORARY FUNCTION funnel_conversion AS 'com.yahoo.hive.udf.funnel.Conversion';

CREATE TEMPORARY FUNCTION funnel_fallout AS 'com.yahoo.hive.udf.funnel.Fallout';

With p