[ 
https://issues.apache.org/jira/browse/HIVEMALL-280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16983838#comment-16983838
 ] 

Makoto Yui commented on HIVEMALL-280:
-------------------------------------

[~dharmikt]

"A, B, A_count, B_count, AB_count, tx_total" is required to compute 
support/confidence/lift. Thus, I think "product 1, product 2, number of tx" is 
not enough.

> Support lift/confidence/support UDF
> -----------------------------------
>
>                 Key: HIVEMALL-280
>                 URL: https://issues.apache.org/jira/browse/HIVEMALL-280
>             Project: Hivemall
>          Issue Type: New Feature
>            Reporter: Makoto Yui
>            Assignee: Makoto Yui
>            Priority: Minor
>
> Support lift/confidence/support UDAF
> [https://en.wikipedia.org/wiki/Lift_(data_mining])
> [https://towardsdatascience.com/a-gentle-introduction-on-market-basket-analysis-association-rules-fa4b986a40ce]
> [https://medium.com/@samratjain/explained-market-basket-analysis-using-sql-a7434f30e649]
> {code:java}
> select
>   item, other_item,
>   lift(...) as lift,
>   confidence (....) as confidence
> from
>   transaction
> group by
>   1, 2{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to