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”<[email protected]> 写入:

    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]]
    
    
    
        将查询语句单独拿出来，并删除反单引号 ` ，执行语句是成功的

Reply via email to