kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hejian (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3992) easy exceeds 'max-return-row' when gouping by a high-cardinality dimension with a long day span filter
Date Mon, 29 Apr 2019 10:53:00 GMT
hejian created KYLIN-3992:
-----------------------------

             Summary: easy exceeds 'max-return-row' when gouping by a high-cardinality dimension
with a long day span filter
                 Key: KYLIN-3992
                 URL: https://issues.apache.org/jira/browse/KYLIN-3992
             Project: Kylin
          Issue Type: Bug
            Reporter: hejian


In my case, a dimension with 3million cardinality called seller_id, 
{code:java}
select seller_id, sum(volume) as count_num from tab_orders where day_id>='2019-04-07' and
day_id<'2019-04-27' group by seller_id order by count_num desc offset 0 limit 10{code}
I think it relates to both the *cardinality(seller_id)* and *cardinality(day_id)* ?

Hard to determine the suitable value to 'kylin.query.max-return-row', any good solution to
handle this issue?



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

Mime
View raw message