Supported SQL Operators¶

This section documents all FuseCore SQL operator support status. Operators not yet supported will fall back to the original Spark execution engine.

Operator	Parameters	Support
BatchScan	Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
BroadcastExchange	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map unsupported types null
BroadcastHashJoin	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map unsupported types null
Coalesce	Input/Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
Expand	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time unsupported types calendar array struct map null
FileSourceScan (Parquet)	Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
FileSourceScan (JSON)	Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
FileSourceScan (ORC)	Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
Filter	Input/Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
Generate	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time array of atomic types unsupported types calendar array of non atomic types struct map null
HashAggregate	Input	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
HashAggregate	Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time struct unsupported types calendar array map null
ObjectHashAggregate	Input	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
ObjectHashAggregate	Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time struct unsupported types calendar array map null
Project	Input/Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
ShuffleExchange	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map unsupported types null
ShuffledHashJoin	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map unsupported types null
Sort	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map unsupported types null
SortAggregate	Input	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
SortAggregate	Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time struct unsupported types calendar array map null
SortMergeJoin	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map unsupported types null
SubqueryBroadcast	Input/Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
TakeOrderedAndProject	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time unsupported types calendar array struct map null
Union	Input/Output	Supported boolean byte short integer long float double decimal string binary date timestamp timestamp ntz calendar year month day time array struct map null
Window	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time unsupported types calendar array struct map null
WindowGroupLimit	Input/Output	Partially Supported supported types boolean byte short integer long float double decimal string binary date timestamp timestamp ntz year month day time unsupported types calendar array struct map null
AggregateInPandas	–	available soon
ArrowEvalPython	–	available soon
BroadcastNestedLoopJoin	–	available soon
CartesianProduct	–	available soon
CollectLimit	–	available soon
CollectMetrics	–	available soon
CollectTail	–	available soon
DataWritingCommand	–	available soon
Debug	–	available soon
FlatMapGroupsInPandas	–	available soon
GlobalLimit	–	available soon
InMemoryTableScan	–	available soon
LocalLimit	–	available soon
LocalTableScan	–	available soon
MapInPandas	–	available soon
Range	–	available soon
Sample	–	available soon
Subquery	–	available soon
WindowInPandas	–	available soon
WriteFiles	–	available soon

Last update: Sep 07, 2026