cube-js/cube
GitHub で見るGetting Unsupported filter scalar: int32(3) while executing query which filters dayofweek
Open
#7,598 opened on 2024年1月4日
api:sqlhelp wanted
Repository metrics
- Stars
- (19,563 stars)
- PR merge metrics
- (平均マージ 5d 16h) (30d で 138 merged PRs)
説明
Failed 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
- dayofweek is a simple dimension of type number in the cube 'product_revenue'
- 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.