[MADLIB-886] MADlib association rules

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: severity_set
• Assignee: Rahul Iyer
• Reporter: George
• Created: 11/May/15 07:52
• Updated: 22/Mar/18 18:46

Description

How do I to decide the pattern of itemset(trans).
output--
Rule | Pre | Post | Sup | Con...
-------------------------------------
1 |

{A}

|

{B} | 0.2 | 0.3
2 |{A,B}|{C} | 0.1 | 0.4
3 |{B}

|

{A,C}

| 0.4 | 0.2
4 |

{C}

|

{D}

| 0.1 | 0.1
------
If I only want one kind of item in Pre and Post, what do I do in this function as follows.
sql----
SELECT * FROM madlib.assoc_rules( .25,
.5,
'trans_id',
'product',
'test_data',
'myschema',
TRUE
);

---

Is that only one method to filter the results?