cube-js / cube-js/cube

Elasticsearch driver does not work with opendistro

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

Description

When we use opendistro with elastic search driver it fails with below error

`Error: "{\n \"error\": {\n \"reason\": \"Invalid SQL query\",\n \"details\": \"Failed to parse query due to offending symbol [:] at: 'SELECT FLOOR((TIMESTAMP_DIFF('seconds', '1970-01-01T00:00:00.000Z':' <--- HERE... More details: Expecting tokens in {'SELECT', '('}\",\n \"type\": \"SyntaxAnalysisException\"\n },\n \"status\": 400\n}"`

**Expected behavior**
Expected behavior is that cubejs will work normally without any issue on opendistro

**Version:**
0.26.53

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.