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/datafusion-benchmarks.git
The following commit(s) were added to refs/heads/main by this push:
new 3668e39 fix q35 (#17)
3668e39 is described below
commit 3668e3918d9d636c726a805bd3d727813cecd96c
Author: Onur Satici <[email protected]>
AuthorDate: Fri Nov 1 14:48:32 2024 +0000
fix q35 (#17)
---
tpcds/queries-spark/q35.sql | 12 ++++++------
tpcds/queries/q35.sql | 12 ++++++------
2 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/tpcds/queries-spark/q35.sql b/tpcds/queries-spark/q35.sql
index ba0ccf3..eb41c40 100644
--- a/tpcds/queries-spark/q35.sql
+++ b/tpcds/queries-spark/q35.sql
@@ -7,19 +7,19 @@ select
cd_marital_status,
cd_dep_count,
count(*) cnt1,
+ min(cd_dep_count),
max(cd_dep_count),
- stddev_samp(cd_dep_count),
- stddev_samp(cd_dep_count),
+ avg(cd_dep_count),
cd_dep_employed_count,
count(*) cnt2,
+ min(cd_dep_employed_count),
max(cd_dep_employed_count),
- stddev_samp(cd_dep_employed_count),
- stddev_samp(cd_dep_employed_count),
+ avg(cd_dep_employed_count),
cd_dep_college_count,
count(*) cnt3,
+ min(cd_dep_college_count),
max(cd_dep_college_count),
- stddev_samp(cd_dep_college_count),
- stddev_samp(cd_dep_college_count)
+ avg(cd_dep_college_count)
from
customer c,customer_address ca,customer_demographics
where
diff --git a/tpcds/queries/q35.sql b/tpcds/queries/q35.sql
index ba0ccf3..eb41c40 100644
--- a/tpcds/queries/q35.sql
+++ b/tpcds/queries/q35.sql
@@ -7,19 +7,19 @@ select
cd_marital_status,
cd_dep_count,
count(*) cnt1,
+ min(cd_dep_count),
max(cd_dep_count),
- stddev_samp(cd_dep_count),
- stddev_samp(cd_dep_count),
+ avg(cd_dep_count),
cd_dep_employed_count,
count(*) cnt2,
+ min(cd_dep_employed_count),
max(cd_dep_employed_count),
- stddev_samp(cd_dep_employed_count),
- stddev_samp(cd_dep_employed_count),
+ avg(cd_dep_employed_count),
cd_dep_college_count,
count(*) cnt3,
+ min(cd_dep_college_count),
max(cd_dep_college_count),
- stddev_samp(cd_dep_college_count),
- stddev_samp(cd_dep_college_count)
+ avg(cd_dep_college_count)
from
customer c,customer_address ca,customer_demographics
where
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
