You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by ja...@apache.org on 2023/06/12 03:56:54 UTC
[arrow-datafusion] branch main updated: Minor: cleanup the unnecessary CREATE TABLE aggregate_test_100 statement at aggregate.slt
This is an automated email from the ASF dual-hosted git repository.
jakevin 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 373e291fab Minor: cleanup the unnecessary CREATE TABLE aggregate_test_100 statement at aggregate.slt
373e291fab is described below
commit 373e291faba5b3c722018367e01a6b59a91bddee
Author: zhenxing jiang <ji...@gmail.com>
AuthorDate: Mon Jun 12 11:56:47 2023 +0800
Minor: cleanup the unnecessary CREATE TABLE aggregate_test_100 statement at aggregate.slt
---
.../tests/sqllogictests/test_files/aggregate.slt | 28 ++++------------------
1 file changed, 4 insertions(+), 24 deletions(-)
diff --git a/datafusion/core/tests/sqllogictests/test_files/aggregate.slt b/datafusion/core/tests/sqllogictests/test_files/aggregate.slt
index ac4e223ab6..ca1f8035f6 100644
--- a/datafusion/core/tests/sqllogictests/test_files/aggregate.slt
+++ b/datafusion/core/tests/sqllogictests/test_files/aggregate.slt
@@ -16,26 +16,6 @@
# under the License.
-statement ok
-CREATE EXTERNAL TABLE aggregate_test_100_by_sql (
- c1 VARCHAR NOT NULL,
- c2 TINYINT NOT NULL,
- c3 SMALLINT NOT NULL,
- c4 SMALLINT,
- c5 INT,
- c6 BIGINT NOT NULL,
- c7 SMALLINT NOT NULL,
- c8 INT NOT NULL,
- c9 BIGINT UNSIGNED NOT NULL,
- c10 VARCHAR NOT NULL,
- c11 FLOAT NOT NULL,
- c12 DOUBLE NOT NULL,
- c13 VARCHAR NOT NULL
-)
-STORED AS CSV
-WITH HEADER ROW
-LOCATION '../../testing/data/csv/aggregate_test_100.csv'
-
#######
# Error tests
#######
@@ -719,7 +699,7 @@ true
# csv_query_cube_avg
query TIR
-SELECT c1, c2, AVG(c3) FROM aggregate_test_100_by_sql GROUP BY CUBE (c1, c2) ORDER BY c1, c2
+SELECT c1, c2, AVG(c3) FROM aggregate_test_100 GROUP BY CUBE (c1, c2) ORDER BY c1, c2
----
a 1 -17.6
a 2 -15.333333333333
@@ -760,7 +740,7 @@ NULL NULL 7.81
# csv_query_rollup_avg
query TIIR
-SELECT c1, c2, c3, AVG(c4) FROM aggregate_test_100_by_sql WHERE c1 IN ('a', 'b', NULL) GROUP BY ROLLUP (c1, c2, c3) ORDER BY c1, c2, c3
+SELECT c1, c2, c3, AVG(c4) FROM aggregate_test_100 WHERE c1 IN ('a', 'b', NULL) GROUP BY ROLLUP (c1, c2, c3) ORDER BY c1, c2, c3
----
a 1 -85 -15154
a 1 -56 8692
@@ -818,7 +798,7 @@ NULL NULL NULL 3833.525
# csv_query_groupingsets_avg
query TIIR
SELECT c1, c2, c3, AVG(c4)
-FROM aggregate_test_100_by_sql
+FROM aggregate_test_100
WHERE c1 IN ('a', 'b', NULL)
GROUP BY GROUPING SETS ((c1), (c1,c2), (c1,c2,c3))
ORDER BY c1, c2, c3
@@ -878,7 +858,7 @@ b NULL NULL 7732.315789473684
# csv_query_singlecol_with_rollup_avg
query TIIR
SELECT c1, c2, c3, AVG(c4)
-FROM aggregate_test_100_by_sql
+FROM aggregate_test_100
WHERE c1 IN ('a', 'b', NULL)
GROUP BY c1, ROLLUP (c2, c3)
ORDER BY c1, c2, c3