sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表

[奥威软件 <35...@qq.com>]

Hi,
sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表信息

数据源查询的时候都是前缀 dbo









当表的前缀不是dbo的时候
kylin可以读取表数据



 请帮忙看下怎么解决，谢谢！


 Best regards
-- 
Regards!
Aron Tao

Re: sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表

[Xiaoxiang Yu <xi...@kyligence.io>]

Hi,
    We cannot see your  screenshots. But this is my solution, hope this may help you.(Following steps have be test at my dev env.)



  1.  copy mssql-jdbc-6.4.0.jre8.jar to your $KYLIN_HOME/lib
  2.  add following config in kylin.properties or Project Level
  3.  start Kylin process and import table



kylin.source.default


16


kylin.source.jdbc.adaptor


org.apache.kylin.sdk.datasource.adaptor.DefaultAdaptor


kylin.source.jdbc.connection-url


jdbc:sqlserver://XXX.com:1433;database=sample


kylin.source.jdbc.dialect


mssql


kylin.source.jdbc.driver


com.microsoft.sqlserver.jdbc.SQLServerDriver


kylin.source.jdbc.pass


XXX


kylin.source.jdbc.sqoop-home


/opt/cloudera/parcels/CDH-5.15.1-1.cdh5.15.1.p0.4


kylin.source.jdbc.user


root



For screenshots, refer to: https://github.com/hit-lacus/hit-lacus.github.io/issues/32#issuecomment-469134060
If you find any mistakes, please let me know. Thank you.

----------------
Best wishes,
Xiaoxiang Yu


From: 奥威软件 <35...@qq.com>
Reply-To: "dev@kylin.apache.org" <de...@kylin.apache.org>
Date: Wednesday, February 27, 2019 at 21:54
To: dev <de...@kylin.apache.org>
Subject: sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表

 Hi,
sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表信息
[cid:2AFCFD0C@78E74533.9E96765C]
数据源查询的时候都是前缀 dbo

[cid:31FEFC0B@7518E300.9E96765C]



当表的前缀不是dbo的时候
kylin可以读取表数据
[cid:2D00F70A@DB1CFE19.9E96765C]

 请帮忙看下怎么解决，谢谢！

 Best regards
--
Regards!
Aron Tao