Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction to Oracle CQL
- 2 Basic Elements of Oracle CQL
- 3 Pseudocolumns
-
4
Operators
- 4.1 Introduction to Operators
- 4.2 Arithmetic Operators
- 4.3 Concatenation Operator
- 4.4 Alternation Operator
- 4.5 Range-Based Stream-to-Relation Window Operators
- 4.6 Tuple-Based Stream-to-Relation Window Operators
- 4.7 Partitioned Stream-to-Relation Window Operators
- 4.8 IStream Relation-to-Stream Operator
- 4.9 DStream Relation-to-Stream Operator
- 4.10 RStream Relation-to-Stream Operator
- 5 Expressions
- 6 Conditions
-
7
Common Oracle
CQL DDL Clauses
- 7.1 Introduction to Common Oracle CQL DDL Clauses
- 7.2 attr
- 7.3 attrspec
- 7.4 const_bigint
- 7.5 const_int
- 7.6 const_string
- 7.7 const_value
- 7.8 identifier
- 7.9 l-value
- 7.10 non_mt_arg_list
- 7.11 non_mt_attr_list
- 7.12 non_mt_attrname_list
- 7.13 non_mt_attrspec_list
- 7.14 non_mt_cond_list
- 7.15 out_of_line_constraint
- 7.16 param_list
- 7.17 query_ref
- 7.18 time_spec
- 8 Built-In Single-Row Functions
- 9 Built-In Aggregate Functions
-
10
Colt Single-Row
Functions
- 10.1 Introduction to Oracle CQLBuilt-In Single-Row Colt Functions
- 10.1 beta
- 10.2 beta1
- 10.3 betaComplemented
- 10.4 binomial
- 10.5 binomial1
- 10.6 binomial2
- 10.7 binomialComplemented
- 10.8 bitMaskWithBitsSetFromTo
- 10.9 ceil
- 10.10 chiSquare
- 10.11 chiSquareComplemented
- 10.12 errorFunction
- 10.13 errorFunctionComplemented
- 10.14 factorial
- 10.15 floor
- 10.16 gamma
- 10.17 gamma1
- 10.18 gammaComplemented
- 10.19 getSeedAtRowColumn
- 10.20 hash
- 10.21 hash1
- 10.22 hash2
- 10.23 hash3
- 10.24 i0
- 10.25 i0e
- 10.26 i1
- 10.27 i1e
- 10.28 incompleteBeta
- 10.29 incompleteGamma
- 10.30 incompleteGammaComplement
- 10.31 j0
- 10.32 j1
- 10.33 jn
- 10.34 k0
- 10.35 k0e
- 10.36 k1
- 10.37 k1e
- 10.38 kn
- 10.39 leastSignificantBit
- 10.40 log
- 10.41 log10
- 10.42 log2
- 10.43 logFactorial
- 10.44 logGamma
- 10.45 longFactorial
- 10.46 mostSignificantBit
- 10.47 negativeBinomial
- 10.48 negativeBinomialComplemented
- 10.49 normal
- 10.50 normal1
- 10.51 normalInverse
- 10.52 poisson
- 10.53 poissonComplemented
- 10.54 stirlingCorrection
- 10.55 studentT
- 10.56 studentTInverse
- 10.57 y0
- 10.58 y1
- 10.59 yn
-
11
Colt Aggregate
Functions
- 11.1 Introduction to Oracle CQL Built-In Aggregate Colt Functions
- 11.1 autoCorrelation
- 11.2 correlation
- 11.3 covariance
- 11.4 geometricMean
- 11.5 geometricMean1
- 11.6 harmonicMean
- 11.7 kurtosis
- 11.8 lag1
- 11.9 mean
- 11.10 meanDeviation
- 11.11 median
- 11.12 moment
- 11.13 pooledMean
- 11.14 pooledVariance
- 11.15 product
- 11.16 quantile
- 11.17 quantileInverse
- 11.18 rankInterpolated
- 11.19 rms
- 11.20 sampleKurtosis
- 11.21 sampleKurtosisStandardError
- 11.22 sampleSkew
- 11.23 sampleSkewStandardError
- 11.24 sampleVariance
- 11.25 skew
- 11.26 standardDeviation
- 11.27 standardError
- 11.28 sumOfInversions
- 11.29 sumOfLogarithms
- 11.30 sumOfPowerDeviations
- 11.31 sumOfPowers
- 11.32 sumOfSquaredDeviations
- 11.33 sumOfSquares
- 11.34 trimmedMean
- 11.35 variance
- 11.36 weightedMean
- 11.37 winsorizedMean
-
12
java.lang.Math Functions
- 12.1 Introduction to Oracle CQL Built-In java.lang.Math Functions
- 12.1 abs
- 12.2 abs1
- 12.3 abs2
- 12.4 abs3
- 12.5 acos
- 12.6 asin
- 12.7 atan
- 12.8 atan2
- 12.9 cbrt
- 12.10 ceil1
- 12.11 cos
- 12.12 cosh
- 12.13 exp
- 12.14 expm1
- 12.15 floor1
- 12.16 hypot
- 12.17 IEEEremainder
- 12.18 log1
- 12.19 log101
- 12.20 log1p
- 12.21 pow
- 12.22 rint
- 12.23 round
- 12.24 round1
- 12.25 signum
- 12.26 signum1
- 12.27 sin
- 12.28 sinh
- 12.29 sqrt
- 12.30 tan
- 12.31 tanh
- 12.32 todegrees
- 12.33 toradians
- 12.34 ulp
- 12.35 ulp1
-
13
Pattern Recognition
With MATCH_RECOGNIZE
-
13.1
Understanding Pattern Recognition With MATCH_RECOGNIZE
- 13.1.1 MATCH_RECOGNIZE and the WHERE Clause
- 13.1.2 Referencing Singleton and Group Matches
-
13.1.3
Referencing Aggregates
- 13.1.3.1 Running Aggregates and Final Aggregates
- 13.1.3.2 Operating on the Same Correlation Variable
- 13.1.3.3 Referencing Variables That Have not Been Matched Yet
- 13.1.3.4 Referencing Attributes not Qualified by Correlation Variable
- 13.1.3.5 Using count With *, identifier.*, and identifier.attr
- 13.1.3.6 Using first and last
- 13.1.4 Using prev
- 13.2 MEASURES Clause
- 13.3 PATTERN Clause
- 13.4 DEFINE Clause
- 13.5 PARTITION BY Clause
- 13.6 ALL MATCHES Clause
- 13.7 WITHIN Clause
- 13.8 DURATION Clause
- 13.9 INCLUDE TIMER EVENTS Clause
- 13.10 SUBSET Clause
- 13.11 MATCH_RECOGNIZE Examples
-
13.1
Understanding Pattern Recognition With MATCH_RECOGNIZE
- 14 Oracle CQL Statements