[jira] [Created] (KYLIN-4079) Concurrent query requests using Query API makes the query execution take too much time
Gladson Vas created KYLIN-4079: -- Summary: Concurrent query requests using Query API makes the query execution take too much time Key: KYLIN-4079 URL: https://issues.apache.org/jira/browse/KYLIN-4079 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Gladson Vas Hi, When 40 queries are executed on kylin parallelly (at once) the response time distribution is as below, with min, max and mean response time as 6557,7580 and 6887 ms respectively. Kylin doesn’t seem to handle parallel execution of queries. !SlowQueryExecution.png! !SlowQueryExecution1.png! But when 40 queries are executed over 40 seconds i.e one query executed per second the response time distribution is as below, with min, max and mean response time as 110,2820 and 248 ms respectively. This seems fine as the mean response time in less than a second. !NormalQueryExecution.png!!NormalQueryExecution1.png! There seems to be some problem when queries are fired in parallel to kylin.Please help. -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Created] (KYLIN-3967) sum along with case expression does not work in query
Gladson Vas created KYLIN-3967: -- Summary: sum along with case expression does not work in query Key: KYLIN-3967 URL: https://issues.apache.org/jira/browse/KYLIN-3967 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Gladson Vas When i try to run a query with a sum case expression combination, eg: select sum(case when col1<0 then 0 else col1 end ) from table i get the following error: No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case when col1 <0 then 0 else col1 end ) from table LIMIT 5" is there any way to support this sum case expression in the query engine? Also I get the same error when the sum operation is done on a column derived from a case expression in a subquery. eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as col1 from table) a Thanks, Gladson -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3966) Metric multiplication and metric division not working in query
Gladson Vas created KYLIN-3966: -- Summary: Metric multiplication and metric division not working in query Key: KYLIN-3966 URL: https://issues.apache.org/jira/browse/KYLIN-3966 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Gladson Vas When i try to multiply or divide 2 metric columns in a query eg: select col1*col2 from table select col1/col2 from table. it throws the following errors That both of the two sides of the BinaryTupleExpression own columns is not supported for * while executing SQL That both of the two sides of the BinaryTupleExpression own columns is not supported for / while executing SQL. But when i use the + or - operators in the query it seems to be working fine. Is there any way to support these 2 operators as well? Thanks, Gladson -- This message was sent by Atlassian JIRA (v7.6.3#76005)
SQL Server JDBC Datasource doesnt list tables.
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