cube-js / cube-js/cube

Query with pushdown SQL parsing is not accurate

Open
#8,525 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Describe the bug**
A clear and concise description of what the bug is.

I tried using the query pushdown feature and found that no data was queried. Upon checking the logs, I discovered that the
parsed SQL was not what I wanted.

**To Reproduce**
Steps to reproduce the behavior:
1. Enable query pushdown and use it with a Superset connection.
image
2.Write the following SQL statement:
image
3.Click the query button, then check the Cube's logs.
4.The parsed statement from Cube is as follows, which is not what I intended. The parameters in the WHERE clause are incorrect, and I believe this is a bug.
image

**Expected behavior**
A clear and concise description of what you expected to happen.
I believe the value of "sku_code" should be "666666" instead.

**Version:**
[e.g. 0.35.64]

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.