S0hfM0B9

1--GRANT USAGE ON LANGUAGE plpythonu TO leadliaison;
2
3create schema if not exists test;
4drop table test.cdb;
5
6create table if not exists test.cdb
7( cdb_sentence varchar(65535) encode lzo
8 )
9 diststyle even;
10
11
12 insert into test.cdb
13 values
14 ('1.2.3.4.6'),
15 ('1.2.3.4.5')
16 ;
17
18
19
20create or replace function f_compare (input_sentence varchar(65535), cdb_sentence varchar(65535))
21RETURNS integer
22STABLE 
23AS $$
24
25#our python code goes here
26import our_compare_library
27return sentenceCompare(input_sentence,cdb_sentence)
28
29$$
30LANGUAGE plpythonu;
31
32
33select f_compare(cdb_sentence,'234')
34from test.cdb;