You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/04/30 23:11:00 UTC
[jira] [Commented] (IMPALA-5821) Add literal suffixes for numeric
types
[ https://issues.apache.org/jira/browse/IMPALA-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16459241#comment-16459241 ]
Tim Armstrong commented on IMPALA-5821:
---------------------------------------
[~alex.behm] did your last comment here get addressed?
> Add literal suffixes for numeric types
> --------------------------------------
>
> Key: IMPALA-5821
> URL: https://issues.apache.org/jira/browse/IMPALA-5821
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Affects Versions: Impala 2.8.0
> Reporter: Matthew Jacobs
> Priority: Minor
> Labels: supportability, usability
>
> In this plan, it wasn't clear that the constant in the predicate was being evaluated to a double. Then the lhs required an implicit cast, and the predicate couldn't be pushed to Kudu:
> {code}
> [localhost:21000] > explain select * from functional_kudu.alltypestiny where bigint_col < 1000 / 100;
> Query: explain select * from functional_kudu.alltypestiny where bigint_col < 1000 / 100
> +---------------------------------------------+
> | Explain String |
> +---------------------------------------------+
> | Per-Host Resource Reservation: Memory=0B |
> | Per-Host Resource Estimates: Memory=10.00MB |
> | Codegen disabled by planner |
> | |
> | PLAN-ROOT SINK |
> | | |
> | 00:SCAN KUDU [functional_kudu.alltypestiny] |
> | predicates: bigint_col < 10 |
> +---------------------------------------------+
> {code}
> We should make it more clear by printing this as a double clearly, e.g.
> {code}
> predicates: bigint_col < 10.0
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org