[jira] [Created] (KYLIN-5025) when filter is a derived column equals another column query failed

2021-07-02 Thread zhimin wu (Jira) 
zhimin wu created KYLIN-5025:


 Summary: when filter is a derived column equals another column 
query failed
 Key: KYLIN-5025
 URL: https://issues.apache.org/jira/browse/KYLIN-5025
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Reporter: zhimin wu
Assignee: zhimin wu
 Attachments: image-2021-07-02-21-41-15-854.png

Just use the following SQL query to learn_kylin. 
{quote}SELECT
count(*)
FROM KYLIN_SALES as KYLIN_SALES
INNER JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
WHERE KYLIN_SALES.PART_DT = KYLIN_CAL_DT.MONTH_BEG_DT
{quote}
that was OK, but if you put the derived column to the left of the filter like 
the following SQL, query failed.
{quote}SELECT
count(*)
FROM KYLIN_SALES as KYLIN_SALES
INNER JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
WHERE  KYLIN_CAL_DT.MONTH_BEG_DT = KYLIN_SALES.PART_DT
{quote}
{{!image-2021-07-02-21-41-15-854.png|width=618,height=271!}}

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Created] (KYLIN-4363) Query failed with "I failed to find one of the right cookies" error

2020-01-30 Thread Shao Feng Shi (Jira) 
Shao Feng Shi created KYLIN-4363:


 Summary: Query failed with "I failed to find one of the right 
cookies" error
 Key: KYLIN-4363
 URL: https://issues.apache.org/jira/browse/KYLIN-4363
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v3.1.0
Reporter: Shao Feng Shi


{code:java}


// code placeholder

Caused by: java.lang.RuntimeException: I failed to find one of the right 
cookies. 1701223222Caused by: java.lang.RuntimeException: I failed to find one 
of the right cookies. 1701223222 at 
org.roaringbitmap.buffer.ImmutableRoaringArray.(ImmutableRoaringArray.java:46)
 at 
org.roaringbitmap.buffer.ImmutableRoaringBitmap.(ImmutableRoaringBitmap.java:908)
 at 
org.apache.kylin.measure.bitmap.RoaringBitmapCounter.peekLength(RoaringBitmapCounter.java:141)
 at 
org.apache.kylin.measure.bitmap.BitmapSerializer.peekLength(BitmapSerializer.java:69)
 at 
org.apache.kylin.cube.gridtable.CubeCodeSystem.codeLength(CubeCodeSystem.java:100)
 at org.apache.kylin.gridtable.GTRecord.loadColumns(GTRecord.java:279) at 
org.apache.kylin.storage.gtrecord.PartitionResultIterator.next(PartitionResultIterator.java:56)
 at 
org.apache.kylin.storage.gtrecord.PartitionResultIterator.next(PartitionResultIterator.java:35)
 at com.google.common.collect.Iterators$PeekingImpl.next(Iterators.java:1222) 
at 
org.apache.kylin.storage.gtrecord.SortMergedPartitionResultIterator.next(SortMergedPartitionResultIterator.java:93)
 at 
org.apache.kylin.storage.gtrecord.SortMergedPartitionResultIterator.next(SortMergedPartitionResultIterator.java:38)
 at com.google.common.collect.Iterators$PeekingImpl.next(Iterators.java:1222) 
at 
org.apache.kylin.gridtable.GTStreamAggregateScanner$AbstractStreamMergeIterator.next(GTStreamAggregateScanner.java:102)
 at 
org.apache.kylin.storage.gtrecord.SegmentCubeTupleIterator.hasNext(SegmentCubeTupleIterator.java:162)
 at org.apache.kylin.storage.gtrecord.PeekingImpl.hasNext(PeekingImpl.java:45) 
at 
org.apache.kylin.storage.gtrecord.SortedIteratorMerger.getHeap(SortedIteratorMerger.java:52)
 at 
org.apache.kylin.storage.gtrecord.SortedIteratorMergerWithLimit$MergedIteratorWithLimit.hasNext(SortedIteratorMergerWithLimit.java:81)
 at 
org.apache.kylin.storage.gtrecord.SequentialCubeTupleIterator.hasNext(SequentialCubeTupleIterator.java:144)
 at 
