Support Mongo types #51929
Description
ClickHouse Version: 23.6.1
We don't have support for all Mongo types e.g.
- Decimal128.
Results in an error e.g.
Code: 1000. DB::Exception: Received from localhost:9000. DB::Exception: Not implemented: Element bathrooms contains an unsupported type 0x13. (POCO_EXCEPTION)
- Nested Structures e.g.
{"address":{"building":"2780","coord":[{"$numberDouble":"-73.98241999999999"},{"$numberDouble":"40.579505"}],"street":"Stillwell Avenue","zipcode":"11224"},"borough":"Brooklyn","cuisine":"American","name":"Riviera Caterer","restaurant_id":"40356018"}
unclear how to map these, ideally would be Tuple (possibly JSON in future)
SELECT *
FROM mongodb('atlas-wjb3dy-shard-00-02.aen7y.mongodb.net:27017', 'sample_restaurants', 'restaurants', 'default', 'password', 'name String, restaurant_id String, cuisine String, borough String, address Tuple(building String, coord Array(Float32), street String, zipcode String)', 'connectTimeoutMS=10000&ssl=true&socketTimeoutMS=10000&authSource=admin') LIMIT 1 FORMAT Vertical
Code: 50. DB::Exception: Received from localhost:9000. DB::Exception: Unsupported type Tuple(building String, coord Array(Float32), street String, zipcode String). (UNKNOWN_TYPE)