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
