Please do not respond unless you have hands-on, verifiable experience with Elasticsearch.
I have two pretty simple tables that I'd like to get into an Elasticsearch index. Here are some details:
- Table 1 represents parent records
- Table 2 represents children records
- Each parent may have 0, 1, or more children
- Includes latitude and longitude data
I would like you to price the following milestones:
1. Data Model: Define the data model for the new index using the tool Hackolade. It's a data modeling tool for noSQL/doc-based repositories. There is a free trial.
2. ETL: The transformation process to take the two mariaDB tables and get them into json structure that's defined as part of step 1.
3. Index: Configuration of the Elasticsearch index, include field mappings. There will be basic aggregations - but nothing advanced as part of this initial phase. The only requirement at this time beyond super basic Elasticsearch functions is being able to handle the geospatial data (and return records based on a distance metric).
Proposals not adhering to this milestone structure (or something close) will be ignored.