cube-js/cube

Elasticsearch contains query does a fuzzy match instead of like query

Open

#1,720 opened on Jan 4, 2021

View on GitHub
 (6 comments) (0 reactions) (0 assignees)Rust (1,965 forks)batch import
community supporteddriver:elasticsearchhelp wanted

Repository metrics

Stars
 (19,563 stars)
PR merge metrics
 (Avg merge 5d 16h) (138 merged PRs in 30d)

Description

Describe the bug When I do a contains search in the cube for an elasticsearch database it creates a fuzziness SQL query

To Reproduce Cube Query

{
  "filters": [
    {
      "dimension": "index.message",
      "values": [
        "viral"
      ],
      "operator": "contains"
    }
  ],
  "limit": 1,
  "dimensions": [
    "index.user_id"
  ]
}

This creates a SQL query like this

  SELECT
      index.user_id index__user_id
    FROM
      index AS index
  WHERE ( MATCH(index.message, 'viral', 'fuzziness=AUTO:1,5')) GROUP BY index.user_id ORDER BY index.user_id ASC LIMIT 1

Is there any reason we are not using the LIKE query in this case If not then can I change it, such that the engine creates a LIKE query when the input cube query has operator as contains

Contributor guide

Research direction
Locate the Elasticsearch query builder in Cube codebase, find where the 'contains' operator is mapped to 'fuzziness', and change it to use a 'LIKE' or 'match phrase' query instead.
Tech stack
javascripttypescriptnodejselasticsearch
Domain
backendapidatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GitNode.jsElasticsearch basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
75