v.25.8Improvement

MongoDB: Implicit parsing of strings

Official CH changelog text
MongoDB: Implicit parsing of strings to numeric types. Previously, if a string value was received from a MongoDB source for a numeric column in a ClickHouse table, an exception was thrown. Now, the engine attempts to parse the numeric value from the string automatically. Closes #81167. #84069 (Kirill Nikiforov).
ClickHouse's MongoDB engine now implicitly parses string values as numeric types for numeric columns instead of throwing an exception.

Why it matters

This feature addresses the issue where string representations of numeric values from MongoDB sources caused exceptions when inserted into numeric columns in ClickHouse. By automatically parsing these strings to their numeric equivalents, it simplifies data ingestion and improves compatibility without requiring manual type conversion.

How to use it

Users do not need to change any settings. When reading from a MongoDB source, ClickHouse will automatically attempt to parse string values as numeric types for numeric columns during data insertion or query execution.

Related resources

PreviousNext