Skip to content

Operation Support Matrix

Backends are shown in descending order of the number of supported operations.

Backends dask pandas postgres mysql duckdb clickhouse pyspark sqlite impala datafusion
API Coverage 234 (90%) 234 (90%) 213 (82%) 196 (75%) 172 (66%) 170 (65%) 153 (59%) 146 (56%) 142 (55%) 54 (21%)
Abs
Acos
Add
Alias
AnalyticVectorizedUDF
And
Any
Arbitrary
ArrayCollect
ArrayColumn
ArrayConcat
ArrayIndex
ArrayLength
ArrayRepeat
ArraySlice
Asin
Atan2
Atan
BaseConvert
BetweenTime
BitAnd
BitOr
BitXor
Bucket
CMSMedian
Capitalize
Cast
CategoryLabel
Ceil
Clip
Coalesce
Correlation
Cos
Cot
CountDistinct
Count
Covariance
CumeDist
CumulativeAll
CumulativeAny
CumulativeMax
CumulativeMean
CumulativeMin
CumulativeSum
DateAdd
DateDiff
DateFromYMD
DateSub
DateTruncate
Date
DayOfWeekIndex
DayOfWeekName
DecimalPrecision
DecimalScale
Degrees
DenseRank
E
ElementWiseVectorizedUDF
EndsWith
Equals
ExistsSubquery
Exp
ExtractDayOfYear
ExtractDay
ExtractEpochSeconds
ExtractHour
ExtractMillisecond
ExtractMinute
ExtractMonth
ExtractQuarter
ExtractSecond
ExtractWeekOfYear
ExtractYear
FindInSet
FirstValue
FloorDivide
Floor
GeoArea
GeoAsBinary
GeoAsEWKB
GeoAsEWKT
GeoAsText
GeoAzimuth
GeoBuffer
GeoCentroid
GeoContainsProperly
GeoContains
GeoCoveredBy
GeoCovers
GeoCrosses
GeoDFullyWithin
GeoDWithin
GeoDifference
GeoDisjoint
GeoDistance
GeoEndPoint
GeoEnvelope
GeoEquals
GeoGeometryN
GeoGeometryType
GeoIntersection
GeoIntersects
GeoIsValid
GeoLength
GeoLineLocatePoint
GeoLineMerge
GeoLineSubstring
GeoMaxDistance
GeoNPoints
GeoNRings
GeoOrderingEquals
GeoOverlaps
GeoPerimeter
GeoPointN
GeoPoint
GeoSRID
GeoSetSRID
GeoSimplify
GeoStartPoint
GeoTouches
GeoTransform
GeoUnaryUnion
GeoUnion
GeoWithin
GeoXMax
GeoXMin
GeoX
GeoYMax
GeoYMin
GeoY
GreaterEqual
Greater
Greatest
GroupConcat
HLLCardinality
HashBytes
Hash
Histogram
IdenticalTo
IfNull
IntervalAdd
IntervalFloorDivide
IntervalFromInteger
IntervalMultiply
IntervalSubtract
IsInf
IsNan
IsNull
LPad
LStrip
Lag
LastValue
Lead
Least
LessEqual
Less
Ln
Log10
Log2
Log
Lowercase
MapConcat
MapKeys
MapLength
MapValueForKey
MapValueOrDefaultForKey
MapValues
Max
Mean
MinRank
Min
Modulus
MultiQuantile
Multiply
NTile
Negate
NotAll
NotAny
NotContains
NotEquals
NotExistsSubquery
NotNull
Not
NthValue
NullIfZero
NullIf
NullLiteral
Or
ParseURL
PercentRank
Pi
Power
Quantile
RPad
RStrip
Radians
RandomScalar
ReductionVectorizedUDF
RegexExtract
RegexReplace
RegexSearch
Repeat
Reverse
Round
RowID
RowNumber
SearchedCase
Sign
SimpleCase
Sin
Sqrt
StandardDev
StartsWith
StrRight
Strftime
StringAscii
StringConcat
StringContains
StringFind
StringJoin
StringLength
StringReplace
StringSQLILike
StringSplit
StringToTimestamp
Strip
StructColumn
StructField
Substring
Subtract
Sum
SummaryFilter
TableArrayView
TableColumn
Tan
TimeAdd
TimeDiff
TimeFromHMS
TimeSub
TimeTruncate
Time
TimestampAdd
TimestampDiff
TimestampFromUNIX
TimestampFromYMDHMS
TimestampNow
TimestampSub
TimestampTruncate
TimestampUnary
ToIntervalUnit
Translate
TypeOf
Unnest
Uppercase
ValueList
Variance
Where
Window
Xor
ZeroIfNull

Last update: March 22, 2022