v.23.8Improvement

Enhance clickhouse-local with Positional Options and Global UDF Settings

For clickhouse-local allow positional options and populate global UDF settings (user_scripts_path and user_defined_executable_functions_config). #52643 (Yakov Olkhovskiy).
Added support for positional options in clickhouse-local and enabled automatic population of global UDF settings including user_scripts_path and user_defined_executable_functions_config.

Why it matters

This feature improves the usability of clickhouse-local by allowing users to provide positional command-line options and seamlessly configure global User Defined Functions (UDF) settings. It solves the problem of manually specifying these UDF configurations, enhancing the integration and execution of user-defined scripts and executable functions within clickhouse-local environments.

How to use it

When using clickhouse-local, simply provide positional options as part of the command invocation. The tool will automatically populate the global UDF settings based on configured paths such as user_scripts_path and the user_defined_executable_functions_config file, enabling UDFs without additional manual configuration.