Here you can find a list of available Virtual Schema capabilities.
AGGREGATE_GROUP_BY_COLUMNAGGREGATE_GROUP_BY_EXPRESSIONAGGREGATE_GROUP_BY_TUPLEAGGREGATE_HAVINGAGGREGATE_SINGLE_GROUPFILTER_EXPRESSIONSJOINJOIN_CONDITION_ALLJOIN_CONDITION_EQUIJOIN_TYPE_INNERJOIN_TYPE_FULL_OUTERJOIN_TYPE_LEFT_OUTERJOIN_TYPE_RIGHT_OUTERLIMITLIMIT_WITH_OFFSETORDER_BY_COLUMNORDER_BY_EXPRESSIONSELECTLIST_EXPRESSIONSSELECTLIST_PROJECTION
LITERAL_BOOLLITERAL_DATELITERAL_DOUBLELITERAL_EXACTNUMERICLITERAL_INTERVALLITERAL_NULLLITERAL_STRINGLITERAL_TIMESTAMPLITERAL_TIMESTAMP_UTC
Literal Capabilities in the code
FN_PRED_ANDFN_PRED_BETWEENFN_PRED_EQUALFN_PRED_IN_CONSTLISTFN_PRED_IS_JSONFN_PRED_IS_NOT_JSONFN_PRED_IS_NOT_NULLFN_PRED_IS_NULLFN_PRED_LESSFN_PRED_LESSEQUALFN_PRED_LIKEFN_PRED_LIKE_ESCAPEFN_PRED_NOTFN_PRED_NOTEQUALFN_PRED_REGEXP_LIKEFN_PRED_OR
Predicate Capabilities in the code
FN_ABSFN_ACOSFN_ADDFN_ADD_DAYSFN_ADD_HOURSFN_ADD_MINUTESFN_ADD_MONTHSFN_ADD_SECONDSFN_ADD_WEEKSFN_ADD_YEARSFN_ASCIIFN_ASINFN_ATANFN_ATAN2FN_BIT_ANDFN_BIT_LROTATEFN_BIT_LSHIFTFN_BIT_CHECKFN_BIT_LENGTHFN_BIT_NOTFN_BIT_ORFN_BIT_RROTATEFN_BIT_RSHIFTFN_BIT_SETFN_BIT_TO_NUMFN_BIT_XORFN_CASEFN_CASTFN_CEILFN_CHRFN_COLOGNE_PHONETICFN_COSFN_COSHFN_CONCATFN_CONVERT_TZFN_COTFN_CURRENT_CLUSTERFN_CURRENT_DATEFN_CURRENT_SCHEMAFN_CURRENT_SESSIONFN_CURRENT_STATEMENTFN_CURRENT_TIMESTAMPFN_CURRENT_USERFN_DATE_TRUNCFN_DAYFN_DAYS_BETWEENFN_DBTIMEZONEFN_DEGREESFN_DIVFN_DUMPFN_EDIT_DISTANCEFN_EXPFN_EXTRACTFN_FLOAT_DIVFN_FLOORFN_FROM_POSIX_TIMEFN_GREATESTFN_HASH_MD5FN_HASH_SHA1FN_HASH_SHA256FN_HASH_SHA512FN_HASH_TIGERFN_HASHTYPE_MD5FN_HASHTYPE_SHA1FN_HASHTYPE_SHA256FN_HASHTYPE_SHA512FN_HASHTYPE_TIGERFN_HOURFN_HOURS_BETWEENFN_INITCAPFN_INSERTFN_INSTRFN_IS_BOOLEANFN_IS_DATEFN_IS_DSINTERVALFN_IS_NUMBERFN_IS_TIMESTAMPFN_IS_YMINTERVALFN_JSON_VALUEFN_LEASTFN_LENGTHFN_LNFN_LPADFN_LOCALTIMESTAMPFN_LOCATEFN_LOGFN_LOWERFN_LTRIMFN_MINUTEFN_MINUTES_BETWEENFN_MIN_SCALEFN_MODFN_MONTHFN_MONTHS_BETWEENFN_MULTFN_NEGFN_NULLIFZEROFN_NUMTODSINTERVALFN_NUMTOYMINTERVALFN_OCTET_LENGTHFN_POSIX_TIMEFN_POWERFN_RADIANSFN_RANDFN_REGEXP_INSTRFN_REGEXP_REPLACEFN_REGEXP_SUBSTRFN_REPEATFN_REPLACEFN_REVERSEFN_RIGHTFN_ROUNDFN_RPADFN_RTRIMFN_SECONDFN_SECONDS_BETWEENFN_SESSIONTIMEZONEFN_SESSION_PARAMETERFN_SIGNFN_SINFN_SINHFN_SOUNDEXFN_SPACEFN_SQRTFN_ST_AREAFN_ST_BOUNDARYFN_ST_BUFFERFN_ST_CENTROIDFN_ST_CONTAINSFN_ST_CONVEXHULLFN_ST_CROSSESFN_ST_DIFFERENCEFN_ST_DIMENSIONFN_ST_DISJOINTFN_ST_DISTANCEFN_ST_ENDPOINTFN_ST_ENVELOPEFN_ST_EQUALSFN_ST_EXTERIORRINGFN_ST_FORCE2DFN_ST_GEOMETRYNFN_ST_GEOMETRYTYPEFN_ST_INTERIORRINGNFN_ST_INTERSECTIONFN_ST_INTERSECTSFN_ST_ISCLOSEDFN_ST_ISEMPTYFN_ST_ISRINGFN_ST_ISSIMPLEFN_ST_LENGTHFN_ST_NUMGEOMETRIESFN_ST_NUMINTERIORRINGSFN_ST_NUMPOINTSFN_ST_OVERLAPSFN_ST_POINTNFN_ST_SETSRIDFN_ST_STARTPOINTFN_ST_SYMDIFFERENCEFN_ST_TOUCHESFN_ST_TRANSFORMFN_ST_UNIONFN_ST_WITHINFN_ST_XFN_ST_YFN_SUBSTRFN_SUBFN_SYS_GUIDFN_SYSDATEFN_SYSTIMESTAMPFN_TANFN_TANHFN_TO_CHARFN_TO_DATEFN_TO_DSINTERVALFN_TO_NUMBERFN_TO_TIMESTAMPFN_TO_YMINTERVALFN_TRANSLATEFN_TRIMFN_TRUNCFN_WIDTH_BUCKETFN_TYPEOFFN_UNICODEFN_UNICODECHRFN_UPPERFN_WEEKFN_YEARFN_YEARS_BETWEENFN_ZEROIFNULL
Scalar Function Capabilities in the code
FN_AGG_APPROXIMATE_COUNT_DISTINCTFN_AGG_AVGFN_AGG_AVG_DISTINCTFN_AGG_COUNTFN_AGG_COUNT_DISTINCTFN_AGG_COUNT_STARFN_AGG_COUNT_TUPLEFN_AGG_EVERYFN_AGG_FIRST_VALUEFN_AGG_GROUP_CONCATFN_AGG_GROUP_CONCAT_DISTINCTFN_AGG_GROUP_CONCAT_ORDER_BYFN_AGG_GROUP_CONCAT_SEPARATORFN_AGG_LAST_VALUEFN_AGG_LISTAGGFN_AGG_LISTAGG_DISTINCTFN_AGG_LISTAGG_ON_OVERFLOW_ERRORFN_AGG_LISTAGG_ON_OVERFLOW_TRUNCATEFN_AGG_LISTAGG_ORDER_BYFN_AGG_LISTAGG_SEPARATORFN_AGG_MAXFN_AGG_MEDIANFN_AGG_MINFN_AGG_MULFN_AGG_MUL_DISTINCTFN_AGG_SOMEFN_AGG_STDDEVFN_AGG_STDDEV_DISTINCTFN_AGG_STDDEV_POPFN_AGG_STDDEV_POP_DISTINCTFN_AGG_STDDEV_SAMPFN_AGG_STDDEV_SAMP_DISTINCTFN_AGG_ST_INTERSECTIONFN_AGG_ST_UNIONFN_AGG_SUMFN_AGG_SUM_DISTINCTFN_AGG_VARIANCEFN_AGG_VARIANCE_DISTINCTFN_AGG_VAR_POPFN_AGG_VAR_POP_DISTINCTFN_AGG_VAR_SAMPFN_AGG_VAR_SAMP_DISTINCT
Aggregate Function Capabilities in the code
Note that there are capabilities for functions that serve both as a scalar function and an aggregate function. While that sounds counter-intuitive at first, let's look at the examples.
Some geometric functions can work on individual geometric objects or on collections of those objects.
ST_INTERSECTION serves as a scalar function when supplied with two geometric objects as parameters and as an aggregation when supplied with a single collection parameter. The same applies to ST_UNION.
Virtual Schema support is consequently controlled by the capabilities FN_AGG_ST_INTERSECTION, FN_AGG_ST_UNION, FN_ST_INTERSECTION and FN_ST_UNION
See also: "Geospatial Data" in the Exasol online handbook
The following capabilities were deprecated:
| Deprecated Capability | Superseded by | Since Database version |
|---|---|---|
FN_AGG_GEO_INTERSECTION_AGGREGATE |
FN_AGG_ST_INTERSECTION_AGGREGATE |
7.1.alpha1 |
FN_AGG_GEO_UNION_AGGREGATE |
FN_AGG_ST_UNION_AGGREGATE |
7.1.alpha1 |