Amazon DocumentDB
Developer Guide

Aggregation Pipeline Operators

Stage Operators

Operator Supported

$collStats

No

$project

Yes

$match

Yes

$redact

Yes

$limit

Yes

$skip

Yes

$unwind

Yes

$group

Yes

$sample

Yes

$sort

Yes

$geoNear

No

$lookup

No

$out

No

$indexStats

Yes

$facet

No

$bucket

No

$bucketAuto

No

$sortByCount

No

$addFields

No

$replaceRoot

No

$count

Yes

$currentOp

Yes

$listLocalSessions

No

$listSessions

No

$graphLookup

No

Boolean Operators

Operator Supported

$and

Yes

$or

Yes

$not

Yes

Set Operators

Operator Supported

$setEquals

No

$setIntersection

No

$setUnion

No

$setDifference

No

$setIsSubset

No

$anyElementTrue

No

$allElementsTrue

No

Comparison Operators

Operator Supported

$cmp

Yes

$eq

Yes

$gt

Yes

$gte

Yes

$lt

Yes

$lte

Yes

$ne

Yes

Arithmetic Operators

Command Supported

$abs

Yes

$add

Yes

$ceil

No

$divide

Yes

$exp

No

$floor

No

$ln

No

$log

No

$log10

No

$mod

No

$multiply

Yes

$pow

No

$sqrt

No

$subtract

Yes

$trunc

No

String Operators

Operator Supported

$concat

Yes

$indexOfBytes

Yes

$indexOfCP

Yes

$split

Yes

$strcasecmp

Yes

$strLenBytes

Yes

$strLenCP

Yes

$substr

Yes

$substrBytes

Yes

$substrCP

Yes

$toLower

Yes

$toUpper

Yes

Operator Supported

$meta

No

Array Operators

Operator Supported

$arrayElemAt

Yes

$arrayToObject

No

$concatArrays

No

$filter

Yes

$indexOfArray

No

$isArray

Yes

$objectToArray

No

$range

No

$reverseArray

No

$reduce

No

$size

Yes

$slice

No

$zip

No

$in

No

Variable Operators

Operator Supported

$map

No

$let

No

System Variables

Variable Supported

$$CURRENT

No

$$DESCEND

Yes

$$KEEP

Yes

$$PRUNE

Yes

$$REMOVE

No

$$ROOT

No

Literal Operator

Operator Supported

$literal

No

Date Operators

Operator Supported

$dayOfYear

Yes

$dayOfMonth

Yes

$dayOfWeek

Yes

$year

Yes

$month

Yes

$week

No

$hour

Yes

$minute

Yes

$second

Yes

$millisecond

Yes

$dateToString

No

$isoDayOfWeek

No

$isoWeek

No

$dateFromParts

No

$dateToParts

No

$dateFromString

No

$isoWeekYear

No

Conditional Expression Operators

Operator Supported

$cond

Yes

$ifNull

No

$switch

No

Data Type Operator

Operator Supported

$type

No

Accumulator Expressions

Expression Supported

$sum

Yes

$avg

Yes

$first

Yes

$last

Yes

$max

Yes

$min

Yes

$push

Yes

$addToSet

No

$stdDevPop

No

$stdDevSamp

No

Merge Operator

Operator Supported

$mergeObjects

No