HAWQ-1122. Remove unused file load.sql Through the file content we know it uses personal absolute path, which can't be used by others. DisableXform/EnableXform are already built-in functions if GPDB is built with Orca. So we can safely delete this file.
This is cherry-picked from greenplum-db/gpdb@1033c5362f19f0121eddf314a49b319f3582aa9e Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/95e3fe82 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/95e3fe82 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/95e3fe82 Branch: refs/heads/master Commit: 95e3fe82e59297ef2451099b73abcf0802c97743 Parents: be5fb1a Author: Haisheng Yuan <[email protected]> Authored: Sun Aug 14 10:39:32 2016 -0700 Committer: rlei <[email protected]> Committed: Fri Oct 28 11:52:20 2016 +0800 ---------------------------------------------------------------------- src/backend/gpopt/utils/load.sql | 75 ----------------------------------- 1 file changed, 75 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/95e3fe82/src/backend/gpopt/utils/load.sql ---------------------------------------------------------------------- diff --git a/src/backend/gpopt/utils/load.sql b/src/backend/gpopt/utils/load.sql deleted file mode 100644 index bfe7d67..0000000 --- a/src/backend/gpopt/utils/load.sql +++ /dev/null @@ -1,75 +0,0 @@ -drop schema if exists gpoptutils cascade; - -create schema gpoptutils; - -create function gpoptutils.DumpPlan(text) returns bytea as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpPlan' -language c strict; - -create function gpoptutils.RestorePlan(bytea) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestorePlan' -language c strict; - -create function gpoptutils.DumpPlanToFile(text, text) returns int as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpPlanToFile' -language c strict; - -create function gpoptutils.RestorePlanFromFile(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestorePlanFromFile' -language c strict; - -create function gpoptutils.RestorePlanDXL(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestorePlanDXL' language c strict; - -create function gpoptutils.RestorePlanFromDXLFile(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestorePlanFromDXLFile' language c strict; - -create function gpoptutils.DumpQuery(text) returns bytea as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpQuery' -language c strict; - -create function gpoptutils.DumpQueryToFile(text, text) returns int as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpQueryToFile' -language c strict; - -create function gpoptutils.RestoreQueryFromFile(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestoreQueryFromFile' -language c strict; - -create function gpoptutils.DumpQueryDXL(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpQueryDXL' -language c strict; - -create function gpoptutils.DumpQueryToDXLFile(text, text) returns int as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpQueryToDXLFile' -language c strict; - -create function gpoptutils.RestoreQueryDXL(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestoreQueryDXL' language c strict; - -create function gpoptutils.RestoreQueryFromDXLFile(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'RestoreQueryFromDXLFile' language c strict; - -create function gpoptutils.Optimize(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'Optimize' -language c strict; - -create function gpoptutils.DumpMDObjDXL(Oid) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpMDObjDXL' -language c strict; - -create function gpoptutils.DumpCatalogDXL(text) returns int as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpCatalogDXL' -language c strict; - -create function gpoptutils.DumpRelStatsDXL(Oid) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DumpRelStatsDXL' -language c strict; - - -CREATE OR REPLACE FUNCTION gp_partition_propagation(int, oid) -RETURNS void -AS '$libdir/gp_partition_functions.so', 'gp_partition_propagation_wrapper' LANGUAGE C STRICT; - -CREATE OR REPLACE FUNCTION gp_partition_selection(oid, anyelement) -RETURNS oid -AS '$libdir/gp_partition_functions.so', 'gp_partition_selection_wrapper' LANGUAGE C STRICT; - -CREATE OR REPLACE FUNCTION gp_partition_expansion(oid) -RETURNS setof oid -AS '$libdir/gp_partition_functions.so', 'gp_partition_expansion_wrapper' LANGUAGE C STRICT; - -CREATE OR REPLACE FUNCTION gp_partition_inverse(oid) -RETURNS setof record -AS '$libdir/gp_partition_functions.so', 'gp_partition_inverse_wrapper' LANGUAGE C STRICT; - -create or replace function gpoptutils.DisableXform(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'DisableXform' -language c strict; - -create or replace function gpoptutils.EnableXform(text) returns text as '/Users/solimm1/greenplum-db-devel/lib/libgpoptudf.dylib', 'EnableXform' -language c strict; - -
