[
https://issues.apache.org/jira/browse/HIVEMALL-280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16983325#comment-16983325
]
Dharmik Thakkar commented on HIVEMALL-280:
------------------------------------------
[~myui] Thanks!
I need one clarification on the input table 'transaction'. Does the
'transaction' table look like below?
!https://miro.medium.com/max/678/1*K2f-Rja-1xrqe9IdUy5Dgw.png!
And in the query the arguments to lift/confidence/support would be all the
three columns? Is this understanding correct? Please suggest. Thanks!
> 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)