Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
User report sqlserver as data source didn't show databases. Following is his email:
Hi,
I followed all the steps in this url http://kylin.apache.org/docs/tutorial/setup_jdbc_datasource.html , but when i click on Load table button or Load table from tree i don't seem to have any tables loaded from the SQL Server data source.There are no errors/exceptions in the logs too.
kylin.properties:
kylin.source.default=8
kylin.source.jdbc.connection-url=jdbc:sqlserver://hostname:1433;database=sample
kylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
kylin.source.jdbc.dialect=mssql
kylin.source.jdbc.user=user
kylin.source.jdbc.pass=pass
kylin.source.jdbc.sqoop-home=sqoophome
kylin.source.jdbc.filed-delimiter=|
kylin.source.jdbc.sqoop-mapper-num=4
I reproduce this bug in my dev env. And I find this question was caused by SQLServerJdbcMetadata. I have modified SQLServerJdbcMetadata and databases could be showed.
My env: SqlServer version is 2017, and JDBC Driver version is
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.4.0.jre8</version>
</dependency>
Attachments
Attachments
Issue Links
- links to