clickhouse 可以通过设置一些参数 让展示的效果更加符合标准SQL,但是可能(maybe)会更慢一些。
SET join_use_nulls=1; -- introduced long ago
SET cast_keep_nullable=1; -- introduced in 20.5
SET union_default_mode='DISTINCT'; -- introduced in 21.1
SET allow_experimental_window_functions=1; --introduced in 21.3
SET prefer_column_name_to_alias=1; --introduced in 21.4;
参考:
https://kb.altinity.com/altinity-kb-queries-and-syntax/ansi-sql-mode