Configuring profiles via extraConfig does not work.
For example, after adding profiles.default.join_use_nulls = 1 does not have any effect.
I think this might be caused by the defaultExtraConfig setting user_directories.users_xml.path, which causes Clickhouse to ignore user and profiles settings in the global config: https://clickhouse.com/docs/operations/configuration-files#user-settings.
I was able to work around it by overriding user_directories.users_xml.path to a path in dataDir and setting the options in there.
Configuring profiles via
extraConfigdoes not work.For example, after adding
profiles.default.join_use_nulls = 1does not have any effect.I think this might be caused by the
defaultExtraConfigsettinguser_directories.users_xml.path, which causes Clickhouse to ignore user and profiles settings in the global config: https://clickhouse.com/docs/operations/configuration-files#user-settings.I was able to work around it by overriding
user_directories.users_xml.pathto a path indataDirand setting the options in there.