alamb commented on PR #15110: URL: https://github.com/apache/datafusion/pull/15110#issuecomment-2725533031
> Actually I'm quite curious is string literal really an issue? If we want string, we can have query with quote `select * from t1 where column1 < '10';`, while if we want numeric, we can have query without quote `select * from t1 where column1 < 10;`. In practice, when is it beneficial to convert string literal into numeric type? 🤔 I think the core usecase is the one given on https://github.com/apache/datafusion/issues/15035 Specifcally when the user is comparing a numeric column to a string literal (date = '202401'). The `date` column and `'202401'` need to be converted to a common type, and converting the string to numeric is faster (and can be used to prune parquet predicates, for example) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
