You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WITH test_filter AS(
SELECT'order-1'as filter_1
)
SELECT*FROM orders WHERE order_id IN(SELECT filter_1 FROM test_filter)
Error
Error during rewrite: Error during planning: No field named '__subquery-0.filter_1'. Valid fields are '..'.. Please check logs for additional information.
Version:
[e.g. 0.4.5]
Additional context
Somehow using CTEs with the SQL-API, is not working as expected, for example when used in IN Condition or as LEFT JOIN
The text was updated successfully, but these errors were encountered:
Failed SQL
Config:
Query via SQL-API
Error
Version:
[e.g. 0.4.5]
Additional context
Somehow using CTEs with the SQL-API, is not working as expected, for example when used in
IN
Condition or asLEFT JOIN
The text was updated successfully, but these errors were encountered: