cube-js / cube-js/cube

SQL API: Compute error in queries with OR operator

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

Description

**Failed SQL**

```sql
SELECT week_utc, MEASURE(num_customers) AS total_customers
FROM customers
WHERE month_utc = 202310 OR month_utc = 202311
GROUP BY week_utc
```

**Error**
SQL Error [XX000]: ERROR: Arrow error: Compute error: TypeError: Cannot read properties of undefined (reading 'split')

**Logical Plan**
```
CubeScan: request={
"measures": [
"customers.num_customers"
],
"dimensions": [
"customers.week_utc"
],
"segments": [],
"filters": [
{
"or": [
{
"member": "customers.month_utc",
"operator": "equals",
"values": [
"202310"
]
},
{
"member": "customers.month_utc",
"operator": "equals",
"values": [
"202311"
]
}
]
}
]
}
```

**Version:**
v0.35.55

**Additional context**
I see same error when enabling SQL pushdown

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.