[ https://issues.apache.org/jira/browse/DRILL-6722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oleg Zinoviev updated DRILL-6722: --------------------------------- Summary: Query from parquet with case-then and scalar operation returns a wrong result (was: Query from parket with case-then and scalar operation returns a wrong result) > Query from parquet with case-then and scalar operation returns a wrong result > ----------------------------------------------------------------------------- > > Key: DRILL-6722 > URL: https://issues.apache.org/jira/browse/DRILL-6722 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.14.0 > Reporter: Oleg Zinoviev > Priority: Major > Attachments: correct.csv, result.csv > > > Steps to reproduce: > 1) Create sample table: > {code:sql} > create table dfs.tmp.test as > select 1 as a, 2 as b > union all > select 3 as a, 2 as b > union all > select 1 as a, 4 as b > union all > select 2 as a, 2 as b > {code} > 2) Execute query: > {code:sql} > select > case when s.a > s.b then s.a else s.b end as b, > abs(s.a - s.b) as d > from dfs.tmp.test s > {code} > 3) Drill returns: [^result.csv] > 4) Result of query without parquet: > {code:sql} > select > case when s.a > s.b then s.a else s.b end as b, > abs(s.a - s.b) as d > from ( > select 1 as a, 2 as b > union all > select 3 as a, 2 as b > union all > select 1 as a, 4 as b > union all > select 2 as a, 2 as b > ) s > {code} > [^correct.csv] -- This message was sent by Atlassian JIRA (v7.6.3#76005)