Repository: incubator-hawq Updated Branches: refs/heads/master 98f7e8e93 -> e6c7fda07
HAWQ-1044. Remove duplicated testcases for hawq resgister usage2 Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/e6c7fda0 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/e6c7fda0 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/e6c7fda0 Branch: refs/heads/master Commit: e6c7fda079828c2b2cdcc56a4fac249933527969 Parents: 98f7e8e Author: Chunling Wang <wangchunlin...@126.com> Authored: Mon Sep 19 17:42:36 2016 +0800 Committer: Ruilong Huo <r...@pivotal.io> Committed: Tue Sep 20 18:24:43 2016 +0800 ---------------------------------------------------------------------- .../ManagementTool/test_hawq_register.cpp | 104 ------------------- 1 file changed, 104 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/e6c7fda0/src/test/feature/ManagementTool/test_hawq_register.cpp ---------------------------------------------------------------------- diff --git a/src/test/feature/ManagementTool/test_hawq_register.cpp b/src/test/feature/ManagementTool/test_hawq_register.cpp index 791b522..123f73c 100644 --- a/src/test/feature/ManagementTool/test_hawq_register.cpp +++ b/src/test/feature/ManagementTool/test_hawq_register.cpp @@ -135,27 +135,6 @@ TEST_F(TestHawqRegister, TestFiles) { util.execute("drop table hawqregister;"); } -TEST_F(TestHawqRegister, TestUsage1HashDistributedTable) { - SQLUtility util; - string rootPath(util.getTestRootPath()); - string relativePath("/ManagementTool/test_hawq_register_hawq.paq"); - string filePath = rootPath + relativePath; - - auto cmd = hawq::test::stringFormat("hadoop fs -put -f %s %s/hawq_register_hawq.paq", filePath.c_str(), getHdfsLocation().c_str()); - EXPECT_EQ(0, Command::getCommandStatus(cmd)); - - util.execute("create table hawqregister(i int) with (appendonly=true, orientation=parquet) distributed by (i);"); - util.query("select * from hawqregister;", 0); - - cmd = hawq::test::stringFormat("hawq register -d %s -f %s/hawq_register_hawq.paq hawqregister", HAWQ_DB, getHdfsLocation().c_str()); - EXPECT_EQ(1, Command::getCommandStatus(cmd)); - util.query("select * from hawqregister;", 0); - - cmd = hawq::test::stringFormat("hadoop fs -rm -r %s %s/hawq_register_hawq.paq", filePath.c_str(), getHdfsLocation().c_str()); - EXPECT_EQ(0, Command::getCommandStatus(cmd)); - util.execute("drop table hawqregister;"); -} - TEST_F(TestHawqRegister, TestUsage1NotParquetFile) { SQLUtility util; string rootPath(util.getTestRootPath()); @@ -232,89 +211,6 @@ TEST_F(TestHawqRegister, TestUsage1NotHDFSPath) { util.execute("drop table hawqregister;"); } -TEST_F(TestHawqRegister, TestUsage2ParquetRandomly) { - SQLUtility util; - util.execute("drop table if exists t;"); - util.execute("drop table if exists nt;"); - util.execute("create table t(i int) with (appendonly=true, orientation=parquet) distributed randomly;"); - util.execute("insert into t values(1), (2), (3);"); - util.query("select * from t;", 3); - EXPECT_EQ(0, Command::getCommandStatus("hawq extract -d " + (string) HAWQ_DB + " -o t.yml testhawqregister_testusage2parquetrandomly.t")); - EXPECT_EQ(0, Command::getCommandStatus("hawq register -d " + (string) HAWQ_DB + " -c t.yml testhawqregister_testusage2parquetrandomly.nt")); - util.query("select * from nt;", 3); - EXPECT_EQ(0, Command::getCommandStatus("rm -rf t.yml")); - util.execute("drop table t;"); - util.execute("drop table nt;"); -} - -TEST_F(TestHawqRegister, TestUsage2ParquetHash1) { - SQLUtility util; - util.execute("drop table if exists t4;"); - util.execute("create table t4(i int) with (appendonly=true, orientation=parquet) distributed by (i);"); - util.execute("insert into t4 values(1), (2), (3);"); - EXPECT_EQ(0, Command::getCommandStatus("hawq extract -d " + (string) HAWQ_DB + " -o t4.yml testhawqregister_testusage2parquethash1.t4")); - EXPECT_EQ(0, Command::getCommandStatus("hawq register -d " + (string) HAWQ_DB + " -c t4.yml testhawqregister_testusage2parquethash1.nt4")); - util.query("select * from nt4;", 3); - EXPECT_EQ(0, Command::getCommandStatus("rm -rf t4.yml")); - util.execute("drop table t4;"); - util.execute("drop table nt4;"); -} - - -TEST_F(TestHawqRegister, TestUsage2ParquetHash2) { - SQLUtility util; - util.execute("drop table if exists t5;"); - util.execute("create table t5(i int, j varchar, k text) with (appendonly=true, orientation=parquet) distributed by (i, k);"); - util.execute("insert into t5 values(1, 'x', 'ab'), (2, 'y', 'cd'), (3, 'z', 'ef');"); - EXPECT_EQ(0, Command::getCommandStatus("hawq extract -d " + (string) HAWQ_DB + " -o t5.yml testhawqregister_testusage2parquethash2.t5")); - EXPECT_EQ(0, Command::getCommandStatus("hawq register -d " + (string) HAWQ_DB + " -c t5.yml testhawqregister_testusage2parquethash2.nt5")); - util.query("select * from nt5;", 3); - EXPECT_EQ(0, Command::getCommandStatus("rm -rf t5.yml")); - util.execute("drop table t5;"); - util.execute("drop table nt5;"); -} - - -TEST_F(TestHawqRegister, TestUsage2AORandom) { - SQLUtility util; - util.execute("drop table if exists t6;"); - util.execute("create table t6(i int) with (appendonly=true, orientation=row) distributed randomly;"); - util.execute("insert into t6 values(1), (2), (3);"); - EXPECT_EQ(0, Command::getCommandStatus("hawq extract -d " + (string) HAWQ_DB + " -o t6.yml testhawqregister_testusage2aorandom.t6")); - EXPECT_EQ(0, Command::getCommandStatus("hawq register -d " + (string) HAWQ_DB + " -c t6.yml testhawqregister_testusage2aorandom.nt6")); - util.query("select * from nt6;", 3); - EXPECT_EQ(0, Command::getCommandStatus("rm -rf t6.yml")); - util.execute("drop table t6;"); - util.execute("drop table nt6;"); -} - -TEST_F(TestHawqRegister, TestUsage2AOHash1) { - SQLUtility util; - util.execute("drop table if exists t7;"); - util.execute("create table t7(i int) with (appendonly=true, orientation=row) distributed by (i);"); - util.execute("insert into t7 values(1), (2), (3);"); - EXPECT_EQ(0, Command::getCommandStatus("hawq extract -d " + (string) HAWQ_DB + " -o t7.yml testhawqregister_testusage2aohash1.t7")); - EXPECT_EQ(0, Command::getCommandStatus("hawq register -d " + (string) HAWQ_DB + " -c t7.yml testhawqregister_testusage2aohash1.nt7")); - util.query("select * from nt7;", 3); - EXPECT_EQ(0, Command::getCommandStatus("rm -rf t7.yml")); - util.execute("drop table t7;"); - util.execute("drop table nt7;"); -} - - -TEST_F(TestHawqRegister, TestUsage2AOHash2) { - SQLUtility util; - util.execute("drop table if exists t8;"); - util.execute("create table t8(i int, j varchar, k text) with (appendonly=true, orientation=row) distributed by (i, k);"); - util.execute("insert into t8 values(1, 'x', 'ab'), (2, 'y', 'cd'), (3, 'z', 'ef');"); - EXPECT_EQ(0, Command::getCommandStatus("hawq extract -d " + (string) HAWQ_DB + " -o t8.yml testhawqregister_testusage2aohash2.t8")); - EXPECT_EQ(0, Command::getCommandStatus("hawq register -d " + (string) HAWQ_DB + " -c t8.yml testhawqregister_testusage2aohash2.nt8")); - util.query("select * from nt8;", 3); - EXPECT_EQ(0, Command::getCommandStatus("rm -rf t8.yml")); - util.execute("drop table t8;"); - util.execute("drop table nt8;"); -} - TEST_F(TestHawqRegister, TestEmptyTable) { SQLUtility util; util.execute("drop table if exists t9;");