| Oracle® CEP CQL Language Reference 11g Release 1 (11.1.1) Part Number E12048-01 |
|
|
View PDF |
| Oracle® CEP CQL Language Reference 11g Release 1 (11.1.1) Part Number E12048-01 |
|
|
View PDF |
Oracle CQL provides a variety of built-in functions based on the java.lang.Math class.
For more information, see Section 1.1.9, "Functions".
Table 9-1 lists the built-in java.lang.Math functions that Oracle CQL provides.
Table 9-1 Oracle CQL Built-in java.lang.Math Functions
| Type | Function |
|---|---|
|
Trigonometric |
|
|
Logarithmic |
|
|
Euler's Number |
|
|
Roots |
|
|
Signum Function |
|
|
Unit of Least Precision |
|
|
Other |
Note:
In stream input examples, lines beginning with
h (such as h 3800) are heartbeat input tuples. These inform Oracle CEP that no further input will have a timestamp lesser than the heartbeat value.For more information, see:
Syntax
Purpose
ABS returns the absolute value of the input integer argument as an integer.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#abs(int).
Examples
Consider the query q66 in Example 9-1. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-2, the query returns the stream in Example 9-3.
Syntax
Purpose
ABS1 returns the absolute value of the input long argument as a long.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#abs(long).
Examples
Consider the query q67 in Example 9-4. Given the data stream SFunc with schema (c1 integer, c2 float, c3 long) in Example 9-5, the query returns the stream in Example 9-6.
Syntax
Purpose
ABS2 returns the absolute value of the input float argument as a float.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#abs(float).
Examples
Consider the query q68 in Example 9-7. Given the data stream SFunc with schema (c1 integer, c2 float, c3 bigint) in Example 9-8, the query returns the stream in Example 9-9.
Syntax
Purpose
ABS3 returns the absolute value of the input double argument as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#abs(double).
Examples
Consider the query q69 in Example 9-10. Given the data stream SFunc with schema (c1 integer, c2 float, c3 bigint, c4 double) in Example 9-11, the query returns the stream in Example 9-12.
Syntax
Purpose
ACOS returns the arc cosine of a double angle, in the range of 0.0 through pi, as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#acos(double).
Examples
Consider the query q73 in Example 9-13. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-14, the query returns the stream in Example 9-15.
Syntax
Purpose
ASIN returns the arc sine of a double angle, in the range of -pi/2 through pi/2, as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#asin(double).
Examples
Consider the query q74 in Example 9-16. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-17, the query returns the stream in Example 9-18.
Syntax
Purpose
ATAN returns the arc tangent of a double angle, in the range of -pi/2 through pi/2, as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#atan(double).
Examples
Consider the query q75 in Example 9-19. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-20, the query returns the stream in Example 9-21.
Syntax
Purpose
ATAN2 converts rectangular coordinates (x,y) to polar (r,theta) coordinates.
This function takes the following arguments:
double1: the ordinate coordinate.
double2: the abscissa coordinate.
This function returns the theta component of the point (r,theta) in polar coordinates that corresponds to the point (x,y) in Cartesian coordinates as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#atan2(double,%20double).
Examples
Consider the query q63 in Example 9-22. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-23, the query returns the stream in Example 9-24.
Example 9-22 ATAN2 Function Query
<query id="q63"><![CDATA[
select atan2(c2,c2) from SFunc
]]></query>
Syntax
Purpose
CBRT returns the cube root of the double argument as a double.
For positive finite a, cbrt(-a) == -cbrt(a); that is, the cube root of a negative value is the negative of the cube root of that value's magnitude.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#cbrt(double).
Examples
Consider the query q76 in Example 9-25. Given the data stream SFunc with schema (c1 integer, c2 float, c3 bigint) in Example 9-26, the query returns the stream in Example 9-27.
Syntax
Purpose
CEIL1 returns the smallest (closest to negative infinity) double value that is greater than or equal to the double argument and equals a mathematical integer.
To avoid possible rounding error, consider using (long) cern.jet.math.Arithmetic.ceil(double).
For more information, see:
Examples
Consider the query q77 in Example 9-28. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-29, the query returns the stream in Example 9-30.
Syntax
Purpose
COS returns the trigonometric cosine of a double angle as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#cos(double).
Examples
Consider the query q61 in Example 9-31. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-32, the query returns the stream in Example 9-33.
Syntax
Purpose
COSH returns the hyperbolic cosine of a double value as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#cosh(double).
Examples
Consider the query q78 in Example 9-34. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-35, the query returns the stream in Example 9-36.
Syntax
Purpose
EXP returns Euler's number e raised to the power of the double argument as a double.
Note that for values of x near 0, the exact sum of EXPM1(x) + 1 is much closer to the true result of Euler's number e raised to the power of x than EXP(x).
For more information, see:
Examples
Consider the query q79 in Example 9-37. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-38, the query returns the stream in Example 9-39.
Syntax
Purpose
EXPM1 returns the computation that Figure 9-1 shows as a double, where x is the double argument and e is Euler's number.
Note that for values of x near 0, the exact sum of EXPM1(x) + 1 is much closer to the true result of Euler's number e raised to the power of x than EXP(x).
For more information, see:
Examples
Consider the query q80 in Example 9-40. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-41, the query returns the stream in Example 9-42.
Syntax
Purpose
FLOOR1 returns the largest (closest to positive infinity) double value that is less than or equal to the double argument and equals a mathematical integer.
To avoid possible rounding error, consider using (long) cern.jet.math.Arithmetic.floor(double).
For more information, see:
Examples
Consider the query q81 in Example 9-43. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-44, the query returns the stream in Example 9-45.
Example 9-43 FLOOR1 Function Query
<query id="q81"><![CDATA[
select floor1(c2) from SFunc
]]></query>
Syntax
Purpose
HYPOT returns the hypotenuse (see Figure 9-2) of the double arguments as a double.
This function takes the following arguments:
double1: the x value.
double2: the y value.
The hypotenuse is computed without intermediate overflow or underflow.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#hypot(double,%20double).
Examples
Consider the query q82 in Example 9-46. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-47, the query returns the stream in Example 9-48.
Example 9-46 HYPOT Function Query
<query id="q82"><![CDATA[
select hypot(c2,c2) from SFunc
]]></query>
Syntax
Purpose
IEEEREMAINDER computes the remainder operation on two double arguments as prescribed by the IEEE 754 standard and returns the result as a double.
This function takes the following arguments:
double1: the dividend.
double2: the divisor.
The remainder value is mathematically equal to f1 - f2 × n, where n is the mathematical integer closest to the exact mathematical value of the quotient f1/f2, and if two mathematical integers are equally close to f1/f2, then n is the integer that is even. If the remainder is zero, its sign is the same as the sign of the first argument.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#IEEEremainder(double,%20double).
Examples
Consider the query q72 in Example 9-49. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-50, the query returns the stream in Example 9-51.
Example 9-49 IEEEREMAINDER Function Query
<query id="q72"><![CDATA[
select IEEEremainder(c2,c2) from SFunc
]]></query>
Syntax
Purpose
LOG1 returns the natural logarithm (base e) of a double value as a double.
Note that for small values x, the result of log1p(x) is much closer to the true result of ln(1 + x) than the floating-point evaluation of log(1.0+x).
For more information, see:
Examples
Consider the query q83 in Example 9-52. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-53, the query returns the stream in Example 9-54.
Syntax
Purpose
LOG101 returns the base 10 logarithm of a double value as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#log10(double).
Examples
Consider the query q84 in Example 9-55. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-56, the query returns the stream in Example 9-57.
Example 9-55 LOG101 Function Query
<query id="q84"><![CDATA[
select log101(c2) from SFunc
]]></query>
Syntax
Purpose
LOG1P returns the natural logarithm of the sum of the double argument and 1 as a double.
Note that for small values x, the result of log1p(x) is much closer to the true result of ln(1 + x) than the floating-point evaluation of log(1.0+x).
For more information, see:
Examples
Consider the query q85 in Example 9-58. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-59, the query returns the stream in Example 9-60.
Syntax
Purpose
POW returns the value of the first double argument (the base) raised to the power of the second double argument (the exponent) as a double.
This function takes the following arguments:
double1: the base.
double2: the exponent.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#pow(double,%20double).
Examples
Consider the query q65 in Example 9-61. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-62, the query returns the stream in Example 9-63.
Syntax
Purpose
RINT returns the double value that is closest in value to the double argument and equals a mathematical integer. If two double values that are mathematical integers are equally close, the result is the integer value that is even.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#rint(double).
Examples
Consider the query q86 in Example 9-64. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-65, the query returns the stream in Example 9-66.
Syntax
Purpose
ROUND returns the closest integer to the float argument.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#round(float).
Examples
Consider the query q87 in Example 9-67. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-68, the query returns the stream in Example 9-69.
Syntax
Purpose
ROUND1 returns the closest integer to the float argument.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#round(float).
Examples
Consider the query q88 in Example 9-70. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-71, the query returns the stream in Example 9-72.
Example 9-70 ROUND1 Function Query
<query id="q88"><![CDATA[
select round1(c2) from SFunc
]]></query>
Syntax
Purpose
SIGNUM returns the signum function of the double argument as a double:
zero if the argument is zero
1.0 if the argument is greater than zero
-1.0 if the argument is less than zero
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#signum(double).
Examples
Consider the query q70 in Example 9-73. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-74, the query returns the stream in Example 9-75.
Example 9-73 SIGNUM Function Query
<query id="q70"><![CDATA[
select signum(c2) from SFunc
]]></query>
Syntax
Purpose
SIGNUM1 returns the signum function of the float argument as a float:
zero if the argument is zero
1.0 if the argument is greater than zero
-1.0 if the argument is less than zero
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#signum(float).
Examples
Consider the query q71 in Example 9-76. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-77, the query returns the relation in Example 9-78.
Example 9-76 SIGNUM1 Function Query
<query id="q71"><![CDATA[
select signum1(c2) from SFunc
]]></query>
Syntax
Purpose
SIN returns the trigonometric sine of a double angle as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#sin(double).
Examples
Consider the query q60 in Example 9-79. Given the data stream SFunc with schema (c1 integer, c2 float, c3 bigint) in Example 9-80, the query returns the stream in Example 9-81.
Syntax
Purpose
SINH returns the hyperbolic sine of a double value as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#sinh(double).
Examples
Consider the query q89 in Example 9-82. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-83, the query returns the stream in Example 9-84.
Syntax
Purpose
SQRT returns the correctly rounded positive square root of a double value as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#sqrt(double).
Examples
Consider the query q64 in Example 9-85. Given the data stream SFunc with schema (c1 integer, c2 float, c3 bigint) in Example 9-86, the query returns the stream in Example 9-87.
Syntax
Purpose
TAN returns the trigonometric tangent of a double angle as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#tan(double).
Examples
Consider the query q62 in Example 9-88. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-89, the query returns the stream in Example 9-90.
Syntax
Purpose
TANH returns the hyperbolic tangent of a double value as a double.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#tanh(double).
Examples
Consider the query q90 in Example 9-91. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-92, the query returns the stream in Example 9-93.
Syntax
Purpose
TODEGREES converts a double angle measured in radians to an approximately equivalent angle measured in degrees as a double.
The conversion from radians to degrees is generally inexact; do not expect COS(TORADIANS(90.0)) to exactly equal 0.0.
For more information, see:
Examples
Consider the query q91 in Example 9-94. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-95, the query returns the stream in Example 9-96.
Example 9-94 TODEGREES Function Query
<query id="q91"><![CDATA[
select toDegrees(c2) from SFunc
]]></query>
Syntax
Purpose
TORADIANS converts a double angle measured in degrees to an approximately equivalent angle measured in radians as a double.
For more information, see:
Examples
Consider the query q92 in Example 9-97. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-98, the query returns the stream in Example 9-99.
Example 9-97 TORADIANS Function Query
<query id="q92"><![CDATA[
select toRadians(c2) from SFunc
]]></query>
Syntax
Purpose
ULP returns the size of an ulp of the double argument as a double. In this case, an ulp of the argument value is the positive distance between this floating-point value and the double value next larger in magnitude.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#ulp(double).
Examples
Consider the query q93 in Example 9-100. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-101, the query returns the stream in Example 9-102.
Syntax
Purpose
ULP1 returns the size of an ulp of the float argument as a float. An ulp of a float value is the positive distance between this floating-point value and the float value next larger in magnitude.
For more information, see http://java.sun.com/javase/6/docs/api/java/lang/Math.html#ulp(float).
Examples
Consider the query q94 in Example 9-103. Given the data stream SFunc with schema (c1 integer, c2 double, c3 bigint) in Example 9-104, the query returns the relation in Example 9-105.
|
 Copyright © 2006, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|