​(​2​,​ ​'​changchang​'),​ ​(​3​,​ ​'​guoguo​'); INSERT INTO classes VALUES ​(​1​,​ ​'​math​',​ ​1​),​ ​(​2​,​ ​'​math​',​ ​2​),​ ​(​3​,​ ​'​physics​',​ ​3​); 以下面的SQL为例子，了解 SQL 在 Greenplum 中的执行过程： SELECT

processing & data storage In-Database Functions Machine learning & statistics & math & graph & utilities Input validation & pre-processing

REPLACE FUNCTION pylog100() RETURNS double precision AS $$ # container: plc_python_shared import math Caution Changing gp_vmem_idle_resource_timeout value, might affect performance due to resource resources other than Docker containers. VMware Greenplum 6 Documentation VMware by Broadcom 958 return math.log10(100) $$ LANGUAGE plcontainer; This is an example of a similar function using the plc_r_shared OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER

FUNCTION pylog100() RETURNS double precision AS $$ # container: plc_python_shared import math return math.log10(100) $$ LANGUAGE plcontainer; This is an example of a similar function using the plc_r_shared OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER - {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)

FUNCTION pylog100() RETURNS double precision AS $$ # container: plc_python_shared import math return math.log10(100) $$ LANGUAGE plcontainer; This is an example of a similar function using the plc_r_shared OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER - {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)

FUNCTION pylog100() RETURNS double precision AS $$ # container: plc_python_shared import math return math.log10(100) $$ LANGUAGE plcontainer; This is an example of a similar function using the plc_r_shared OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER - {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)

FUNCTION pylog100() RETURNS double precision AS $$ # container: plc_python_shared import math return math.log10(100) $$ LANGUAGE plcontainer; This is an example of a similar function using the plc_r_shared OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)

FUNCTION pylog100() RETURNS double precision AS $$ # container: plc_python_shared import math return math.log10(100) $$ LANGUAGE plcontainer; This is an example of a similar function using the plc_r_shared OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)

OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)

OWNER TO joe; To change the schema of the function sqrt for type integer to math: ALTER FUNCTION sqrt(integer) SET SCHEMA math; To adjust the search path that is automatically set for a function: ALTER {1,1,1,1,2,4,1,2,2,2,1,1,1,1,1,5,2,1,1} The remainder of the classification process is vector math. The count is turned into a weight that reflects Term Frequency / Inverse Document Frequency (tf/idf)