input_format_null_as_default flag not available as a valid connection query param

[thiagohora]

Describe your feedback

I have a use case where I would like to set this property input_format_null_as_default to false; however, as it is not a valid query param option, I would need to execute it in every request.

[chernser]

@thiagohora, thank you for your feedback!

Would next code work for you:

       Client client = new Client.Builder()
                .addEndpoint(node.toUri().toString())
                .setUsername("default")
                .setPassword("")
                .setOption("input_format_null_as_default ", "false")
                .build();

Here is another example: https://github.com/ClickHouse/clickhouse-java/blob/main/client-v2/src/test/java/com/clickhouse/client/ClientTests.java#L69

[thiagohora]

I think so. However, typically, frameworks abstract the instantiation of the client/connection factory. Just a suggestion, but I believe this should be supported via connection string as a queryparam

[mshustov]

Just a suggestion, but I believe this should be supported via connection string as a queryparam

@chernser, that's a valid point. Other language clients support this method.
python client
nodejs client

@chernser Once it's implemented, could you also update the language client spec with this requirement?

[chernser]

@mshustov will do and will update the language spec.