org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:63)
 at Baz$1$1.moveNext(Unknown Source) at 
org.apache.calcite.linq4j.EnumerableDefaults.aggregate(EnumerableDefaults.java:116)
 at 
org.apache.calcite.linq4j.DefaultEnumerable.aggregate(DefaultEnumerable.java:107)
 at Baz.bind(Unknown Source) at 
org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:365)
 at 
org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:301)
 at 
org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:559)
 at 
org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:550)
 at 
org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:182) 
at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:67)
{code}
I build a cube with an older version of Kylin, and then query the cube from the 
latest master version, and then got this error. With some analysis, I think it 
is related with KYLIN-4322



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Created] (KYLIN-4158) Query failed for GroupBy an expression of column with limit in SQL

2019-09-05 Thread PENG Zhengshuai (Jira) 
PENG Zhengshuai created KYLIN-4158:
--

 Summary: Query failed for GroupBy an expression of column with 
limit in SQL
 Key: KYLIN-4158
 URL: https://issues.apache.org/jira/browse/KYLIN-4158
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v2.6.2
Reporter: PENG Zhengshuai
Assignee: PENG Zhengshuai


Sql limit should not be pushdown to storage level if group by clause is an 
expression of columns.

For example:

{code:java}
SELECT (CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" IN ('Auction', 
'FP-GTC')) THEN 'Auction' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END) AS 
"LSTG_FORMAT_NAME__group_",
  SUM("TEST_KYLIN_FACT"."PRICE") AS "sum_PRICE_ok"
FROM "TEST_KYLIN_FACT" "TEST_KYLIN_FACT"
GROUP BY (CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" IN ('Auction', 
'FP-GTC')) THEN 'Auction' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END)
limit 4
{code}

In this SQL, group by clause is an expression, the limit should NOT be 
push-down to storage level, otherwise, the result is incorrect



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

[jira] [Created] (KYLIN-3751) Query failed when you set log4j.logger.org.apache.calcite=DEBUG

2019-01-01 Thread zengrui (JIRA) 
zengrui created KYLIN-3751:
--

 Summary: Query failed when you set 
log4j.logger.org.apache.calcite=DEBUG
 Key: KYLIN-3751
 URL: https://issues.apache.org/jira/browse/KYLIN-3751
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v2.5.0
Reporter: zengrui


Query failed when you set log4j.logger.org.apache.calcite=DEBUG in 
kylin-server-log4j.properties.It is a NullPointerException in 
VolcanoPlanner(line 891, calcite-core-1.13.0-kylin-r4), root is used before set.

Then I found that it has been solved in calcite-core-1.16.0-kylin-r2. Can I 
update the calcite-core directly?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Re: Query failed

2018-09-19 Thread zhengyangju...@163.com 
6e-189] 
hbase.HBaseConnection:180 : Using the working dir FS for HBase: 
hdfs://nameservice
2018-09-20 10:15:36,174 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
v2.CubeHBaseRPC:315 : hbase.rpc.timeout = 6 ms, use 54000 ms as timeout for 
coprocessor
2018-09-20 10:15:36,175 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
v2.CubeHBaseEndpointRPC:152 : Serialized scanRequestBytes 2935 bytes, 
rawScanBytesString 101 bytes
2018-09-20 10:15:36,175 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
v2.CubeHBaseEndpointRPC:154 : The scan 7a7baa0d for segment 
Cube_INDUSTRY_RANK[FULL_BUILD] is as below with 1 separate raw scans, shard 
part of start/end key is set to 0
2018-09-20 10:15:36,177 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
v2.CubeHBaseRPC:288 : Visiting hbase table KYLIN_N102ZXDQ5U: cuboid require 
post aggregation, from 475136 to 524287 Start: 
\x00\x00\x00\x00\x00\x00\x00\x07\xFF\xFF\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
 
(\x00\x00\x00\x00\x00\x00\x00\x07\xFF\xFF\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00)
 Stop:  
\x00\x00\x00\x00\x00\x00\x00\x07\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
 
(\x00\x00\x00\x00\x00\x00\x00\x07\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00),
 No Fuzzy Key
