v.24.10New Feature

MongoDB Integration Enhancement in ClickHouse

Official CH changelog text
MongoDB integration: support for all MongoDB types, support for WHERE and ORDER BY statements on MongoDB side, restriction for expressions unsupported by MongoDB. Note that the new inegration is disabled by default, to use it, please set <use_legacy_mongodb_integration> to false in server config. #63279 (Kirill Nikiforov).
Enhanced MongoDB integration in ClickHouse with full support for all MongoDB types, enabling WHERE and ORDER BY clauses to be executed on the MongoDB side, and adding restrictions for expressions not supported by MongoDB.

Why it matters

This feature improves the MongoDB integration by allowing more efficient query processing by pushing filters and sorting conditions down to MongoDB. It ensures compatibility with all MongoDB data types and prevents unsupported expressions from causing errors, enhancing overall query accuracy and performance for users working with MongoDB as a data source.

How to use it

The new MongoDB integration is disabled by default. To enable it, set <use_legacy_mongodb_integration> to false in the ClickHouse server configuration file.

Related resources

PreviousNext