[COMPASS-4444] $out and $sql not shown when connected to a data lake Created: 08/Oct/20  Updated: 29/Oct/23  Resolved: 06/Nov/20

Status: Closed
Project: Compass
Component/s: Compass, data-lake
Affects Version/s: 1.22.1, 1.23.0
Fix Version/s: 1.24.1

Type: Bug Priority: Critical - P2
Reporter: Hauke Melius (Inactive) Assignee: Maurizio Casimirri
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2020-10-08-15-08-35-831.png    
Story Points: 3
Documentation Changes: Not Needed
UserVoice Links:

$sql operator support for Atlas Data Lake (Suggestion)
declined (1 users)

Sprint: Iteration Papaya

 Description   

I have an issue, when using $out in Compass while being connected to Atlas DataLake:

Created an aggregation pipeline to store certain documents into a configured S3 Bucket, but Compass doesn't show the $out stage. The pipeline still works using Compass and the Mongo shell.

More details can be found in #datal-lake-help: 

https://mongodb.slack.com/archives/CKNS6CS72/p1601988117061600

Please let me know, if you need additional input. 

 

 

 



 Comments   
Comment by Githook User [ 06/Nov/20 ]

Author:

{'name': 'Maurizio Casimirri', 'email': 'maurizio.cas@gmail.com', 'username': 'mcasimir'}

Message: COMPASS-4444 - fix: $out and $sql not shown when connected to a data lake (#2047)

  • COMPASS-4444: fix $out and $sql not shown when connected to a data lake
Comment by Githook User [ 06/Nov/20 ]

Author:

{'name': 'Maurizio Casimirri', 'email': 'maurizio.cas@gmail.com', 'username': 'mcasimir'}

Message: COMPASS-4444 - fix: $out and $sql not shown when connected to a data lake (#2047)

  • COMPASS-4444: fix $out and $sql not shown when connected to a data lake
Comment by Githook User [ 06/Nov/20 ]

Author:

{'name': 'mcasimir', 'email': 'maurizio.cas@gmail.com', 'username': 'mcasimir'}

Message: COMPASS-4444: fix $out and $sql not shown when connected to a data lake
Branch: COMPASS-4444
https://github.com/mongodb-js/compass/commit/3efeb5eb096792c3a8c3af0bb364d9fc0e380572

Comment by Massimiliano Marcon [ 12/Oct/20 ]

Looks like $sql does not work either, despite being theoretically supported: https://github.com/mongodb-js/ace-autocompleter/blob/9e21a5e5be9f202dd59109908e79166722a5ea66/lib/constants/stage-operators.js#L338

Something might have changed in how ADL identifies itself and therefore we don't detect it anymore.

Generated at Wed Feb 07 22:36:23 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.