Hi, You should put the "sql.enable-quote-all-identifiers = false “ in your mssql.xml as a “PROPERTY”
An example as below: <PROPERTY NAME="sql.enable-quote-all-identifiers" VALUE="false"/> And please make sure you have added the Adaptor for msserver BR PENG Zhengshuai On Feb 28, 2019, at 6:36 PM, 奥威软件 <3513797...@qq.com<mailto:3513797...@qq.com>> wrote: 确定没有写错dialect [cid:3400FE11@D13FCE4E.C4B9775C] sql.enable-quote-all-identifiers = false 放在那里的,放在kylin.properties里不生效 如果不是这样用的,要怎么用? 谢谢 [cid:2F04F80E@5FB6275E.C4B9775C] ------------------ 原始邮件 ------------------ 发件人: "张 佑铖"<edouard...@hotmail.com<mailto:edouard...@hotmail.com>>; 发送时间: 2019年2月28日(星期四) 晚上6:06 收件人: "dev@kylin.apache.org<mailto:dev@kylin.apache.org>"<dev@kylin.apache.org<mailto:dev@kylin.apache.org>>; 主题: Re: 回复: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了 Hi, You should create a configuration file maybe name mssql.xml to define configuration to adapt Microsoft Sqlserver. As you mentioned I guess you define DIALECT="mysql", actually mysql use ` as quote. You should define DIALECT="mssql" in mssql.xml. And if you don't want to enable quote, you can set "sql.enable-quote-all-identifiers = false" to disable quote. Best Regards Youcheng Zhang 在 2019/2/28 下午3:53,“奥威软件”<3513797...@qq.com<mailto:3513797...@qq.com>> 写入: 请问有详细的操作说明文档吗? datasource_sdk能解决kylin生成的sql查询语语句带有 ` 问题吗? ------------------ 原始邮件 ------------------ 发件人: "PENG Zhengshuai"<cosine...@hotmail.com<mailto:cosine...@hotmail.com>>; 发送时间: 2019年2月28日(星期四) 下午2:13 收件人: "dev@kylin.apache.org<mailto:dev@kylin.apache.org>"<dev@kylin.apache.org<mailto:dev@kylin.apache.org>>; 主题: Re: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了 Hi, If you want to connect to RDBMS, you need a datasource-sdk for specific RDBMS. Please refer to http://kylin.apache.org/development/datasource_sdk.html BR PENG Zhengshuai On Feb 28, 2019, at 1:36 PM, 奥威软件 <3513797...@qq.com<mailto:3513797...@qq.com><mailto:3513797...@qq.com>> wrote: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了 [cid:2BFC6A82@35529157.4F73775C] 将查询语句单独拿出来,并删除反单引号 ` ,执行语句是成功的