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, 奥威软件 <[email protected]<mailto:[email protected]>> wrote: 确定没有写错dialect [cid:[email protected]] sql.enable-quote-all-identifiers = false 放在那里的，放在kylin.properties里不生效 如果不是这样用的，要怎么用？ 谢谢 [cid:[email protected]] ------------------ 原始邮件 ------------------ 发件人: "张 佑铖"<[email protected]<mailto:[email protected]>>; 发送时间: 2019年2月28日(星期四) 晚上6:06 收件人: "[email protected]<mailto:[email protected]>"<[email protected]<mailto:[email protected]>>; 主题: 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，“奥威软件”<[email protected]<mailto:[email protected]>> 写入: 请问有详细的操作说明文档吗？ datasource_sdk能解决kylin生成的sql查询语语句带有 ` 问题吗？ ------------------ 原始邮件 ------------------ 发件人: "PENG Zhengshuai"<[email protected]<mailto:[email protected]>>; 发送时间: 2019年2月28日(星期四) 下午2:13 收件人: "[email protected]<mailto:[email protected]>"<[email protected]<mailto:[email protected]>>; 主题: 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, 奥威软件 <[email protected]<mailto:[email protected]><mailto:[email protected]>> wrote: kylin连接sqlserver数据库： kylin生成的sql语句有反单引号 `, 查询sqlserver报错了 [cid:[email protected]] 将查询语句单独拿出来，并删除反单引号 ` ，执行语句是成功的
