MySQL tables with foreign key to Elastic App Search

How can I manage the relation between 2 tables in Elastic App Search?
I have to ingest data from MySQL DB from 2 tables which have foreign key to elastic app search engine. How do I do this?

Hey Rustin, do you have perhaps a few more details on what you're trying to accomplish? It sounds like you're saying you have to ingest data from two tables in your MySQL database. Are you ingesting that data into Elasticsearch? Into Elastic App Search or somewhere else? You mentioned that there's a foreign key in the data in those tables that map to an App Search engine, is this a field that you're looking to search or otherwise map the data... if so for what purpose?

I'm trying to ingest data into Elastic App Search. I ingested data using Logstash and set JDBC statement to query both table together binding with foreignKey_A = foreignKey_B.
I need to search from the first table, but some of the data is in the related table.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.