[ https://issues.apache.org/jira/browse/DRILL-8231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17541254#comment-17541254 ]
manabu nagamine commented on DRILL-8231: ---------------------------------------- I tried using Drill 1.19. We have confirmed that the results are the same as in Drill 1.18. {code:java} Apache Drill 1.19.0 "Two things are infinite: the universe and Drill; and I'm not sure about the universe." apache drill> select SUM(CAST(val11 as BIGINT)+CAST(val12 as BIGINT)) COL6408, COUNT(DISTINCT val2) COL4452 from dfs.root.`/drill/data/*/log_15872_R_79_*.parquet` WHERE 1 = 1 and ( ( dir0 between '01 ' and '10' ) ) and ( LOG_DATE >= '2022-04-01 00:00:00.000000' and LOG_DATE <= '2022-04-30 23:59:59.000000'); +------------+---------+ | COL6408 | COL4452 | +------------+---------+ | 9169057876 | 4 | +------------+---------+ 1 row selected (5.454 seconds) apache drill> select COUNT(DISTINCT val2) COL4452, SUM(CAST(val11 as BIGINT)+CAST(val12 as BIGINT)) COL6408 from dfs.root.`/drill/data/*/log_15872_R_79_*.parquet` WHERE 1 = 1 and ( ( dir0 between '01 ' and '10' ) ) and ( LOG_DATE >= '2022-04-01 00:00:00.000000' and LOG_DATE <= '2022-04-30 23:59:59.000000'); +---------+------------+ | COL4452 | COL6408 | +---------+------------+ | 2 | 9169057876 | +---------+------------+ 1 row selected (0.812 seconds) apache drill> select val2, val3, COUNT(DISTINCT val2) COL4452 from dfs.root.`/drill/data/*/log_15872_R_79_*.parquet` WHERE 1 = 1 and ( ( dir0 between '01' and '10' ) ) and ( LOG_DATE >= '2022-04-01 00:00:00.000000' and LOG_DATE <= '2022-04-30 23:59:59.000000') group by val2, val3; +------------------+-------+---------+ | val2 | val3 | COL4452 | +------------------+-------+---------+ | 4db387ff6ebcbe4d | HTV33 | 1 | | c4b06a20f25edb91 | SHG01 | 1 | +------------------+-------+---------+ 2 rows selected (0.76 seconds) apache drill> {code} > Wrong result in the COUNT function position. > -------------------------------------------- > > Key: DRILL-8231 > URL: https://issues.apache.org/jira/browse/DRILL-8231 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.18.0 > Reporter: manabu nagamine > Priority: Major > Attachments: drill.zip > > > Hi Team. > We using Drill 1.18. > There is a phenomenon that the count values of COL4452 are different in the > execution results of the following queries. > The only difference is that the positions of COL4452 and COL6408 have been > changed. > {code:java} > 1. > select COUNT(DISTINCT val2) COL4452, SUM(CAST(val11 as BIGINT)+CAST(val12 as > BIGINT)) COL6408 from dfs.root.`/drill/data/*/log_15872_R_79_*.parquet` WHERE > 1 = 1 and ( ( dir0 between '01' and '10' ) ) and ( LOG_DATE >= '2022-04-01 > 00:00:00.000000' and LOG_DATE <= '2022-04-30 23:59:59.000000'); > 2. > select SUM(CAST(val11 as BIGINT)+CAST(val12 as BIGINT)) COL6408, > COUNT(DISTINCT val2) COL4452 from > dfs.root.`/drill/data/*/log_15872_R_79_*.parquet` WHERE 1 = 1 and ( ( dir0 > between '01' and '10' ) ) and ( LOG_DATE >= '2022-04-01 00:00:00.000000' and > LOG_DATE <= '2022-04-30 23:59:59.000000');{code} > As for the actual data, the count with COL4452 at the beginning of 1. is > correct. > I am having trouble understanding the cause of this phenomenon. > Can anybody help me?Thanks in advance. > Attached the parquet log file. -- This message was sent by Atlassian Jira (v8.20.7#820007)