Clickhouse settings about clickhouse HOT 3 CLOSED

Hi,
You can pass them in config section:

const clickhouse = new ClickHouse({
...
    config: {
      join_use_nulls: 1
   }
});

Or in query:

clickhouse.query('SELECT * FROM table SSETTINGS join_use_nulls=1');

from clickhouse.

Ok, thank you very much. And I have one question yet. Lib supports all available setting? Because I attempt set two properties by first approach: date_time_input_format and date_time_output_format. First property sets without problem, but second throws an error: "404: Code: 115, e.displayText() = DB::Exception: Unknown setting date_time_output_format (version 20.8.12.2 (official build))".

from clickhouse.

The lib sends any setting which you pass to config. Maybe your version of database does not support this option. Would you try to use date_time_output_format in native clickhouse-client?

from clickhouse.