[
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)
