Shulou(Shulou.com)06/01 Report--

The greenplum database (hereinafter referred to as the gp database) supports custom functions. The following is a description of the custom simple functions written by python. The clustering function is more complex, and I feel that it is not suitable to be written in gp database.

The python custom function states that gp can do as long as python can handle row-level data.

Example: python returns multiple rows after processing json.

Create or replace function public.json_parse (data text) returns setof text

AS $$

Import json

Try:

Mydata=json.loads (data)

Except:

Return ['parse error']

Returndata= []

Try:

For people in mydata ['a']:

Returndata.append (people ['b'])

Except:

Return ['223']

Return returndata

$$LANGUAGE plpythonu

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.