SQL API: Compute error in queries with OR operator
- 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
Assessment
This issue has not been assessed yet.