Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W  Y  

A

  • about queries 1
  • ABS function 1
  • ADD_ELEMENT function 1
  • addition operator 1
  • aggregation
    • function filters 1
    • functions 1
    • multi-level 1
    • with APPROXCOUNTDISTINCT 1
    • with COUNT 1
    • with COUNT_APPROX 1
    • with COUNTDISTINCT 1
    • with COUNTDISTINCTMEMBERS 1
  • APPROXCOUNTDISTINCT function 1
  • ARB function 1
  • arithmetic operators 1
  • AVG function 1

B

  • best practices
    • additional tips 1
    • controlling input size 1
    • defining constants 1
    • filtering as early as possible 1
  • BETWEEN operator 1
  • Boolean
    • literal handling 1
    • operators 1

C

  • calculate percent change over month 1
  • CARDINALITY function 1
  • CASE expression 1
  • case handling in EQL 1
  • CEIL function 1
  • characters in EQL 1
  • clauses
    • DEFINE 1
    • FROM 1
    • GROUP 1
    • GROUP BY 1
    • HAVING 1
    • JOIN 1
    • LET 1
    • ORDER BY 1
    • PAGE 1
    • RETURN 1
    • SELECT 1
    • WHERE 1
  • COALESCE expression 1
  • collections
    • in FROM clause 1
    • record sources 1
  • combining multiple sparse fields into one 1
  • commenting in EQL 1
  • CONCAT function 1
  • controlling input size 1
  • controlling join size 1
  • CORRELATION function 1
  • COS function 1
  • COUNT_APPROX function 1
  • COUNTDISTINCT function 1
  • COUNTDISTINCTMEMBERS function 1
  • COUNT function 1
  • CROSS JOIN 1
  • CUBE extension 1
  • cumulative sum 1
  • CURRENT_DATE function 1
  • CURRENT_TIMESTAMP function 1

D

  • data types 1
  • date and time values
    • constructing 1
    • using arithmetic operations on 1
  • DAY_OF_MONTH function 1
  • DAY_OF_WEEK function 1
  • DAY_OF_YEAR function 1
  • DEFINE clause 1
  • defining constants for best performance 1
  • DIFFERENCE function 1
  • DISTANCE function 1
  • division operator 1
  • double
    • data type 1
    • handling of precision 1
    • promotion from integer 1

E

  • EQL
    • case handling 1
    • characters 1
    • commenting 1
    • concepts 1
    • handling of inf results 1
    • handling of NaN results 1
    • handling of NULL results 1
    • inter-statement references 1
    • LOOKUP expressions 1
    • multi-level aggregation example 1
    • overview 1
    • processing order 1
    • reserved keywords 1
    • SQL comparison 1
    • syntax conventions 1
  • evaluation time and input size 1
  • EVERY function 1
  • existential quantifier 1
  • EXP function 1
  • expressions
    • CASE 1
    • COALESCE 1
    • GROUPING SETS 1
    • IN 1
    • in ORDER BY 1
    • LOOKUP 1
  • EXTRACT function 1

F

  • filtering
    • geocode 1
    • performance impact of 1
  • filters
    • per-aggregation 1
    • using results values as 1
  • FLOOR function 1
  • follow-on queries 1
  • FOREACH function 1
  • FROM_TZ function 1
  • FROM clause 1
  • FULL JOIN 1
  • functions
    • ABS 1
    • aggregation 1
    • APPROXCOUNTDISTINCT 1
    • ARB 1
    • arithmetic operators 1
    • AVG 1
    • CEIL 1
    • CONCAT 1
    • CORRELATION 1
    • COS 1
    • COUNT 1
    • COUNT_APPROX 1
    • COUNTDISTINCT 1
    • COUNTDISTINCTMEMBERS 1
    • CURRENT_DATE 1
    • CURRENT_TIMESTAMP 1
    • date and time 1
    • DAY_OF_MONTH 1
    • DAY_OF_WEEK 1
    • DAY_OF_YEAR 1
    • DISTANCE 1
    • EXP 1
    • EXTRACT 1
    • FLOOR 1
    • FROM_TZ 1
    • GROUPING 1
    • HOUR 1
    • JULIAN_DAY_NUMBER 1
    • LATITUDE 1
    • LN 1
    • LOG 1
    • LONGITUDE 1
    • MAX 1
    • MEDIAN 1
    • MILLISECOND 1
    • MIN 1
    • MINUTE 1
    • MOD 1
    • MONTH 1
    • numeric 1
    • PERCENTILE 1
    • POWER 1
    • QUARTER 1
    • RECORD_IN_FAST_SAMPLE 1
    • ROUND 1
    • SECOND 1
    • SIGN 1
    • SIN 1
    • SQRT 1
    • STDDEV 1
    • string 1
    • STRING_JOIN 1
    • SUBSTR 1
    • SUM 1
    • SYSDATE 1
    • SYSTIMESTAMP 1
    • TAN 1
    • TO_DATETIME 1
    • TO_DOUBLE 1
    • TO_DURATION 1 , 2
    • TO_GEOCODE 1
    • TO_INTEGER 1
    • TO_STRING 1
    • TO_TIME 1
    • TO_TZ 1
    • TRUNC 1 , 2
    • VARIANCE 1
    • WEEK 1
    • YEAR 1

