1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
-- lets change the context
use role sysadmin;
use database ttips;
use schema udfs;

-- creating a simple SQL udf
create or replace secure function simple_sql_udf()
returns string
language SQL
comment = 'This is simple sql language udf'
as
$$
    select 'simple sql language udf'
$$;

-- creating a simple javascript udf
create or replace secure function simple_js_udf()
returns string
language javascript
comment = 'This is simple JavaScript language udf'
as
$$
    return 'simple javascript language udf'
$$;

-- just example, we will cover later in this video
create function my_java_udf()
    returns double
    language java
    imports = ('@~/java-udf/MyUDF.jar')
    handler = 'MyJavaUDF.myHandler';

-- see the function output
select simple_sql_udf(),simple_js_udf();

-- lets see them and validate the columns 
-- and how the language is captured.
show functions like 'SIMPLE%';


-- lets describe the 
desc function simple_sql_udf();
desc function simple_js_udf();