You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "ZheHu (Jira)" <ji...@apache.org> on 2021/11/20 01:26:00 UTC
[jira] [Updated] (CALCITE-4896) GROUP BY might get wrong results under certain circumstances in Elasticsearch Adapter
[ https://issues.apache.org/jira/browse/CALCITE-4896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ZheHu updated CALCITE-4896:
---------------------------
External issue URL: (was: https://issues.apache.org/jira/browse/CALCITE-2689)
> GROUP BY might get wrong results under certain circumstances in Elasticsearch Adapter
> -------------------------------------------------------------------------------------
>
> Key: CALCITE-4896
> URL: https://issues.apache.org/jira/browse/CALCITE-4896
> Project: Calcite
> Issue Type: Bug
> Components: elasticsearch-adapter
> Affects Versions: 1.28.0
> Reporter: ZheHu
> Priority: Major
>
> In Elasticsearch Adapter, if one field is grouped by along with missing value, SQL user might get incorrect results. Take the following case as an example:
> {code:java}
> ES mappings: {"int_field1" : integer, "int_field2" : integer}
> doc1 = {"int_field1":1, "int_field2": -2147483648}
> doc1 = {"int_field1":2}
> {code}
> When I try "select count(1) as CNT from view group by int_field2", the result is 2.
> For Integer type, the missing value is replaced by Integer.MIN_VALUE, so doc1 and doc2 will be divided in the same group.
> Any other data types like short、long、float、double, they also have such problem.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)