Hi Gladson,
I reproduce the same situation in my dev env,. The question is caused by
org.apache.kylin.source.jdbc.metadata.SQLServerJdbcMetadata.java(Line:53)
didn't report null in "TABLE_CATALOG" column.
This can be verified by following code:
String
sqlServerUrl="jdbc:sqlserver://cdh1.cloudera.com:1433;user=SA;password=Kyligence2019;DatabaseName=xiaoxiang_test";
Connection con = DriverManager.getConnection(sqlServerUrl);
DatabaseMetaData meta = con.getMetaData();
System.out.println("====");
ResultSet rs1 = meta.getCatalogs();
while(rs1.next()){
System.out.println(String.format("Catalog \t%s", rs1.getString(1)));
}
rs1 = meta.getSchemas();
System.out.println("====");
while(rs1.next()){
System.out.println(String.format("Schemas \t%s\t%s",
rs1.getString(1), rs1.getString(2)));
}
Output as follow:
====
Catalog master
Catalog model
Catalog msdb
Catalog tempdb
Catalog xiaoxiang_test
====
Schemas db_accessadmin null
Schemas db_backupoperator null
Schemas db_datareader null
Schemas db_datawriter null
Schemas db_ddladmin null
Schemas db_denydatareader null
Schemas db_denydatawriter null
Schemas db_owner null
Schemas db_securityadmin null
Schemas dbo null
Schemas guest null
Schemas INFORMATION_SCHEMA null
Schemas sys null
By the way, which version of sqlserver as you use, and which version of jdbc
driver are you use? Maybe we can try to fix this by change the way of fetching
metadata(catalog) in SQLServerJdbcMetadata.
If you find any mistake, please let me know.
----------------
Best wishes,
Xiaoxiang Yu
On [DATE], "[NAME]" <[ADDRESS]> wrote:
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=8kylin.source.jdbc.connection-url=jdbc:sqlserver://hostname:1433;database=samplekylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverkylin.source.jdbc.dialect=mssqlkylin.source.jdbc.user=userkylin.source.jdbc.pass=passkylin.source.jdbc.sqoop-home=sqoophomekylin.source.jdbc.filed-delimiter=|kylin.source.jdbc.sqoop-mapper-num=4
kylin.log
2019-01-28 22:52:27,948 DEBUG [http-bio-7070-exec-1] common.KylinConfig:328
: KYLIN_CONF property was not set, will seek KYLIN_HOME env variable2019-01-28
22:52:28,017 INFO [FetcherRunner 992042775-44]
threadpool.DefaultFetcherRunner:94 : Job Fetcher: 0 should running, 0 actual
running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, 0
others2019-01-28 22:52:28,123 INFO [http-bio-7070-exec-4]
common.KylinConfig:455 : Creating new manager instance of class
org.apache.kylin.metadata.project.ProjectManager2019-01-28 22:52:28,125 INFO
[http-bio-7070-exec-4] project.ProjectManager:81 : Initializing ProjectManager
with metadata url kylin_metadata@hbase2019-01-28 22:52:28,129 DEBUG
[http-bio-7070-exec-4] cachesync.CachedCrudAssist:118 : Reloading
ProjectInstance from
kylin_metadata(key='/project')@kylin_metadata@hbase2019-01-28 22:52:28,188
DEBUG [http-bio-7070-exec-4] cachesync.CachedCrudAssist:127 : Loaded 1
ProjectInstance(s) out of 1 resource2019-01-28 22:52:28,304 DEBUG
[http-bio-7070-exec-5] project.ProjectL2Cache:198 : Loading L2 project cache
for Testing2019-01-28 22:52:28,325 INFO [http-bio-7070-exec-5]
common.KylinConfig:455 : Creating new manager instance of class
org.apache.kylin.metadata.TableMetadataManager2019-01-28 22:52:28,326 DEBUG
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableDesc
from kylin_metadata(key='/table')@kylin_metadata@hbase2019-01-28 22:52:28,333
INFO [http-bio-7070-exec-1] common.KylinConfig:455 : Creating new manager
instance of class org.apache.kylin.metadata.model.DataModelManager2019-01-28
22:52:28,360 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 :
Loaded 0 TableDesc(s) out of 0 resource2019-01-28 22:52:28,361 DEBUG
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableExtDesc
from kylin_metadata(key='/table_exd')@kylin_metadata@hbase2019-01-28
22:52:28,391 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 :
Loaded 0 TableExtDesc(s) out of 0 resource2019-01-28 22:52:28,392 DEBUG
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading
ExternalFilterDesc from
kylin_metadata(key='/ext_filter')@kylin_metadata@hbase2019-01-28 22:52:28,421
DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0
ExternalFilterDesc(s) out of 0 resource2019-01-28 22:52:28,423 DEBUG
[http-bio-7070-exec-1] cachesync.CachedCrudAssist:118 : Reloading DataModelDesc
from kylin_metadata(key='/model_desc')@kylin_metadata@hbase2019-01-28
22:52:28,428 DEBUG [http-bio-7070-exec-1] cachesync.CachedCrudAssist:127 :
Loaded 0 DataModelDesc(s) out of 0 resource2019-01-28 22:52:28,434 INFO
[http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance
of class org.apache.kylin.metadata.realization.RealizationRegistry2019-01-28
22:52:28,435 INFO [http-bio-7070-exec-5] realization.RealizationRegistry:54 :
Initializing RealizationRegistry with metadata url
kylin_metadata@hbase2019-01-28 22:52:28,455 INFO [http-bio-7070-exec-5]
common.KylinConfig:455 : Creating new manager instance of class
org.apache.kylin.cube.CubeManager2019-01-28 22:52:28,468 INFO
[http-bio-7070-exec-5] cube.CubeManager:133 : Initializing CubeManager with
config kylin_metadata@hbase2019-01-28 22:52:28,469 DEBUG [http-bio-7070-exec-5]
cachesync.CachedCrudAssist:118 : Reloading CubeInstance from
kylin_metadata(key='/cube')@kylin_metadata@hbase2019-01-28 22:52:28,475 DEBUG
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0
CubeInstance(s) out of 0 resource2019-01-28 22:52:28,479 INFO
[http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance
of class org.apache.kylin.storage.hybrid.HybridManager2019-01-28 22:52:28,480
INFO [http-bio-7070-exec-5] hybrid.HybridManager:71 : Initializing
HybridManager with config kylin_metadata@hbase2019-01-28 22:52:28,480 DEBUG
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading
HybridInstance from
kylin_metadata(key='/hybrid')@kylin_metadata@hbase2019-01-28 22:52:28,483 DEBUG
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0
HybridInstance(s) out of 0 resource2019-01-28 22:52:28,484 INFO
[http-bio-7070-exec-5] realization.RealizationRegistry:81 : RealizationRegistry
is {HYBRID=org.apache.kylin.storage.hybrid.HybridManager@39367d9d,
CUBE=org.apache.kylin.cube.CubeManager@1db7a56b}2019-01-28 22:52:47,405 INFO
[http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance
of class org.apache.kylin.source.SourceManager2019-01-28 22:52:58,013 INFO
[FetcherRunner 992042775-44] threadpool.DefaultFetcherRunner:94 : Job Fetcher:
0 should running, 0 actual running, 0 stopped, 0 ready, 0 already succeed, 0
error, 0 discarded, 0 others2019-01-28 22:53:25,050 INFO [BadQueryDetector]
service.BadQueryDetector:147 : Detect bad query.2019-01-28 22:53:28,013 INFO
[FetcherRunner 992042775-44] threadpool.DefaultFetcherRunner:94 : Job Fetcher:
0 should running, 0 actual running, 0 stopped, 0 ready, 0 already succeed, 0
error, 0 discarded, 0 others
Please help,Gladson