2018-09-20 10:15:36,177 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
v2.CubeHBaseEndpointRPC:159 : Submitting rpc to 1 shards starting from shard 0, 
scan range count 1
2018-09-20 10:15:36,178 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
common.KylinConfig:332 : Loading kylin-defaults.properties from 
file:/opt/module/apache-kylin-2.4.1-bin/tomcat/webapps/kylin/WEB-INF/lib/kylin-core-common-2.4.1.jar!/kylin-defaults.properties
2018-09-20 10:15:36,186 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
common.KylinConfig:291 : KYLIN_CONF property was not set, will seek KYLIN_HOME 
env variable
2018-09-20 10:15:36,187 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
gtrecord.SequentialCubeTupleIterator:78 : Using Iterators.concat to merge 
segment results
2018-09-20 10:15:36,188 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
enumerator.OLAPEnumerator:117 : return TupleIterator...
2018-09-20 10:15:36,188 INFO  [kylin-coproc--pool2-t16] 
v2.CubeHBaseEndpointRPC:217 : Query-c4dc6f83-8c9d-4fa3-8485-00bd6742136e: send 
request to the init region server credit-cdh06.30wish.com on table 
KYLIN_N102ZXDQ5U 
2018-09-20 10:15:36,259 INFO  [kylin-coproc--pool2-t16] 
v2.CubeHBaseEndpointRPC:284 : Endpoint RPC 
returned from HTable KYLIN_N102ZXDQ5U Shard 
\x4B\x59\x4C\x49\x4E\x5F\x4E\x31\x30\x32\x5A\x58\x44\x51\x35\x55\x2C\x2C\x31\x35\x33\x35\x33\x34\x35\x35\x30\x34\x35\x34\x37\x2E\x32\x63\x30\x33\x38\x30\x37\x63\x36\x38\x63\x39\x33\x31\x31\x64\x35\x30\x38\x66\x64\x64\x38\x30\x65\x64\x39\x38\x35\x31\x37\x64\x2E
 on host: credit-cdh06.30wish.com.Total scanned row: 7709. Total scanned bytes: 
562757. Total filtered row: 0. Total aggred row: 3935. Time elapsed in EP: 
67(ms). Server CPU usage: 0.12346024636058231, server physical mem left: 
4.283203584E9, server swap mem left:0.0.Etc message: start latency: 120@1,agg 
done@66,compress done@67,server stats done@67, 
debugGitTag:b450cc52f976ddafba7c6625d2440670af94332b;.Normal Complete: 
true.Compressed row size: 13868
2018-09-20 10:15:36,260 DEBUG [kylin-coproc--pool2-t16] 
util.CompressionUtils:67 : Original: 13868 bytes. Decompressed: 26418 bytes. 
Time: 1
2018-09-20 10:15:36,260 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
gtrecord.SortMergedPartitionResultIterator:76 : Using 
SortMergedPartitionResultIterator to merge 1 partition results out of 1 
partitions
2018-09-20 10:15:36,269 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
service.QueryService:956 : Processed rows for each storageContext: 3774 
2018-09-20 10:15:36,270 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
service.QueryService:430 : Stats of SQL response: isException: false, duration: 
313, total scan count 7709
2018-09-20 10:15:36,270 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
util.CheckUtil:35 : query is too lightweight with duration: 313 (threshold 
2000), scan count: 7709 (threshold 10240), scan bytes: 562757 (threshold 
1048576)
2018-09-20 10:15:36,270 INFO  [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189] 
service.QueryService:319 : 


zhengyangju...@163.com
 
From: zhengyangju...@163.com
Date: 2018-09-20 10:04
To: dev
Subject: Query failed
When I use >=, there is data query, when I add <=, the query is wrong.
==[QUERY]===
Query Id: a2095

Query failed

2018-09-19 Thread zhengyangju...@163.com 
When I use >=, there is data query, when I add <=, the query is wrong.
==[QUERY]===
Query Id: a2095b23-f09c-4cd7-9969-e0ad98746dc3
SQL: SELECT "HYNAME" AS "HYNAME",
   SUM(QY_SUM)-SUM(QY_SUM_PRE) AS "FLOW_IN_ENTERPRISE"
