That sounds like an issue. Please log a JIRA case. (Also, contributions are appreciated… we don’t seem to have many people volunteering to fix the MongoDB adapter these days.)
> On Dec 20, 2017, at 2:09 AM, Vladimir Dolzhenko > <[email protected]> wrote: > > Hi, > > Have tried Calcite's MongoDB adapter > > SELECT _MAP['id'] as id, _MAP['name'] as name, _MAP['someRef'] as someRef > FROM myCollection > > definitely works fine, and the problem appeared when I added JOIN > > SELECT col1._MAP['id'] as id, col1._MAP['name'] as name, > col1._MAP['someRef'] as someRef, col2._MAP['name'] as name2 FROM > myCollection as col1 LEFT JOIN col2 on col1._MAP['someRef'] = > col2._MAP['id'] > > it leads to mongo projections [{$project: {_MAP: 1, '$f1': '$someRef'}}] > and [{$project: {'$f1': '$id'}}] - that is illegal as fieldPath field names > may not start with '$'. > > Is it an issue or wrong usage ? > > -- > Regards, Vladimir Dolzhenko.
