Hello Elastic, I have a query to ask you specifically regarding the Search Connectors for Microsoft SQL. I have successfully connected to the Microsoft SQL database, and there are multiple tables that I would like to query by joining them. The question is : How can we perform a join query to c…

Hi @aisyaharifin , thanks for the good questions! How can we perform a join query to connect multiple tables? Today, there's not a great way to do this. I would have said "with views," but we've had a recent bug report of Views not working with our MySQL connector, and I haven't personally tried…

Hello @Sean_Story , I want to ask your confimation, as the 8.11 already came out and my team already upgraded our Elastic, I've been trying around with the SQL Query. I want to understand the mechanism where as for example, I had 9 different queries that I need to apply. If I applied all the 9 que…

[image] aisyaharifin: Hence, when the user did the searching, the searching will match with all the queries is it ? 1 search = 9 sql queries I'm worried there's misunderstanding here. The connector, at a high level, is responsible for getting data from one source (in your case, MySQL) to an E…

[image] Sean_Story: But if you did a match_all query, you will get all documents that were indexed, regardless of which SQL query they were indexed with. Hello @Sean_Story thank you for you reply, but could you explain on what do you mean by if I did a match_all query? Is there any configurat…

Hello @Sean_Story I have one more question that I would like to confirm on, does the Advanced Sync Rules query is case-sensitive? Such as, the query of table name case should reflect with those in Microsoft SQL? If the table name in Microsoft SQL > 'ProductID' , hence the query should wrote 'Produ…

[image] aisyaharifin: could you explain on what do you mean by if I did a match_all query? This is a specific type of Elasticsearch query. You can read about it here: Match all query | Elasticsearch Guide [8.11] | Elastic [image] aisyaharifin: does the Advanced Sync Rules query is case-s…

Hi @Sean_Story , I've been playing around with the Advanced sync rules and wanted to do the INNER JOIN. I've been trying the simplest one even for example : SELECT * FROM Bird INNER JOIN Chicken ON Bird.ChickenId = Chicken.Id but its not working and when I take a look my docker logs it shows : […

Ops the query might wrong so the query is : SELECT TOP 10 Bird.Name, Chicken.Food FROM Bird INNER JOIN Chicken ON Chicken.TagId = Bird.Id; Even though I did this query is not working. The error still the same. Thanks.

Hi @aisyaharifin , One of our engineers suggested that you may be able to get around this with AS usage to make sure that column names do not conflict in your query. The example they gave was: SELECT users.id AS id, orders.order_id AS order_id, users.name AS user_name, orders.product_name AS produ…

Hi @Sean_Story , Thank you so much for your reply. I've already tried to put AS but it still not working and in my docker logs it shows skipping custom query, below is my query : [ { "tables": [ "Penguin", "Chicken" ], "query": "SELECT TOP 100 P.Id AS PenguinID, P.Name A…

Discuss the Elastic Stack

Search Connectors Microsoft SQL

Elastic Search

aisyaharifin (Siti Nuraisyah) January 2, 2024, 8:01am 14

Hi @Sean_Story ,

Can I get updates on the issue, when will it be resolved?

Thank you.

Topic		Replies	Views
Issue in Advanced Sync Rules for JOIN Query Elasticsearch docker	1	214	January 16, 2024
When SQL JOIN command will be available in ElasticSearch? Elasticsearch	14	781	September 5, 2018
Connectors Search for MSSQL Inquiry Elastic Search elastic-app-search	2	176	May 2, 2024
Elastic search 6.3.0 SQL query API Elasticsearch	7	1738	August 6, 2018
Joining two sql tables in elasticsearch Elasticsearch	2	490	May 4, 2019

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Search Connectors Microsoft SQL

Related topics