FROM
  (SELECT CAST(T.PAYMENT_DATE AS DATE) AS CAL_DATE,
  CONCAT(CAST(S.CALENDARYEAR AS CHAR(4)),'?') AS CAL_DATE_YEAR,
  CONCAT(CAST(S.CALENDARQUARTER AS CHAR(4)),'??') AS CAL_DATE_QUARTER,
  CASE
  WHEN S.CALENDARMONTH<10 THEN 
CONCAT(CONCAT('0',CAST(S.CALENDARMONTH AS CHAR(4))),'?')
  ELSE CONCAT(CAST(S.CALENDARMONTH AS CHAR(4)),'?')
  END AS CAL_DATE_MONTH,
  T.INDUSTRY_CATEGORY_NAME AS HYNAME,
  T.COMPANY_CNT AS QY_SUM,
  T.COMPANY_CNT_ROW AS QY_SUM_ROW,
  T.COMPANY_CNT_BEFORE AS QY_SUM_PRE,
  T.COMPANY_CNT_GROWTH_PERCENT AS QY_SUM_PERC,
  (T.COMPANY_CNT-T.COMPANY_CNT_BEFORE) AS QY_SUM_GROWTH,
  T.SUM_EMNUM AS YG_SUM,
  T.SUM_EMNUM_ROW AS YG_SUM_ROW,
  T.SUM_EMNUM_BEFORE AS YG_SUM_PRE,
  T.SUM_EMNUM_GROWTH_PERCENT AS YG_SUM_PERC,
  (T.SUM_EMNUM-T.SUM_EMNUM_BEFORE) AS YG_SUM_GROWTH,
  T.SUM_REGISTERED_CAPITAL AS RC_SUM,
  T.SUM_REGISTERED_CAPITAL_ROW AS RC_SUM_ROW,
  T.SUM_REGISTERED_CAPITAL_BEFORE AS RC_SUM_PRE,
  T.SUM_REGISTERED_CAPITAL_GROWTH_PERCENT AS RC_SUM_PERC,
  (T.SUM_REGISTERED_CAPITAL-T.SUM_REGISTERED_CAPITAL_BEFORE) AS 
RC_SUM_GROWTH,
  T.SUM_OPERATING_LIFE AS OL_SUM,
  T.SUM_OPERATING_LIFE_ROW AS OL_SUM_ROW
   FROM INDUSTRY_RANK T
   LEFT JOIN INDUSTRY_RANK_DATE S ON T.SYS_ID=S.SYS_ID) AS expr_qry
WHERE "CAL_DATE" >= TO_DATE('2011-09-20 00:00:00', '-MM-dd')
  AND "CAL_DATE" <= TO_DATE('2018-09-20 01:33:04', '-MM-dd')
GROUP BY "HYNAME"
ORDER BY "FLOW_IN_ENTERPRISE" DESC
LIMIT 10;
User: ADMIN
Success: true
Duration: 0.226
Project: WEIHAI_DEMO
Realization Names: [CUBE[name=Cube_INDUSTRY_RANK]]
Cuboid Ids: [524287]
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==[QUERY]===


zhengyangju...@163.com

Re: kylin sample sql query failed，but some sql query success

2018-05-26 Thread Li Yang 
Kylin don't answer detailed queries like -- select * from KYLIN_SALES

Kylin answers aggregated queries like -- select count(*) from KYLIN_SALES

On Thu, May 24, 2018 at 2:56 PM, zhangzhi...@dianwoba.com <
zhangzhi...@dianwoba.com> wrote:

