As the error message says, instead of "chr", the MAL parser expects a valid MAL type. As opposed to the (wrong) documentation at https://monetdb.org/Documentation/Manuals/MonetDB/MAL/Types , MAL (and all of MonetDB for that matter) does not support any "chr" (or single-byte single-character) type. See also (new) bug report #3959: https://www.monetdb.org/bugzilla/show_bug.cgi?id=3959 SQL type "CHAR[ACTER] '(' length ')'" (just like SQL types "VARCHAR '(' length ')' | CHARACTER VARYING '(' length ')'" and "TEXT | STRING | CLOB | CHARACTER LARGE OBJECT") all map to MAL type ":str", which in turn maps to (MonetDB) C type "str", which in turn is defined as "char *". Hope this helps. Stefan ----- On Mar 22, 2016, at 4:50 PM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:
I am trying to write a C User Defined Function. It works in Neatbeans. What I want is, to take value from cells, insert them in text or char array and compare each corresponding array position to each other. As values I will have "1"s and "0s". E.g "101010100011". THe code I wrote in udf.c:
/* Comparing bag of words */
char BitAnd(char Cell1[], char Cell2[]) { Cell1[10000]; Cell2[10000]; int counter; float result; int strlen = sizeof(Cell1)/sizeof(Cell1[0])-1; int i; for (i=0; i < strlen; i++) { if (Cell1[i] == Cell2[i]) { counter++; } }
result = (float)counter / strlen;
}
/* MAL wrapper */ char UDFBitAnd(char Cell1[], char Cell2[]) { /* assert calling sanity */ assert(Cell1[] != NULL && Cell2[] != NULL); return MAL_SUCCEED;
}
In udf.mal I have:
command BitAnd(Cell1:chr,Cell2:chr):flt address UDFBitAnd comment "Compare bag of words";
In 80_udf.sql:
-- Comparing bag of words create function BitAnd(Cell1[] char, Cell2[] char) returns float external name udf.BitAnd;
I compiled Monetdb, but when I try to connect with "monetdb" to db it gives me error. In the log file I found:
MSG voc[18857]: !SyntaxException:parseError:command BitAnd(Cell1:chr,Cell2:chr):flt MSG voc[18857]: !SyntaxException:parseError: ^Type identifier expected MSG voc[18857]: !SyntaxException:parseError:command BitAnd(Cell1:chr,Cell2:chr):flt MSG voc[18857]: !SyntaxException:parseError: ^',' expected MSG merovingian[8780]: database 'voc' (18857) has exited with exit status 0 MSG merovingian[8780]: database 'voc' has shut down ERR merovingian[8780]: client error: database 'voc' started up, but failed to open up a communication channel
_______________________________________________ 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) |