G

  • geocode
    • data type 1
    • filtering 1
    • sorting by 1
  • GROUP BY clause
    • CUBE extension 1
    • MEMBERS extension 1
    • ROLLUP extension 1
  • GROUP clause 1
  • grouping
    • by range buckets 1
    • data into quartiles 1
  • GROUPING function 1
  • GROUPING SETS expression 1

H

  • HAS_REFINEMENTS 1
  • HAVING clause 1
  • HOUR function 1

I

  • identifier handling 1
  • important concepts 1
  • IN expression 1
  • inf, EQL handling of 1
  • INNER JOIN 1
  • integer promotion to double 1
  • INTERSECTION function 1
  • inter-statement references, EQL 1
  • IS_EMPTY function 1
  • IS_MEMBER_OF function 1
  • IS_NOT_EMPTY function 1
  • IS EMPTY function 1
  • IS NOT EMPTY function 1

J

  • JOIN clause 1
  • joining data from different types of records 1
  • join size constraints 1
  • JULIAN_DAY_NUMBER function 1

L

  • LATITUDE function 1
  • LEFT JOIN 1
  • LET clause 1
  • linear regression in EQL 1
  • literals 1
  • LN function 1
  • LOG function 1
  • LONGITUDE function 1
  • LOOKUP expression 1

M

  • manipulating records in a dynamically computed range value 1
  • MAX function 1
  • MEDIAN function 1
  • MEMBERS extension 1
  • MILLISECOND function 1
  • MIN function 1
  • MINUTE function 1
  • MOD function 1
  • MONTH function 1
  • multi-level aggregation example 1
  • multiplication operator 1

N

  • NaN, EQL handling of 1
  • NULL values
    • and sets 1
    • EQL handling of 1
  • numeric
    • functions 1
    • literal handling 1

O

  • operations, date and time 1
  • operators
    • arithmetic 1
    • Boolean 1
    • precedence order 1
  • ORDER BY clause 1
  • order of processing in EQL 1
  • overview of queries 1

P

  • PAGE clause
    • PERCENT modifier 1
    • Top-K queries 1
  • PERCENTILE function 1
  • PERCENT modifier 1
  • pie chart segmentation with IN filters 1
  • POWER function 1
  • precedence rules for operators 1

Q

  • QUARTER function 1
  • queries 1
  • query by age 1
  • query processing order 1

R

  • RECORD_IN_FAST_SAMPLE function 1
  • re-normalization 1
  • reserved keywords 1
  • result values used as filters 1
  • RETURN clause 1
  • RIGHT JOIN 1
  • ROLLUP extension 1
  • ROUND function 1
  • running sum 1

S

  • SATISFIES function 1
  • SECOND function 1
  • SELECT clause 1
  • SET_INTERSECTIONS function 1
  • SET_UNIONS function 1
  • SET function 1
  • set functions
    • ADD_ELEMENT 1
    • APPROXCOUNTDISTINCT 1
    • ARB 1
    • CARDINALITY 1
    • COUNT 1
    • COUNT_APPROX 1
    • COUNTDISTINCT 1
    • COUNTDISTINCTMEMBERS 1
    • DIFFERENCE 1
    • EVERY 1
    • FOREACH 1
    • INTERSECTION 1
    • IS_EMPTY 1
    • IS_MEMBER_OF 1
    • IS_NOT_EMPTY 1
    • IS EMPTY 1
    • IS NOT EMPTY 1
    • SET 1
    • SET_INTERSECTIONS 1
    • SET_UNIONS 1
    • SINGLETON 1
    • SOME 1
    • SUBSET 1
    • TRUNCATE_SET 1
    • UNION 1
  • sets
    • constructing from single-assign attributes 1
    • constructor 1
    • data types 1
    • grouping by 1
    • sort order 1
  • SIGN function 1
  • SIN function 1
  • SINGLETON function 1
  • SOME function 1
  • SQL comparison 1
  • SQRT function 1
  • state names in FROM clause 1
  • STDDEV function 1
  • string
    • data type 1
    • literal handling 1
    • sort order 1
  • STRING_JOIN function 1
  • structured literal handling 1
  • SUBSET function 1
  • SUBSTR function 1
  • subtraction operator 1
  • SUM function 1
  • syntax conventions 1
  • SYSDATE function 1
  • SYSTIMESTAMP function 1

T

  • TAN function 1
  • terminology, EQL 1
  • TO_DATETIME function 1
  • TO_DOUBLE function 1
  • TO_DURATION function 1 , 2
  • TO_GEOCODE function 1
  • TO_INTEGER function 1
  • TO_STRING function 1
  • TO_TIME function 1
  • TO_TZ function 1
  • Top-K queries 1
  • TRUNCATE_SET function 1
  • TRUNC function 1 , 2

U

  • UNION function 1
  • universal quantifier 1
  • use cases
    • calculate percent change over month 1
    • combining multiple sparse fields into 1
    • grouping by range buckets 1
    • grouping data into quartiles 1
    • joining data from different types of 1
    • linear regression 1
    • manipulating records in a dynamically computed 1
    • pie chart segmentation 1
    • query by age 1
    • re-normalization 1
    • running sum 1
  • using arithmetic operations on date and time values 1

V

  • VARIANCE function 1

W

  • WEEK function 1
  • WHERE clause 1
  • WITH UNPAGED COUNT modifier for RETURN 1

Y

  • YEAR function 1