cube-js / cube-js/cube

Getting Unsupported filter scalar: int32(3) while executing query which filters dayofweek

Open
#7,598 4 comments 0 reactions 2 assignees Claimed by @paveltiunov View on GitHub
api:sql help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Failed SQL**
```sql
select
'b2c_orders' as metric_name,
measure(b2c_orders) as metric_value,
date_trunc('week', time) as time
from product_revenue
where dayofweek <= EXTRACT(DOW from current_date)
GROUP by 1,3
```

**Logical Plan**
Not able to get the logical plan, getting the same error while appending "explain" keyword to the query.

**Error**
postgresql error: Error during rewrite: Unexpected panic. Reason: Unsupported filter scalar: Int32(4). Please check logs for additional information.

**Version:**
0.34.36

**Additional context**

1. dayofweek is a simple dimension of type number in the cube 'product_revenue'
2. If I use a constant value on the either side of the filter, for eg: '2 <= EXTRACT(DOW from current_date)', or 'dayofweek <= 2', it works just fine.

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.