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]



    将查询语句单独拿出来,并删除反单引号 ` ,执行语句是成功的



Reply via email to