spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liang-Chi Hsieh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-12904) Strength reduction for integer/decimal comparisons
Date Wed, 20 Jan 2016 05:07:39 GMT

    [ https://issues.apache.org/jira/browse/SPARK-12904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15108020#comment-15108020
] 

Liang-Chi Hsieh commented on SPARK-12904:
-----------------------------------------

And also:

5. decimal_literal > int_col => ceil(decimal_literal) > int_col
6. decimal_literal >= int_col => floor(decimal_literal) >= int_col
7. decimal_literal < int_col => floor(decimal_literal) < int_col
8. decimal_literal <= int_col => ceil(decimal_literal) <= int_col


> Strength reduction for integer/decimal comparisons
> --------------------------------------------------
>
>                 Key: SPARK-12904
>                 URL: https://issues.apache.org/jira/browse/SPARK-12904
>             Project: Spark
>          Issue Type: Bug
>          Components: Optimizer, SQL
>            Reporter: Reynold Xin
>
> We can do the following strength reduction for comparisons between an integral column
and a decimal literal:
> 1. int_col > decimal_literal => int_col > floor(decimal_literal)
> 2. int_col >= decimal_literal => int_col > ceil(decimal_literal)
> 3. int_col < decimal_literal => int_col < floor(decimal_literal)
> 4. int_col <= decimal_literal => int_col < ceil(decimal_literal)
> This is more useful as soon as we start parsing floating point numeric literals as decimals
rather than doubles (SPARK-12848).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message