我在greenplum6Created a stored procedure in,使用的是plpythonu擴展語言,I used the following code to generate aDataFrame:
CREATE OR REPLACE FUNCTION myFunc02()
RETURNS void AS
$$
import pandas as pd
rv = plpy.execute('SELECT * FROM test_py_01')
df = pd.DataFrame(rv[0:])
...DataFrame計算....
for index, row in df.iterrows():
plan = plpy.prepare("insert into test_py_02 values($1,$2,$3)",['int8','text','text'])
plpy.execute(plan, [row.c1,row.c2,row.c3])
$$ LANGUAGE 'plpythonu';
On the official website I only findplpy.executeCan write a single piece of data to a database table,But the efficiency of writing a large amount of data circularly is too poor,Is there a way to batch write it??A friend asked why not to usePython腳本,由於一些原因,我只能使用GPwrite stored procedureplpythonu代碼,and I want to be able to useGPperformance computing power,希望大家給個思路,先謝謝大家了.
Summary of related topics of binary search tree (II) force deduction Python
above Binary search tree rela
How to use Python to see the vision of goddess? How can a beautiful woman look more energetic ~ (with complete source code)
well ~well ~well ~ Im not in g