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: [email protected]
For additional commands, e-mail: [email protected]
