Push filters into subselects with SCALAR EMITS UDFs
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8923 |
| Type | Improvement |
| Status | Open |
Description
This filter is currently not pushed into the subselect, because the subselect contains a SCALAR EMITS UDF:
SELECT c, f FROM ( SELECT c, scalar_emits_udf() as f FROM t ) o WHERE c = 1;
Workaround
- Rewrite the SQL and push the filter manually into the subselect
- Use a SCALAR RETURNS UDF instead of the SCALAR EMITS UDF
