You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The WHERE clause in the SQL query is translated as a "bool - filter" ES query.
However, that "bool filter" query only works on Keyword and indexed fieds in ES.
Requirements:
To improve the ES connector with a dynamic filtering query, depending on the field type, in order to make the right ES query:
type keyword and indexed : ES query using "bool filter" (behavior as of today)
type keyword and non indexed or type Text : ES query using"query match" or "query multi-match" if several WHERE clauses in the SQL query
The text was updated successfully, but these errors were encountered:
jimPeill
changed the title
Feature - Elasticsearch connector improvment - dynamic filtering ES query
Feature - Elasticsearch connector improvement - dynamic filtering ES query
Sep 19, 2024
The WHERE clause in the SQL query is translated as a "bool - filter" ES query.
However, that "bool filter" query only works on Keyword and indexed fieds in ES.
Requirements:
To improve the ES connector with a dynamic filtering query, depending on the field type, in order to make the right ES query:
The text was updated successfully, but these errors were encountered: