Supported MongoDB® Commands, Data Types, and Operators
On this page
The following tables reflect which MongoDB® commands, data types, and operators are supported by SingleStore Kai.
Query and Projection Operators
Array Operators
|
Operator |
Supported |
|---|---|
|
$all |
✔ |
|
$elemMatch |
✔ |
|
$size |
✔ |
Bitwise Operators
|
Operator |
Supported |
|---|---|
|
$bitsAllSet |
✔ |
|
$bitsAnySet |
✔ |
|
$bitsAllClear |
✔ |
|
$bitsAnyClear |
✔ |
Comment Operator
|
Operator |
Supported |
|---|---|
|
$comment |
✔ |
Comparison Operators
|
Operator |
Supported |
|---|---|
|
$eq |
✔ |
|
$gt |
✔ |
|
$gte |
✔ |
|
$lt |
✔ |
|
$lte |
✔ |
|
$ne |
✔ |
|
$in |
✔ |
|
$nin |
✔ |
Element Operators
|
Operator |
Supported |
|---|---|
|
$exists |
✔ |
|
$type |
✔ |
Evaluation Query Operators
|
Operator |
Supported |
|---|---|
|
$expr |
✔ |
|
$jsonSchema | |
|
$mod |
✔ |
|
$regex |
✔ |
|
$text |
✔ |
|
$where |
Logical Operators
|
Operator |
Supported |
|---|---|
|
$or |
✔ |
|
$and |
✔ |
|
$not |
✔ |
|
$nor |
✔ |
Projection Operators
|
Operator |
Supported |
|---|---|
|
$ |
✔ |
|
$elemMatch |
✔ |
|
$meta | |
|
$slice |
✔ |
Update Operators
Update Array Operators
|
Operator |
Supported |
|---|---|
|
$ |
✔ |
|
$[] |
✔ |
|
$[<identifier>] |
✔ |
|
$addToSet |
✔ |
|
$pop |
✔ |
|
$pullAll |
✔ |
|
$pull |
✔ |
|
$push |
✔ |
|
$pushAll |
Update Bitwise Operators
|
Operator |
Supported |
|---|---|
|
$bit |
✔ |
Update Field Operators
|
Operator |
Supported |
|---|---|
|
$inc |
✔ |
|
$mul |
✔ |
|
$rename |
✔ |
|
$setOnInsert |
✔ |
|
$set |
✔ |
|
$unset |
✔ |
|
$min |
✔ |
|
$max |
✔ |
|
$currentDate |
✔ |
Update Modifiers
|
Operator |
Supported |
|---|---|
|
$each |
✔ |
|
$slice |
✔ |
|
$sort |
✔ |
|
$position |
✔ |
Aggregation Pipeline Operators
Aggregation Accumulator Expressions
|
Operator |
Supported |
|---|---|
|
$sum |
✔ |
|
$integral |
✔ |
|
$shift |
✔ |
|
$avg |
✔ |
|
$first |
✔ |
|
$last |
✔ |
|
$max |
✔ |
|
$min |
✔ |
|
$push |
✔ |
|
$addToSet |
✔ |
|
$stdDevPop |
✔ |
|
$stdDevSamp |
✔ |
|
$accumulator | |
|
$firstN |
✔ |
|
$bottom |
✔ |
|
$bottomN |
✔ |
|
$lastN |
✔ |
|
$maxN | |
|
$mergeObjects |
✔ |
|
$top |
✔ |
|
$topN |
✔ |
Arithmetic Operators
|
Operator |
Supported |
|---|---|
|
$abs |
✔ |
|
$add |
✔ |
|
$ceil |
✔ |
|
$divide |
✔ |
|
$exp |
✔ |
|
$floor |
✔ |
|
$ln |
✔ |
|
$log |
✔ |
|
$log10 |
✔ |
|
$mod |
✔ |
|
$multiply |
✔ |
|
$pow |
✔ |
|
$sqrt |
✔ |
|
$subtract |
✔ |
|
$rand |
✔ |
|
$trunc |
✔ |
|
$round |
✔ |
Array Operators
|
Operator |
Supported |
|---|---|
|
$arrayElemAt |
✔ |
|
$arrayToObject |
✔ |
|
$concatArrays |
✔ |
|
$filter |
✔ |
|
$indexOfArray |
✔ |
|
$isArray |
✔ |
|
$objectToArray |
✔ |
|
$range |
✔ |
|
$reverseArray |
✔ |
|
$reduce |
✔ |
|
$size |
✔ |
|
$slice |
✔ |
|
$zip |
✔ |
|
$in |
✔ |
|
$count |
✔ |
|
$first |
✔ |
|
$firstN |
✔ |
|
$sortArray | |
|
$last |
✔ |
|
$lastN |
✔ |
|
$map |
✔ |
|
$maxN | |
|
$minN |
Boolean Operators
|
Operator |
Supported |
|---|---|
|
$and |
✔ |
|
$or |
✔ |
|
$not |
✔ |
Comparison Operators
|
Operator |
Supported |
|---|---|
|
$cmp |
✔ |
|
$eq |
✔ |
|
$gt |
✔ |
|
$gte |
✔ |
|
$lt |
✔ |
|
$lte |
✔ |
|
$ne |
✔ |
|
$in |
✔ |
|
$nin |
✔ |
|
$sortArray |
Conditional Expression Operators
|
Operator |
Supported |
|---|---|
|
$cond |
✔ |
|
$ifNull |
✔ |
|
$switch |
✔ |
Custom Aggregation Expression Operators
|
Operator |
Supported |
|---|---|
|
$accumulator | |
|
$function |
Data Size Operators
|
Operator |
Supported |
|---|---|
|
$binarySize |
✔ |
|
$bsonSize |
✔ |
Data Type Operators
|
Operator |
Supported |
|---|---|
|
$type |
✔ |
|
$isNumber |
✔ |
Date Operators
|
Operator |
Supported |
|---|---|
|
$dayOfWeek |
✔ |
|
$dayOfMonth |
✔ |
|
$dayOfYear |
✔ |
|
$year |
✔ |
|
$month |
✔ |
|
$week |
✔ |
|
$hour |
✔ |
|
$minute |
✔ |
|
$second |
✔ |
|
$millisecond |
✔ |
|
$dateToString |
✔ |
|
$isoDayOfWeek |
✔ |
|
$isoWeek |
✔ |
|
$dateFromParts |
✔ |
|
$dateToParts |
✔ |
|
$dateFromString |
✔ |
|
$isoWeekYear |
✔ |
|
$dateAdd |
✔ |
|
$dateDiff |
✔ |
|
$dateSubtract |
✔ |
|
$dateTrunc |
✔ |
Literal Operator
|
Operator |
Supported |
|---|---|
|
$literal |
✔ |
Object Expression Operators
|
Operator |
Supported |
|---|---|
|
$mergeObjects |
✔ |
|
$objectToArray |
✔ |
|
$setField |
✔ |
|
$unsetField |
✔ |
Natural Operator
|
Operator |
Supported |
|---|---|
|
$natural |
Set Operators
|
Operator |
Supported |
|---|---|
|
$setEquals |
✔ |
|
$setIntersection |
✔ |
|
$setUnion |
✔ |
|
$setDifference |
✔ |
|
$setIsSubset |
✔ |
|
$anyElementTrue |
✔ |
|
$allElementsTrue |
✔ |
Stage Operators
|
Operator |
Supported |
|---|---|
|
$collStats |
✔ |
|
$project |
✔ |
|
$match |
✔ |
|
$redact | |
|
$limit |
✔ |
|
$skip |
✔ |
|
$unwind |
✔ |
|
$group |
✔ |
|
$sample |
✔ |
|
$sort |
✔ |
|
$geoNear | |
|
$lookup |
✔ |
|
$merge |
✔ |
|
$out |
✔ |
|
$indexStats |
✔ |
|
$setWindowFields |
✔ |
|
$facet |
✔ |
|
$bucket | |
|
$bucketAuto | |
|
$sortByCount |
✔ |
|
$addFields |
✔ |
|
$replaceRoot |
✔ |
|
$count |
✔ |
|
$currentOp | |
|
$listLocalSessions | |
|
$listSessions | |
|
$graphLookup |
✔ |
|
$changeStream |
✔ |
|
$densify | |
|
$documents |
✔ |
|
$fill | |
|
$unionWith |
✔ |
|
$planCacheStats | |
|
$unset |
✔ |
|
$replaceWith |
✔ |
|
$search |
✔ |
|
$searchMeta | |
|
$vectorSearch |
✔ |
String Operators
|
Operator |
Supported |
|---|---|
|
$concat |
✔ |
|
$indexOfBytes |
✔ |
|
$indexOfCP |
✔ |
|
$trim |
✔ |
|
$ltrim |
✔ |
|
$rtrim |
✔ |
|
$regexFind | |
|
$regexFindAll | |
|
$regexMatch |
✔ |
|
$replaceOne |
✔ |
|
$replaceAll |
✔ |
|
$split |
✔ |
|
$strcasecmp |
✔ |
|
$strLenBytes |
✔ |
|
$strLenCP |
✔ |
|
$substr |
✔ |
|
$substrBytes |
✔ |
|
$substrCP |
✔ |
|
$toString |
✔ |
|
$toLower |
✔ |
|
$toUpper |
✔ |
|
$trim |
✔ |
System Variables
|
Variable |
Supported |
|---|---|
|
$$CURRENT |
✔ |
|
$$CLUSTERTIME | |
|
$$DESCEND | |
|
$$KEEP | |
|
$$NOW | |
|
$$PRUNE | |
|
$$REMOVE |
✔ |
|
$$ROOT |
✔ |
|
$$SEARCH_ |
Text Search Operator
|
Operator |
Supported |
|---|---|
|
$meta |
Timestamp Expression Operators
|
Operator |
Supported |
|---|---|
|
$tsIncrement |
✔ |
|
$tsSecond |
✔ |
Trigonometry Expression Operators
|
Operator |
Supported |
|---|---|
|
$sin |
✔ |
|
$cos |
✔ |
|
$tan |
✔ |
|
$asin |
✔ |
|
$acos |
✔ |
|
$atan |
✔ |
|
$atan2 | |
|
$asinh | |
|
$acosh | |
|
$atanh | |
|
$sinh | |
|
$cosh | |
|
$tanh | |
|
$degreesToRadians |
✔ |
|
$radiansToDegrees |
✔ |
Type Conversion Operators
|
Operator |
Supported |
|---|---|
|
$convert |
✔ |
|
$toBool |
✔ |
|
$toDate |
✔ |
|
$toDecimal |
✔ |
|
$toDouble |
✔ |
|
$toInt |
✔ |
|
$toLong |
✔ |
|
$toObjectId |
✔ |
|
$toString |
✔ |
Variable Operators
|
Operator |
Supported |
|---|---|
|
$map |
✔ |
|
$let |
✔ |
Miscellaneous Operators
|
Operator |
Supported |
|---|---|
|
$denseRank |
✔ |
|
$documentNumber |
✔ |
|
$getField |
✔ |
|
$rand |
✔ |
|
$rank |
✔ |
|
$sampleRate |
✔ |
Data Types
|
Data Type |
Supported |
|---|---|
|
Double |
✔ |
|
String |
✔ |
|
Object |
✔ |
|
Array |
✔ |
|
Binary Data |
✔ |
|
ObjectId |
✔ |
|
Boolean |
✔ |
|
Date |
✔ |
|
Null |
✔ |
|
32-bit Integer (int) |
✔ |
|
Timestamp |
✔ |
|
64-bit Integer (long) |
✔ |
|
MinKey |
✔ |
|
MaxKey |
✔ |
|
Decimal128 |
✔ |
|
Regular Expression |
✔ |
|
JavaScript |
✔ |
|
JavaScript (with scope) |
✔ |
|
Undefined |
✔ |
|
Symbol |
✔ |
|
DBPointer |
✔ |
Indexes and Index Properties
Indexes
|
Property |
Supported |
|---|---|
|
Single Field Index |
✔ |
|
Compound Index |
✔ |
|
Multikey Index |
✔ |
|
Text Index | |
|
Wildcard Indexes | |
|
2dsphere | |
|
2d Index | |
|
GeoHaystackIndexes | |
|
Hashed Index |
Index Properties
|
Property |
Supported |
|---|---|
|
TTL | |
|
Unique |
✔ |
|
Partial | |
|
Case Insensitive | |
|
Hidden | |
|
Sparse | |
|
Background |
Cursor Methods
|
Method |
Supported |
|---|---|
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. | |
|
cursor. | |
|
cursor. | |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. | |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. |
✔ |
|
cursor. | |
|
cursor. | |
|
cursor. | |
|
cursor. | |
|
cursor. |
Database Commands
Administrative Commands
|
Command |
Supported |
|---|---|
|
Capped Collections | |
|
cloneCollectionAsCapped | |
|
collMod | |
|
collMod: expireAfterSeconds | |
|
convertToCapped | |
|
copydb | |
|
create |
✔ |
|
createView | |
|
createIndexes |
✔ |
|
currentOp |
✔ |
|
drop |
✔ |
|
dropDatabase |
✔ |
|
dropIndexes |
✔ |
|
filemd5 | |
|
killCursors |
✔ |
|
killOp | |
|
listCollections |
✔ |
|
listDatabases |
✔ |
|
listIndexes |
✔ |
|
reIndex | |
|
renameCollection | |
|
fsync | |
|
fsyncUnlock | |
|
getDefaultRWConcern | |
|
getAudtifConfig | |
|
getClusterParameter | |
|
getParameter | |
|
logRotate | |
|
rotateCertificates | |
|
setFeatureCompatibilityVersion | |
|
setIndexCommitQuorum | |
|
setClusterParameter | |
|
setParameter | |
|
setDefaultRWConcern | |
|
shutdown |
Aggregation Commands
|
Command |
Supported |
|---|---|
|
aggregate |
✔ |
|
count |
✔ |
|
distinct |
✔ |
|
mapReduce |
Authentication Commands
|
Command |
Supported |
|---|---|
|
authenticate |
✔ |
|
getnonce | |
|
logout |
Diagnostic Commands
|
Command |
Supported |
|---|---|
|
buildInfo |
✔ |
|
collStats |
✔ |
|
connPoolStats | |
|
connectionStatus |
✔ |
|
dataSize | |
|
dbHash | |
|
dbStats |
✔ |
|
explain |
✔ |
|
explain: executionStats |
✔ |
|
features | |
|
getCmdLineOpts | |
|
getLog | |
|
hostInfo | |
|
listCommands | |
|
ping |
✔ |
|
profile | |
|
serverStatus | |
|
shardConnPoolStats |
✔ |
|
top | |
|
validate | |
|
validateDBMetadata | |
|
whatsmyuri | |
|
driverOIDTest | |
|
_ | |
|
lockinfo | |
|
netstat |
Query and Write Operations
|
Operation |
Supported |
|---|---|
|
delete |
✔ |
|
find |
✔ |
|
findAndModify |
✔ |
|
getLastError | |
|
getMore |
✔ |
|
getPrevError | |
|
insert |
✔ |
|
parallelCollectionScan | |
|
resetError | |
|
update |
✔ |
|
Change streams | |
|
GridFS |
✔ |
Role Management Commands
|
Command |
Supported |
|---|---|
|
createRole | |
|
dropRole | |
|
dropAllRolesFromDatabase | |
|
grantPrivilegesToRole | |
|
grantRolesToRole | |
|
invalidateUserCache | |
|
revokePrivilegesFromRole | |
|
revokeRolesFromRole | |
|
updateRole | |
|
rolesInfo |
Sharding Commands
|
Command |
Supported |
|---|---|
|
abortReshardCollection | |
|
addShard | |
|
addShardToZone | |
|
balancerCollectionStatus | |
|
balancerStart | |
|
balancerStatus | |
|
balancerStop | |
|
checkShardingIndex | |
|
clearJumboFlag | |
|
cleanupOrphaned | |
|
cleanupReshardCollection | |
|
commitReshardCollection | |
|
configureCollectionBalancing | |
|
enableSharding | |
|
flushRouterConfig | |
|
getShardMap | |
|
getShardVersion | |
|
isdbgrid | |
|
listShards | |
|
medianKey | |
|
moveChunk | |
|
movePrimary | |
|
moveRange | |
|
mergeChunks | |
|
refineCollectionShardKey | |
|
removeShard | |
|
removeShardFromZone | |
|
reshardCollection | |
|
setAllowMigrations | |
|
setShardVersion | |
|
shardCollection |
✔ |
|
shardingState | |
|
split | |
|
splitVector | |
|
unsetSharding | |
|
updateZoneKeyRange |
Session Commands
|
Command |
Supported |
|---|---|
|
abortTransaction |
✔ |
|
commitTransaction |
✔ |
|
endSessions |
✔ |
|
killAllSessions | |
|
killAllSessionsByPattern | |
|
killSessions | |
|
refreshSessions | |
|
startSession |
User Management Commands
|
Command |
Supported |
|---|---|
|
createUser | |
|
dropAllUsersFromDatabase | |
|
dropUser | |
|
grantRolesToUser | |
|
revokeRolesFromUser | |
|
updateUser | |
|
userInfo |
Last modified: August 25, 2025