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: 奥威软件 <[email protected]>
Reply-To: "[email protected]" <[email protected]>
Date: Wednesday, February 27, 2019 at 21:54
To: dev <[email protected]>
Subject: sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表
Hi,
sqlserver jdbc数据源问题： 当table前缀有dbo时，kylin无法读取表信息
[cid:[email protected]]
数据源查询的时候都是前缀 dbo
[cid:[email protected]]
当表的前缀不是dbo的时候
kylin可以读取表数据
[cid:[email protected]]
请帮忙看下怎么解决，谢谢！
Best regards
--
Regards!
Aron Tao
