You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 奥威软件 <35...@qq.com> on 2019/02/28 10:36:52 UTC
回复: 回复: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
确定没有写错dialect
sql.enable-quote-all-identifiers = false 放在那里的,放在kylin.properties里不生效
如果不是这样用的,要怎么用? 谢谢
------------------ 原始邮件 ------------------
发件人: "张 佑铖"<ed...@hotmail.com>;
发送时间: 2019年2月28日(星期四) 晚上6:06
收件人: "dev@kylin.apache.org"<de...@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,“奥威软件”<35...@qq.com> 写入:
请问有详细的操作说明文档吗?
datasource_sdk能解决kylin生成的sql查询语语句带有 ` 问题吗?
------------------ 原始邮件 ------------------
发件人: "PENG Zhengshuai"<co...@hotmail.com>;
发送时间: 2019年2月28日(星期四) 下午2:13
收件人: "dev@kylin.apache.org"<de...@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, 奥威软件 <35...@qq.com>> wrote:
kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
[cid:2BFC6A82@35529157.4F73775C]
将查询语句单独拿出来,并删除反单引号 ` ,执行语句是成功的
Re: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
Posted by Rongchuan Jin <ro...@kyligence.io>.
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”<co...@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, 奥威软件 <35...@qq.com>> wrote:
确定没有写错dialect
[cid:3400FE11@D13FCE4E.C4B9775C]
sql.enable-quote-all-identifiers = false 放在那里的,放在kylin.properties里不生效
如果不是这样用的,要怎么用? 谢谢
[cid:2F04F80E@5FB6275E.C4B9775C]
------------------ 原始邮件 ------------------
发件人: "张 佑铖"<ed...@hotmail.com>>;
发送时间: 2019年2月28日(星期四) 晚上6:06
收件人: "dev@kylin.apache.org<ma...@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,“奥威软件”<35...@qq.com>> 写入:
请问有详细的操作说明文档吗?
datasource_sdk能解决kylin生成的sql查询语语句带有 ` 问题吗?
------------------ 原始邮件 ------------------
发件人: "PENG Zhengshuai"<co...@hotmail.com>>;
发送时间: 2019年2月28日(星期四) 下午2:13
收件人: "dev@kylin.apache.org<ma...@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, 奥威软件 <35...@qq.com>> wrote:
kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
[cid:2BFC6A82@35529157.4F73775C]
将查询语句单独拿出来,并删除反单引号 ` ,执行语句是成功的
Re: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
Posted by PENG Zhengshuai <co...@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, 奥威软件 <35...@qq.com>> wrote:
确定没有写错dialect
[cid:3400FE11@D13FCE4E.C4B9775C]
sql.enable-quote-all-identifiers = false 放在那里的,放在kylin.properties里不生效
如果不是这样用的,要怎么用? 谢谢
[cid:2F04F80E@5FB6275E.C4B9775C]
------------------ 原始邮件 ------------------
发件人: "张 佑铖"<ed...@hotmail.com>>;
发送时间: 2019年2月28日(星期四) 晚上6:06
收件人: "dev@kylin.apache.org<ma...@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,“奥威软件”<35...@qq.com>> 写入:
请问有详细的操作说明文档吗?
datasource_sdk能解决kylin生成的sql查询语语句带有 ` 问题吗?
------------------ 原始邮件 ------------------
发件人: "PENG Zhengshuai"<co...@hotmail.com>>;
发送时间: 2019年2月28日(星期四) 下午2:13
收件人: "dev@kylin.apache.org<ma...@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, 奥威软件 <35...@qq.com>> wrote:
kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了
[cid:2BFC6A82@35529157.4F73775C]
将查询语句单独拿出来,并删除反单引号 ` ,执行语句是成功的