You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Dong Zhen (Jira)" <ji...@apache.org> on 2019/11/29 12:43:00 UTC
[jira] [Created] (KYLIN-4274) Calculate the number of records in a
column greater than the specified value
Dong Zhen created KYLIN-4274:
--------------------------------
Summary: Calculate the number of records in a column greater than the specified value
Key: KYLIN-4274
URL: https://issues.apache.org/jira/browse/KYLIN-4274
Project: Kylin
Issue Type: Bug
Environment: Kylin 2.6.3
Reporter: Dong Zhen
Query: SELECT COUNT(1) FROM TAGS_MBR_MEMBER_BUY_INFO Result: 18890197
Query: SELECT COUNT(1) FROM TAGS_MBR_MEMBER_BUY_INFO WHERE CAST(FIRSTORDERVALUE AS DOUBLE) <= 99 Result: 18729902
Query: SELECT COUNT(1) FROM TAGS_MBR_MEMBER_BUY_INFO WHERE CAST(FIRSTORDERVALUE AS DOUBLE) <= 100 Result: 317493
Query: SELECT COUNT(1) FROM TAGS_MBR_MEMBER_BUY_INFO WHERE CAST(FIRSTORDERVALUE AS DOUBLE) <= 101 Result: 425372
FIRSTORDERVALUE field is of type varchar.
What's the situation?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)