> SELECT * from KYLIN_CAL_DT is success
>
> sql contains KYLIN_SALES table always failed
>
> 2018-05-23 16:50:10,167 ERROR [Query 
> e41e8d65-28e9-4d94-9e36-29ad490f56ab-14215]
> service.QueryService:536 : Exception while executing query
> java.sql.SQLException: Error while executing SQL "SELECT * from KYLIN_SALES
> LIMIT 5": org.apache.hadoop.hbase.DoNotRetryIOException:
> org.apache.hadoop.hbase.DoNotRetryIOException: Coprocessor passed
> deadline! Maybe server is overloaded
> at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.CubeVisitService.checkDeadline(CubeVisitService.java:225)
> at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.CubeVisitService.visitCube(CubeVisitService.java:259)
> at org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.
> CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:)
> at org.apache.hadoop.hbase.regionserver.HRegion.
> execService(HRegion.java:7797)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(
> RSRpcServices.java:1982)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.
> execService(RSRpcServices.java:1964)
> at org.apache.hadoop.hbase.protobuf.generated.
> ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2170)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:109)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(
> RpcExecutor.java:185)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(
> RpcExecutor.java:165)
>
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:156)
> at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> AvaticaStatement.java:218)
> at org.apache.kylin.rest.service.QueryService.execute(
> QueryService.java:931)
> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(
> QueryService.java:661)
> at org.apache.kylin.rest.service.QueryService.query(QueryService.java:188)
> at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(
> QueryService.java:496)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:455)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:390)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:86)
> at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(
> InvocableHandlerMethod.java:205)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:133)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:97)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandlerMethod(
> RequestMappingHandlerAdapter.java:827)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:738)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:967)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:901)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(
> FrameworkServlet.java:970)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:872)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:846)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
>

kylin sample sql query failed，but some sql query success

2018-05-24 Thread zhangzhi...@dianwoba.com 
SELECT * from KYLIN_CAL_DT is success

sql contains KYLIN_SALES table always failed

2018-05-23 16:50:10,167 ERROR [Query 
e41e8d65-28e9-4d94-9e36-29ad490f56ab-14215] service.QueryService:536 : 
Exception while executing query
java.sql.SQLException: Error while executing SQL "SELECT * from KYLIN_SALES
LIMIT 5": org.apache.hadoop.hbase.DoNotRetryIOException: 
org.apache.hadoop.hbase.DoNotRetryIOException: Coprocessor passed deadline! 
Maybe server is overloaded
at 
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.CubeVisitService.checkDeadline(CubeVisitService.java:225)
at 
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.CubeVisitService.visitCube(CubeVisitService.java:259)
at 
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:)
at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7797)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1982)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1964)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2170)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:109)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:185)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:165)

at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
at 
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218)
at org.apache.kylin.rest.service.QueryService.execute(QueryService.java:931)
at 
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:661)
at org.apache.kylin.rest.service.QueryService.query(QueryService.java:188)
at 
org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:496)
at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:455)
at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:390)
at 
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:86)
at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
at 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at

[jira] [Created] (KYLIN-3057) In some cases，query failed when sql with comments

2017-11-24 Thread peng.jianhua (JIRA) 
peng.jianhua created KYLIN-3057:
---

 Summary: In some cases，query failed when sql with comments
 Key: KYLIN-3057
 URL: https://issues.apache.org/jira/browse/KYLIN-3057
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v2.3.0
Reporter: peng.jianhua
Assignee: peng.jianhua
 Attachments: no_comments_sql.PNG, with_comments_sql.PNG





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Re: After upgrade, Query Failed

2017-09-11 Thread ShaoFeng Shi 
Welcome!

2017-09-11 9:51 GMT+08:00 mailpig :

> Sorry, I forget it. Thank you.
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>



-- 
Best regards,

Shaofeng Shi 史少锋

Re: After upgrade, Query Failed

2017-09-10 Thread mailpig 
Sorry, I forget it. Thank you.

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: After upgrade, Query Failed

2017-09-08 Thread ShaoFeng Shi 
Hi, did you upgrade Kylin coprocessor? If not, pls follow the step in
upgrade guide.

2017-09-08 18:27 GMT+08:00 mailpig :

> I upgrade the Kylin2.0 to Kylin2.1 and reuse the metadata. Everything is ok
> except the query.
> The exception in hbase is blew:
> 
>
> hbase version is 1.25.
> Please help me, thank you verry much.
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>



-- 
Best regards,

Shaofeng Shi 史少锋

After upgrade, Query Failed

2017-09-08 Thread mailpig 
I upgrade the Kylin2.0 to Kylin2.1 and reuse the metadata. Everything is ok
except the query.
The exception in hbase is blew:
 

