Github user henryr commented on the issue: https://github.com/apache/spark/pull/21482 @rxin Other engines are all over the place: * MySQL doesn't have support for infinity (based on my cursory look) - 1.0 / 0.0 is written as `null`. Also seems to be true of SQLite. * Postgres has type-specific literals (e.g. `FLOAT8 '+Infinity'`) which you can use for comparison checks. * Impala has `is_inf()` * Oracle has a literal value, and also a built-in predicate `SELECT f FROM foo WHERE f is infinite` * SQL Server does not appear to support infinity (but that's based on anecdotal evidence) One of my motivations suggesting this builtin was to make sharing workloads with Impala easier. I think it's convenient to have as well, since it's more intuitive than figuring out what the right literal incantation should be.
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org