Andrej G created SPARK-50692:
--------------------------------

             Summary: Add RPAD pushdown support
                 Key: SPARK-50692
                 URL: https://issues.apache.org/jira/browse/SPARK-50692
             Project: Spark
          Issue Type: Improvement
          Components: Spark Core
    Affects Versions: 3.5.4
            Reporter: Andrej G


Make {{RPAD}} function translatable (via {{{}V2ExpressionBuilder{}}}) and it's 
pushdown supported (via {{V2ExpressionSQLBuilder}} as a 
{{{}visitSQLFunction{}}}).
h3. CONTEXT:

When trying to compare CHAR(...) and a literal, Spark injects a RPAD function 
to make the CHAR parameter the same length. This behaviour is per ANSI standard.
h3. THE PROBLEM:

RPAD is not only an unsupported, but an untranslatable function. This prevents 
CHAR + literal comparison pushdown.
h3. THE SOLUTION:

Support RPAD pushdowns and implement it when needed



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to