ClickHouse / ClickHouse/ClickHouse

Add <format_tsv_null_representation> or a <format_settings> section for UDFs (of the .XML sort)

Open
#57,431 0 comments 0 reactions 0 assignees View on GitHub
comp-udf external feature
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

I would think since the XML for a UDF can accept TabSeparated that it should also be possible to specify the setting nil too.
In my actual example, I’d like the empty string. If I use settings format_tsv_null_representation='' at the query level, things work.

```


executable
myFunction

String


String

Nullable(Decimal64(9))
TabSeparated

my_script.sh
0
1
throw

```

See discussion here: https://clickhousedb.slack.com/archives/CU478UEQZ/p1701454353401719?thread_ts=1701275038.258609&cid=CU478UEQZ

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.