New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

UDF Functions #4

Open

lmangani opened this issue Aug 6, 2023 · 0 comments

Labels

enhancement help wanted

Contributor

lmangani commented Aug 6, 2023 •

edited

The upcoming releases of ClickHouse allow correct allocation of UDF resources with two new parameters:

user_scripts_path
user_defined_executable_functions_config

#!/usr/bin/env bash

set -e

CUR_DIR=$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)
# shellcheck source=../shell_config.sh
. "$CUR_DIR"/../shell_config.sh

SCRIPTS_DIR=$CUR_DIR/scripts_udf

$CLICKHOUSE_LOCAL -q 'select test_function()' -- --user_scripts_path=$SCRIPTS_DIR --user_defined_executable_functions_config=$SCRIPTS_DIR/function.xml

This will finally allow using the execute binary UDF functions in chDB:

SELECT * FROM executable('./some_script.py', TabSeparated, 'name String', (SELECT name));

Todo

Backport functions chdb Populate global UDF settings ClickHouse PR #52643 chdb-io/chdb#81
Add support for the new parameters in the chdb session binding to leverage this functionality 😃

The text was updated successfully, but these errors were encountered:

lmangani mentioned this issue

Binary UDF Support chdb-io/chdb#80

Closed

lmangani added enhancement help wanted labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment