cube-js / cube-js/cube

Elasticsearch contains query does a fuzzy match instead of like query

Open
#1,720 6 comments 0 reactions 0 assignees View on GitHub
community supported driver:elasticsearch help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.