Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-function below:

CREATE FUNCTION (External) | Databricks Documentation

> CREATE TABLE test(c1 INT);
> INSERT INTO test VALUES (1), (2);


> CREATE FUNCTION simple_udf AS 'SimpleUdf'
    USING JAR '/tmp/SimpleUdf.jar';


> SHOW USER FUNCTIONS;
           function
 
 default.simple_udf


> SELECT simple_udf(c1) AS function_return_value FROM t1;
 function_return_value
 
                    11
                    12


> CREATE TEMPORARY FUNCTION simple_temp_udf AS 'SimpleUdf'
    USING JAR '/tmp/SimpleUdf.jar';




> SHOW USER FUNCTIONS;
           function
 
 default.simple_udf
    simple_temp_udf












> CREATE OR REPLACE FUNCTION simple_udf AS 'SimpleUdfR'
    USING JAR '/tmp/SimpleUdfR.jar';


> SELECT simple_udf(c1) AS function_return_value FROM t1;
 function_return_value
 
                    21
                    22

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4