sid-viadots

Any update on this? Still getting the same error!!

What was the alternative?

Mongo config { "type": "mongo", "connection": "mongodb+srv://username:[email protected]/dbname", "pluginOptimizations": { "supportsProjectPushdown": true, "supportsFilterPushdown": true, "supportsAggregatePushdown": true, "supportsSortPushdown": true, "supportsUnionPushdown": true, "supportsLimitPushdown": true }, "batchSize": 100, "enabled": true } Options store.mongo.read_numbers_as_double,store.mongo.all_text_mode,store.mongo.bson.record.reader are...

Query is something like this. SELECT count(*) AS `count` FROM (WITH drs as (SELECT d.10.1.1 as 1011, d.1, 2, d.2, d.4 as 4, d.5, d.6 as 6, d.7 as 7,...

Yes. Similar error happens for other queries where 3 tables are used. Never produced for 2 table queries.