This is an automated email from the ASF dual-hosted git repository.
agrove pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new a76c3d309f Remove additional cast from TPCH q8 (#7233)
a76c3d309f is described below
commit a76c3d309f76a801abb1b39a9a23c942814cb05b
Author: Liang-Chi Hsieh <[email protected]>
AuthorDate: Tue Aug 8 20:04:25 2023 -0700
Remove additional cast from TPCH q8 (#7233)
---
benchmarks/queries/q8.sql | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/benchmarks/queries/q8.sql b/benchmarks/queries/q8.sql
index 4f34dca6a0..6ddb2a6747 100644
--- a/benchmarks/queries/q8.sql
+++ b/benchmarks/queries/q8.sql
@@ -1,9 +1,9 @@
select
o_year,
- cast(cast(sum(case
- when nation = 'BRAZIL' then volume
- else 0
- end) as decimal(12,2)) / cast(sum(volume) as decimal(12,2)) as
decimal(15,2)) as mkt_share
+ sum(case
+ when nation = 'BRAZIL' then volume
+ else 0
+ end) / sum(volume) as mkt_share
from
(
select
