You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by fo...@apache.org on 2015/12/07 19:35:30 UTC
incubator-hawq git commit: HAWQ-225. Clearing created table in test
case to fix ICG
Repository: incubator-hawq
Updated Branches:
refs/heads/master bd126aa0f -> 871996000
HAWQ-225. Clearing created table in test case to fix ICG
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/87199600
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/87199600
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/87199600
Branch: refs/heads/master
Commit: 871996000608149e1becb5b58b23fffe1160115c
Parents: bd126aa
Author: Karthikeyan Jambu Rajaraman <kr...@pivotal.io>
Authored: Fri Dec 4 20:30:22 2015 -0800
Committer: Karthikeyan Jambu Rajaraman <kr...@pivotal.io>
Committed: Mon Dec 7 09:55:21 2015 -0800
----------------------------------------------------------------------
src/test/regress/expected/aggregate_with_groupingsets.out | 6 ++++--
src/test/regress/sql/aggregate_with_groupingsets.sql | 7 ++++++-
2 files changed, 10 insertions(+), 3 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/87199600/src/test/regress/expected/aggregate_with_groupingsets.out
----------------------------------------------------------------------
diff --git a/src/test/regress/expected/aggregate_with_groupingsets.out b/src/test/regress/expected/aggregate_with_groupingsets.out
index ccec222..2bc4545 100644
--- a/src/test/regress/expected/aggregate_with_groupingsets.out
+++ b/src/test/regress/expected/aggregate_with_groupingsets.out
@@ -7,8 +7,6 @@ NOTICE: table "foo" does not exist, skipping
--- Create new table foo
---
CREATE TABLE foo(type INTEGER, prod VARCHAR, quantity NUMERIC);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'type' as the Greenplum Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
---
--- Insert some value
---
@@ -35,3 +33,7 @@ FROM
| Bed | 300
(6 rows)
+---
+--- Drop created table
+---
+DROP TABLE IF EXISTS foo;
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/87199600/src/test/regress/sql/aggregate_with_groupingsets.sql
----------------------------------------------------------------------
diff --git a/src/test/regress/sql/aggregate_with_groupingsets.sql b/src/test/regress/sql/aggregate_with_groupingsets.sql
index 2d1b95c..9db642b 100644
--- a/src/test/regress/sql/aggregate_with_groupingsets.sql
+++ b/src/test/regress/sql/aggregate_with_groupingsets.sql
@@ -24,4 +24,9 @@ FROM
SELECT type, prod, quantity
FROM foo F1
LIMIT 3
-) F2 GROUP BY GROUPING SETS((type, prod), (prod)) ORDER BY type, s_quant;
\ No newline at end of file
+) F2 GROUP BY GROUPING SETS((type, prod), (prod)) ORDER BY type, s_quant;
+
+---
+--- Drop created table
+---
+DROP TABLE IF EXISTS foo;
\ No newline at end of file