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

Thu, 28 Feb 2019 03:46:15 -0800 

Hi,
        As far as I know, there is only MySQL adaptor for Apache Kylin. If you 
want to use adaptor for SQLServer. Please refer to 
http://download.kyligence.io/#/download . You just need to register a Kyligence 
Account.

Best Regards
Rongchuan.Jin

 

在 2019/2/28 下午7:39，“PENG Zhengshuai”<cosine...@hotmail.com> 写入:

    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