Clickhouse sql语句添加分号报错 DB::Exception: Syntax error (Multi-statements are not allowed)

问题描述

使用Clickhouse的客户端查询数据时末尾添加"；"报错，

执行语句：

select * from system.settings where name='max_execution_time' ;

报错信息如下：

Code: 62, e.displayText() = DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 92 (end of query) (line 1, col 92): ;

解决

添加两个分号，问题解决！！

select * from system.settings where name='max_execution_time' ;;