Questions tagged [aws-documentdb-mongoapi]

For questions about Amazon's DocumentDB with MongoDB compatible databases.

References:

109 questions
0
votes
0 answers

Joining two collections on multiple columns in AWS Document DB

I am new to AWS DocumentDB and trying to execute a simple query that would find entries from two collections where 3 fields are the same. SQL version: Select * from A a join B b on A.id = B.id where a.ax = b.bx and a.ay = b.by and a.az = b.bz I…
0
votes
0 answers

Can AWS DocumentDB log slow aggregate queries containing a $lookup stage?

I have the profiler enabled on DocumentDB and it is happily logging slow queries (both simple queries and aggregate pipelines). However whenever I execute an aggregate query containing a $lookup stage, it never appears in the slow query logs…
insano10
  • 113
  • 2
  • 6
0
votes
1 answer

How to do left outer join and count in AWS DocumentDB?

I am trying to get count of tenant for the owner, owner_collection: [ {_id: ObjectId("123dddfffaaa7744"), owner_name:"Sam"}, {_id: ObjectId("243dddfffaaa7755"), owner_name:"Ray"} ] tenant_collection: [ {_id: ObjectId("2223dddfffaaa12233"),…
uday214125
  • 569
  • 1
  • 8
  • 22
0
votes
1 answer

Use Kafka connect with AWS documentDB

I'm trying to use AWS DocumentDB as a sink for storing data received from Kafka and was wondering if the MongoDB Kafka connector works with DocumentDB as its documentation mentions that it is compatible with MongoDB…
0
votes
1 answer

AWS SAM Local Invoke not connecting to DocDB Cluster

My company has a DocDB cluster in a sandbox environment. Currently, I can do the following: Connect to cluster via Terminal and Mongo Compass. If I deploy the lambda to was,it can connect to the cluster. If I run the Python script in VScode, I can…
0
votes
1 answer

connection issues with AWS DocumentDB via nodejs mongodb package

I have created a DocumentDB with SSL enabled and I am using mongodb package using NodeJS to connect this DB using a Bastion Host. The issue is that if I put a hardcoded string inside the MongoClient.connect function, I am able to successfully…
0
votes
1 answer

READIOPS metric graph is not showing anything

Hi I am using aws document db to do some performance testing .I am doing only read operations for certain period of time .But strangely I am not seeing anything in READOPS count metric
0
votes
1 answer

AWS Document DB - Spring Boot Integration - Commit behavior for WRITE Ops

I have a Spring Boot application (2.2.5 RELEASE) that sync (not reactive) writes to AWS DocumentDB wo declaring any explicit transaction semantics from application. We are using MongoOperations without declaring an explicit…
Divs
  • 1,578
  • 2
  • 24
  • 51
0
votes
1 answer

How to connect documentdb to a spark application in an emr instance

I'm getting error while I'm trying to configure spark with mongodb in my EMR instance. Below is the command - spark-shell --conf…
0
votes
1 answer

Getting connection refused error when trying to connect to aws ec2 on a specific port?

We are trying to use ssh tunnel local port forwarding on aws ec2,that should forward the requests to DocumentDB. sudo ssh -L 27777:docdbid***.docdb.amazonaws.com:27017 ec2-user@localhost -i "ec2keypair.pem" -N Using netstat command(netstat…
0
votes
1 answer

AWS DocumentDB: What is the difference between instance writeIOPS and cluster volumeWriteIOPS and why is the volumeWriteIOPS 100x the writeIOPS?

We recently deployed an AWS documentDB with one instance and have about 6000 documents inserted in the past 72 hours. Strangely, the instance and the cluster show completely different numbers for the write operations. The cluster states more than a…
0
votes
0 answers

Delete connections in aws documentdb

In aws documentDb is there a way to delete open connections from mongo cli? When I run db.serverStatus() I see there are about 1k connections, I am trying to delete those. I tried using db.adminCommand( { killSessions: []}) Is there a command that…
surajz
  • 3,471
  • 3
  • 32
  • 38
0
votes
2 answers

Rename a field within an array in DocumentDB via pymongo

I am using docudmentDB(version 3.6) in AWS. I use a python lambda in AWS for this task. The task is to rename a field that is in an array. Here is the sample JSON document I have. Here I need to rename 'version' to 'label'. { "_id":…
0
votes
1 answer

Does aws documentdb validate mongodb client certificate for two way ssl?

How do we create client certificate to get validated by aws document db?In aws docs https://docs.aws.amazon.com/documentdb/latest/developerguide/connect_programmatically.html#connect_programmatically-tls_enabled, it is mentioned only about one way…
0
votes
1 answer

Is two way ssl possible with aws document db?

Does AWS DocumentDB support authenticating clients with SSL?I've downloaded rds-combined-ca-bundle.pem and got rds-truststore.jks by following the aws link…