Supported MongoDB® Commands, Data Types, and Operators

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

$integral

$shift

$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

String Operators

Operator

Supported

$concat

$indexOfBytes

$indexOfCP

$trim

$ltrim

$rtrim

$regexFind

$regexFindAll

$rgexMatch

$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_META

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.batchSize()

cursor.close()

cursor.isClosed()

cursor.collation()

cursor.comment()

cursor.count()

cursor.explain()

cursor.forEach()

cursor.hasNext()

cursor.hint()

cursor.isExhausted()

cursor.itcount()

cursor.limit()

cursor.map()

cursor.maxScan()

cursor.maxTimeMS()

cursor.max()

cursor.min()

cursor.next()

cursor.noCursorTimeout()

cursor.objsLeftInBatch()

cursor.pretty()

cursor.readConcern()

cursor.readPref()

cursor.returnKey()

cursor.showRecordId()

cursor.size()

cursor.skip()

cursor.sort()

cursor.tailable()

cursor.toArray()

cursor.addOption()

cursor.allowDiskUse()

cursor.allowPartialResults()

cursor.maxAwaitTimeMS()

cursor.tryNext()

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

_isSelf

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: June 7, 2024

Was this article helpful?