Hi,

this is a bug --- either we should support corr() correctly,
or we should given a proper error message that we do not support it.

Please file a bug report via http://bugs.monetdb.org/

Thanks!

Stefan

----- On Apr 7, 2016, at 12:43 PM, Erie, Rob rob.erie@jmfamily.com wrote:

> I am in the process of evaluating databases for analysis at my organization. I
> have installed MonetDB and loaded some data. I was attempting to compare
> results both in performance and accuracy between MySQL and MonetDB. I have been
> receiving Overflow in Calculation errors from MonetDB. I am a total novice with
> MonetDB.
>
> Here is the information about my system:
> Red Hat Enterprise Linux Server release 7.2 (Maipo) (Linux 3.10.0-327.el7.x86_64
> #1 SMP Thu Oct 29 17:29:29 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux)
> MySQL Server version: 5.7.11-log MySQL Community Server
> Java version "1.8.0_74"; Java(TM) SE Runtime Environment (build 1.8.0_74-b02);
> Java HotSpot(TM) 64-Bit Server VM (build 25.74-b02, mixed mode).
> Apache Tomcat 7.0.54
> Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-SP3)
> Database: MonetDB v11.21.17 (Jul2015-SP3),
> 'mapi:monetdb://ip-10-153-0-5.ec2.internal:50000/set_mktng'
>
> Issue Description: I would like to know the correlation between two variables
> group by a variable.
>
> SQL:
> select milageRange, sys.corr(numberOfTheseParts,avgHomeValue) FROM
> aPartsByZipRange INNER JOIN avgHomeValueZipPeriod ON zipCode = zip where
> numberOfTheseParts <> 0 and avgHomeValue <>0 group by milageRange;
>
> Error:
> TypeException:user.s78_2[44]:'aggr.subcorr' undefined in: X_75:bat[:any,:int] :=
> aggr.subcorr(X_72:bat[:oid,:int],X_74:bat[:oid,:int],X_67:bat[:oid,:oid],r1_67:bat[:oid,:oid],true:bit);
> program contains errors
>
>

> --------------------------------------------------
> This e-mail transmission contains information intended only for the use of the
> recipient(s) named above. Further, it contains information that may be
> privileged and confidential. If you are not the intended recipient, you are
> hereby notified that any dissemination, distribution, or copying of this
> message (including any attachments) is strictly prohibited. If you have
> received this e-mail in error, please notify the sender by reply e-mail and
> then delete this message from your mail system. Thank you for your compliance.
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

--
| Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list