Elasticsearch
Elasticsearch is a distributed, RESTful search and analytics engine built for speed, scale, and relevance.
Supported Versions and Architectures
- Versions: Elasticsearch 5.x, 6.x, 7.x, 8.x
- Architectures: Standalone and cluster deployments
Supported Data Types
| Category | Data Types |
|---|---|
| Text Types | text, keyword |
| Numeric Types | long, integer, short, byte, double, float, half_float, scaled_float |
| Date Types | date |
| Boolean Type | boolean |
| Binary Type | binary |
| Range Types | integer_range, float_range, long_range, double_range, date_range |
| Complex Types | object, nested |
Quick Setup Guide
1. Basic Connection
Connect using HTTP endpoint (default port 9200):
http://your-elasticsearch-host:9200
2. Authentication (if enabled)
Provide username and password for secured clusters.
Limitations
- Full sync only: When syncing data from Elasticsearch to ClickHouse, only full synchronization is supported; real-time incremental sync is not available
- Auto table creation constraints: Due to Elasticsearch's flexible schema structure, automatic table creation based on sampling may result in incomplete target table fields. Manual table creation may be required in such cases