hbase version is 1.25.
Please help me, thank you verry much.

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

[jira] [Created] (KYLIN-2488) query failed because scan threshold

2017-03-07 Thread zhou degao (JIRA) 
zhou degao created KYLIN-2488:
-

 Summary: query failed because scan threshold
 Key: KYLIN-2488
 URL: https://issues.apache.org/jira/browse/KYLIN-2488
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v1.6.0
Reporter: zhou degao
Assignee: liyang
 Attachments: cube.PNG

When i submit this query:
select "time_by_day_alias"."THE_YEAR" as "c0", 
"git_log_alias"."PROJECT_NAME" as "c1", "git_log_alias"."BRANCH_NAME" as 
"c2", count(distinct "git_log_alias"."COMMIT_ID") as "m0" from 
"CODE_VIEW_178E383E_623C_45E3_BA1B_1333DFE2240B" as "git_log_alias" join 
"TIME_BY_DAY" as "time_by_day_alias" on "git_log_alias"."FORMATED_DATE" = 
"time_by_day_alias"."THE_DATE" group by "time_by_day_alias"."THE_YEAR", 
"git_log_alias"."PROJECT_NAME", "git_log_alias"."BRANCH_NAME"

I got following error even though i set kylin.query.scan.threshold=1


2017-03-07 14:27:43,770 INFO  [Query c422b09c-b1a5-4dcc-afac-7c9a25cff3fe-66] 
endpoint.CubeVisitService: The cube visit did not finish normally because scan 
num exceeds threshold
org.apache.kylin.gridtable.GTScanExceedThresholdException: Exceed scan 
threshold at 49145
at 
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.CubeVisitService$1.hasNext(CubeVisitService.java:258)
at 
org.apache.kylin.storage.hbase.cube.v2.HBaseReadonlyStore$1$1.hasNext(HBaseReadonlyStore.java:111)
at 
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.CubeVisitService.visitCube(CubeVisitService.java:290)
at 
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:4117)
at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7864)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1991)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1973)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Created] (KYLIN-2440) Query failed if join condition columns not appear on cube

2017-02-09 Thread Dong Li (JIRA) 
Dong Li created KYLIN-2440:
--

 Summary: Query failed if join condition columns not appear on cube
 Key: KYLIN-2440
 URL: https://issues.apache.org/jira/browse/KYLIN-2440
 Project: Kylin
  Issue Type: Bug
Reporter: Dong Li
Assignee: liyang


The metadata are:
The model is:
KYLIN_SALES(fact) - KYLIN_ACCOUNT(fact) - KYLIN_COUNTRY(lookup)
Dimensions on cube:
KYLIN_SALES.PART_DT(Normal), KYLIN_COUNTRY.LONGITUDE(derived)

The failed query:
SELECT count(*)
FROM KYLIN_SALES as KYLIN_SALES 
INNER JOIN KYLIN_ACCOUNT as KYLIN_ACCOUNT
ON KYLIN_SALES.SELLER_ID = KYLIN_ACCOUNT.ACCOUNT_ID
INNER JOIN KYLIN_COUNTRY as KYLIN_COUNTRY
ON KYLIN_ACCOUNT.ACCOUNT_COUNTRY = KYLIN_COUNTRY.COUNTRY
INNER JOIN KYLIN_ACCOUNT as KYLIN_ACCOUNT_B
ON KYLIN_SALES.BUYER_ID = KYLIN_ACCOUNT_B.ACCOUNT_ID
INNER JOIN KYLIN_COUNTRY as KYLIN_COUNTRY_B
ON KYLIN_ACCOUNT_B.ACCOUNT_COUNTRY = KYLIN_COUNTRY_B.COUNTRY

