kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 张 佑铖 <edouard...@hotmail.com>
Subject Re: 回复: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
Date Thu, 28 Feb 2019 10:06:56 GMT
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,“奥威软件”<3513797855@qq.com> 写入:



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

    

    

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

    

    

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

    发件人: "PENG Zhengshuai"<cosinepzs@hotmail.com>;

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

    收件人: "dev@kylin.apache.org"<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, 奥威软件 <3513797855@qq.com<mailto:3513797855@qq.com>>
wrote:

    

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

    [cid:2BFC6A82@35529157.4F73775C]

    

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


Mime
View raw message