kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dong Zhen (Jira)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-4274) Calculate the number of records in a column greater than the specified value
Date Fri, 29 Nov 2019 12:43:00 GMT
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)

Mime
View raw message