[ https://issues.apache.org/jira/browse/MADLIB-889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621020#comment-16621020 ]
Frank McQuillan commented on MADLIB-889: ---------------------------------------- this is addressed with max_itemset_size param > MADlid association rules limitiaon > ---------------------------------- > > Key: MADLIB-889 > URL: https://issues.apache.org/jira/browse/MADLIB-889 > Project: Apache MADlib > Issue Type: Bug > Reporter: George > Assignee: Rahul Iyer > Priority: Major > > <SQL> > -- > SELECT * FROM madlib.assoc_rules( > .02, -- support > .1, -- confidence > 'trans_id', -- trans_id > 'trans', -- trans > 'madlib.APR_D1_0511', -- input table > 'apriori_out_0511', -- output schema > TRUE); > <output> > -- > INFO: finished checking parameters > CONTEXT: PL/Python function "assoc_rules" > INFO: finished removing duplicates > CONTEXT: PL/Python function "assoc_rules" > INFO: finished encoding items > CONTEXT: PL/Python function "assoc_rules" > INFO: finished encoding input table: 28.8922719955 > CONTEXT: PL/Python function "assoc_rules" > INFO: Beginning iteration #1 > CONTEXT: PL/Python function "assoc_rules" > INFO: 248 Frequent itemsets found in this iteration > CONTEXT: PL/Python function "assoc_rules" > INFO: Completed iteration # 1. Time: 15.6718640327 > CONTEXT: PL/Python function "assoc_rules" > INFO: Beginning iteration # 2 > CONTEXT: PL/Python function "assoc_rules" > INFO: time of preparing data: 1.1467320919 > CONTEXT: PL/Python function "assoc_rules" > INFO: 5343 Frequent itemsets found in this iteration > CONTEXT: PL/Python function "assoc_rules" > INFO: Completed iteration # 2. Time: 17.6499559879 > CONTEXT: PL/Python function "assoc_rules" > INFO: Beginning iteration # 3 > CONTEXT: PL/Python function "assoc_rules" > INFO: time of preparing data: 3.88985896111 > CONTEXT: PL/Python function "assoc_rules" > INFO: 60508 Frequent itemsets found in this iteration > CONTEXT: PL/Python function "assoc_rules" > INFO: Completed iteration # 3. Time: 52.9074699879 > CONTEXT: PL/Python function "assoc_rules" > INFO: Beginning iteration # 4 > CONTEXT: PL/Python function "assoc_rules" > INFO: time of preparing data: 237.640460968 > CONTEXT: PL/Python function "assoc_rules" > INFO: 457880 Frequent itemsets found in this iteration > CONTEXT: PL/Python function "assoc_rules" > INFO: Completed iteration # 4. Time: 957.164274931 > CONTEXT: PL/Python function "assoc_rules" > INFO: Beginning iteration # 5 > CONTEXT: PL/Python function "assoc_rules" > INFO: time of preparing data: 9426.02343702 > CONTEXT: PL/Python function "assoc_rules" > ERROR: plpy.SPIError: could not write to temporary file: No space left on > device (seg24 slice2 sdw04:40000 pid=62587) (plpython.c:4648) > CONTEXT: Traceback (most recent call last): > PL/Python function "assoc_rules", line 36, in <module> > verbose > PL/Python function "assoc_rules", line 367, in assoc_rules > PL/Python function "assoc_rules" > ********** Error ********** > ERROR: plpy.SPIError: could not write to temporary file: No space left on > device (seg24 slice2 sdw04:40000 pid=62587) (plpython.c:4648) > SQL state: XX000 > Context: Traceback (most recent call last): > PL/Python function "assoc_rules", line 36, in <module> > verbose > PL/Python function "assoc_rules", line 367, in assoc_rules > PL/Python function "assoc_rules" -- This message was sent by Atlassian JIRA (v7.6.3#76005)