Re: 回复： kylin连接sqlserver数据库： kylin生成的sql语句有反单引号 `, 查询sqlserver报错了

Thu, 28 Feb 2019 02:07:19 -0800 

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]> 写入:



    请问有详细的操作说明文档吗？

    

    

    datasource_sdk能解决kylin生成的sql查询语语句带有 ` 问题吗？

    

    

    ------------------ 原始邮件 ------------------

    发件人: "PENG Zhengshuai"<[email protected]>;

    发送时间: 2019年2月28日(星期四) 下午2:13

    收件人: "[email protected]"<[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]>> wrote:

    

    kylin连接sqlserver数据库： kylin生成的sql语句有反单引号 `,  查询sqlserver报错了

    [cid:[email protected]]

    

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

Reply via email to