You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@mrql.apache.org by Apache Wiki <wi...@apache.org> on 2016/10/25 15:01:03 UTC
[Mrql Wiki] Trivial Update of "SystemFunctions" by LeonidasFegaras
Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Mrql Wiki" for change notification.
The "SystemFunctions" page has been changed by LeonidasFegaras:
https://wiki.apache.org/mrql/SystemFunctions?action=diff&rev1=1&rev2=2
In the following system functions, {{{a}}} stands for any type, numeric stands for any numerical value, and all functions on bags can be applied to other collections types too.
- || '''Name''' || '''Input''' || '''Output''' || Description''' ||
+ || '''Name''' || '''Input''' || '''Output''' || '''Description''' ||
|| = || ({{{a}}},{{{a}}}) || boolean || equality (infix) ||
|| <> || ({{{a}}},{{{a}}}) || boolean || not equal (infix) ||
|| + || (string,string) || string || string concatenation (infix) ||
@@ -34, +34 @@
|| contains || (string,string) || boolean || true if the first string contains the second string ||
|| length || string || int || string size ||
|| substring || (string,int,int) || string || substring from beginIndex to endIndex ||
+ || split || (string,string) || string || Splits this string around matches of the given regular expression ||
+ || trim || string || string || Returns a copy of the string, with leading and trailing whitespace omitted ||
+ || replace || (string,string,string) || string || Replaces each substring of this string that matches the literal target sequence with the specified literal replacement sequence ||
+ || replaceAll || (string,string,string) || string || Replaces each substring of this string that matches the given regular expression with the given replacement ||
+ || replaceFirst || (string,string,string) || string || Replaces the first substring of this string that matches the given regular expression with the given replacement ||
+ || startsWith || (string,string) || boolean || Tests if this string starts with the specified prefix ||
+ || toLowerCase || string || string || Converts all of the characters in this String to lower case ||
+ || toUpperCase || string || string || Converts all of the characters in this String to upper case ||
|| count || bag({{{a}}}) || long || the number of elements in the bag ||
|| sum || bag(numeric) || numeric || sum of all values ||
|| max || bag(numeric) || numeric || maximum of all values ||