Query stacktrace:
2017-02-09 08:49:53,879 ERROR [Query 5a458124-6cae-47b8-8621-24173c1eeba1-101] 
runtime.CalciteException:59 : 
org.apache.calcite.sql.validate.SqlValidatorException: Column 'SELLER_ID' not 
found in ta
ble 'KYLIN_SALES'
2017-02-09 08:49:53,880 ERROR [Query 5a458124-6cae-47b8-8621-24173c1eeba1-101] 
runtime.CalciteException:61 : 
org.apache.calcite.runtime.CalciteContextException: From line 4, column 16 to 
line 4, col
umn 24: Column 'SELLER_ID' not found in table 'KYLIN_SALES'
2017-02-09 08:49:53,880 ERROR [Query 5a458124-6cae-47b8-8621-24173c1eeba1-101] 
service.QueryService:379 : Exception when execute sql
java.sql.SQLException: Error while executing SQL "SELECT *
FROM KYLIN_SALES as KYLIN_SALES
INNER JOIN KYLIN_ACCOUNT as KYLIN_ACCOUNT
ON KYLIN_SALES.SELLER_ID = KYLIN_ACCOUNT.ACCOUNT_ID
INNER JOIN KYLIN_COUNTRY as KYLIN_COUNTRY
ON KYLIN_ACCOUNT.ACCOUNT_COUNTRY = KYLIN_COUNTRY.COUNTRY
INNER JOIN KYLIN_ACCOUNT as KYLIN_ACCOUNT_B
ON KYLIN_SALES.BUYER_ID = KYLIN_ACCOUNT_B.ACCOUNT_ID
INNER JOIN KYLIN_COUNTRY as KYLIN_COUNTRY_B
ON KYLIN_ACCOUNT_B.ACCOUNT_COUNTRY = KYLIN_COUNTRY_B.COUNTRY
LIMIT 5": From line 4, column 16 to line 4, column 24: Column 'SELLER_ID' 
not found in table 'KYLIN_SALES'
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
at 
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218)
at 
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:557)
at 
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:461)

Caused by: org.apache.calcite.runtime.CalciteContextException: From line 4, 
column 16 to line 4, column 24: Column 'SELLER_ID' not found in table 
'KYLIN_SALES'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at 
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:796)
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:784)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4080)
at 
org.apache.calcite.sql.validate.DelegatingScope.fullyQualify(DelegatingScope.java:362)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl$Expander.visit(SqlValidatorImpl.java:4579)
at 
org.apache.calcite.sql.validate.SqlValidatorImpl$Expander.visit(SqlValidatorImpl.java:4561)
at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:334)
at 
org.apache.calcite.sql.util.SqlShuttle$CallCopyingArgHandler.visitChild(SqlShuttle.java:134)
at 
org.apache.calcite.sql.util.SqlShuttle$CallCopyingArgHandler.visitChild(SqlShuttle.java:101)

Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 
'SELLER_ID' not found in table 'KYLIN_SALES'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at 
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Created] (KYLIN-1992) Clear ThreadLocal Contexts when query failed before scaning HBase

2016-09-01 Thread kangkaisen (JIRA) 
kangkaisen created KYLIN-1992:
-

 Summary: Clear ThreadLocal Contexts when query failed before 
scaning HBase
 Key: KYLIN-1992
 URL: https://issues.apache.org/jira/browse/KYLIN-1992
 Project: Kylin
  Issue Type: Bug
Reporter: kangkaisen
Assignee: kangkaisen
Priority: Minor


currently, we call `OLAPContext.clearThreadLocalContexts()` function before 
scaning HBase.
if query failed before scaning HBase, we would get wrong `realization` of the 
query possibly.
Because the thread pool of Tomcat multiplexed the thread and didn't clear 
ThreadLocal variable.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Re: 答复: kylin query failed

2016-05-19 Thread Li Yang 
My best guess is out-of-memory crash. Returning 30K HLL counter may take
200MB~2GB memory depending on the count distinct precision. Suggest
increase Kylin JVM heap and try again.

On Tue, May 17, 2016 at 10:16 AM, jyzheng <jyzh...@iflytek.com> wrote:

