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: 奥威软件 <3513797...@qq.com> Reply-To: "dev@kylin.apache.org" <dev@kylin.apache.org> Date: Wednesday, February 27, 2019 at 21:54 To: dev <dev@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