> 1. The cardinality of app_name is about 30,000.
>
> 2. Yes, the Kylin has crashed after query failed.
>
> 3. The clue of kylin.log in the given below:
>
>
>
> Thanks for attention!
>
>
>
>
>
> 2016-05-17 10:13:51,531 INFO  [pool-4-thread-1]
> threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual running,
> 0 ready, 17 others
>
> 2016-05-17 10:14:20,031 DEBUG [http-bio-7070-exec-5]
> service.AdminService:90 : Get Kylin Runtime Config
>
> 2016-05-17 10:14:20,037 DEBUG [http-bio-7070-exec-8]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
>
> 2016-05-17 10:14:20,321 DEBUG [http-bio-7070-exec-5]
> controller.ProjectController:97 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
>
> 2016-05-17 10:14:25,467 DEBUG [http-bio-7070-exec-5]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
>
> 2016-05-17 10:14:25,480 DEBUG [http-bio-7070-exec-5]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
>
> 2016-05-17 10:14:25,610 INFO  [http-bio-7070-exec-1]
> controller.TableController:89 : Return all table metadata in 1 seconds
>
> 2016-05-17 10:14:28,341 DEBUG [http-bio-7070-exec-5]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
>
> 2016-05-17 10:14:28,570 DEBUG [http-bio-7070-exec-5]
> service.QueryService:293 : getting table metas
>
> 2016-05-17 10:14:28,574 DEBUG [http-bio-7070-exec-5]
> service.QueryService:311 : getting column metas
>
> 2016-05-17 10:14:28,601 DEBUG [http-bio-7070-exec-5]
> service.QueryService:325 : done column metas
>
> 2016-05-17 10:14:51,542 INFO  [pool-4-thread-1]
> threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual running,
> 0 ready, 17 others
>
> 2016-05-17 10:14:52,457 INFO  [http-bio-7070-exec-10]
> controller.QueryController:175 : Using project: compass
>
> 2016-05-17 10:14:52,458 INFO  [http-bio-7070-exec-10]
> controller.QueryController:176 : The original query:  select app_name,
> count(distinct uid) as uv
>
>
>
> from sdk_log
>
>
>
> left join week_calendar on sdk_log.day_time = week_calendar.week_cal
>
>
>
> where sdk_log.day_time = date '2016-05-08'
>
>
>
> group by app_name
>
>
>
> order by uv desc
>
>
>
> limit 200
>
>
>
>
>
> 2016-05-17 10:14:52,471 INFO  [http-bio-7070-exec-10]
> service.QueryService:269 : The corrected query: select app_name,
> count(distinct uid) as uv
>
>
>
> from sdk_log
>
>
>
> left join week_calendar on sdk_log.day_time = week_calendar.week_cal
>
>
>
> where sdk_log.day_time = date '2016-05-08'
>
>
>
> group by app_name
>
>
>
> order by uv desc
>
>
>
> limit 200
>
> 2016-05-17 10:14:53,938 INFO  [http-bio-7070-exec-10]
> routing.QueryRouter:48 : The project manager's reference is
> org.apache.kylin.metadata.project.ProjectManager@58baceac
>
> 2016-05-17 10:14:53,941 INFO  [http-bio-7070-exec-10]
> routing.QueryRouter:60 : Find candidates by table DEFAULT.SDK_LOG and
> project=COMPASS : org.apache.kylin.query.routing.Candidate@70f24f62
>
> 2016-05-17 10:14:53,947 INFO  [http-bio-7070-exec-10]
> routing.QueryRou

Re: kylin query failed

2016-05-15 Thread Li Yang 
How high is the cardinality? By saying "failed" and then have to restart,
do you mean crash? Any clue in kylin.log?

Sorry for many questions, but it's hard to help without the details. The
new 1.5.2 release will come with a diagnosis tool that can extract
necessary info into a zip, which you can share with community to diagnose.

On Mon, May 9, 2016 at 5:12 PM, jyzheng  wrote:

>
>
> When I send sql query to Kylin like this:
>
>
>
> select app_name, count(distinct uid) as uv
> from sdk_log
> left join week_calendar on sdk_log.day_time = week_calendar.week_cal
> where sdk_log.day_time = date '2016-05-01'
> group by app_name
> order by uv desc
> limit 200
>
>
>
>
>
> and failed. So I have to restart Kylin.
>
>
>
> The dimension `app_name` is a great high cardinality. If I switch to
> `app_tag` dimension , it will return the right result. So I can’t get the
> top measure dimension in Kylin? If can, and what can I do to solve this?
>
> 
>
> 郑江雨  云平台
>
> Phone: 15155195496
>
>
>