kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3693) TopN, Count distinct incorrect in Spark engine
Date Sun, 18 Nov 2018 14:00:00 GMT

     [ https://issues.apache.org/jira/browse/KYLIN-3693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Shaofeng SHI updated KYLIN-3693:
--------------------------------
    Fix Version/s: v2.5.2
      Description: 
 Long Chao firstly reported this bug; And then we found the currect integration test didn't
cover this count distinct, topn measures with Spark engine. In "ITKylinQueryTest", some queries
are not tested in the "left" join case, which means they were not covered the spark case.
If we manually change to built the "left join" cube with spark, IT will report wrong result:

 

 
{code:java}
[ERROR] Failures: 
[ERROR]   ITCombinationTest>ITKylinQueryTest.testPreciselyDistinctCountQuery:284->KylinTestBase.execAndCompQuery:544->KylinTestBase.execAndCompQuery:647->KylinTestBase.assertTableEquals:691
value (table=query result of query01, row=0, col=USER_COUNT) expected:<8[46]> but was:<8[52]>
[ERROR]   ITCombinationTest>ITKylinQueryTest.testTopNQuery:277->KylinTestBase.execAndCompQuery:544->KylinTestBase.execAndCompQuery:647->KylinTestBase.assertTableEquals:691
value (table=query result of query82, row=0, col=CAL_DT) expected:<2012-01-[28]> but
was:<2012-01-[05]>
[INFO] 
{code}
 

  was:
 
{code:java}
[ERROR] Failures: 
[ERROR]   ITCombinationTest>ITKylinQueryTest.testPreciselyDistinctCountQuery:284->KylinTestBase.execAndCompQuery:544->KylinTestBase.execAndCompQuery:647->KylinTestBase.assertTableEquals:691
value (table=query result of query01, row=0, col=USER_COUNT) expected:<8[46]> but was:<8[52]>
[ERROR]   ITCombinationTest>ITKylinQueryTest.testTopNQuery:277->KylinTestBase.execAndCompQuery:544->KylinTestBase.execAndCompQuery:647->KylinTestBase.assertTableEquals:691
value (table=query result of query82, row=0, col=CAL_DT) expected:<2012-01-[28]> but
was:<2012-01-[05]>
[INFO] 
{code}
 


> TopN, Count distinct incorrect in Spark engine
> ----------------------------------------------
>
>                 Key: KYLIN-3693
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3693
>             Project: Kylin
>          Issue Type: Bug
>          Components: Spark Engine
>    Affects Versions: v2.5.0, v2.5.1
>            Reporter: Shaofeng SHI
>            Priority: Major
>             Fix For: v2.5.2
>
>
>  Long Chao firstly reported this bug; And then we found the currect integration test
didn't cover this count distinct, topn measures with Spark engine. In "ITKylinQueryTest",
some queries are not tested in the "left" join case, which means they were not covered the
spark case. If we manually change to built the "left join" cube with spark, IT will report
wrong result:
>  
>  
> {code:java}
> [ERROR] Failures: 
> [ERROR]   ITCombinationTest>ITKylinQueryTest.testPreciselyDistinctCountQuery:284->KylinTestBase.execAndCompQuery:544->KylinTestBase.execAndCompQuery:647->KylinTestBase.assertTableEquals:691
value (table=query result of query01, row=0, col=USER_COUNT) expected:<8[46]> but was:<8[52]>
> [ERROR]   ITCombinationTest>ITKylinQueryTest.testTopNQuery:277->KylinTestBase.execAndCompQuery:544->KylinTestBase.execAndCompQuery:647->KylinTestBase.assertTableEquals:691
value (table=query result of query82, row=0, col=CAL_DT) expected:<2012-01-[28]> but
was:<2012-01-[05]>
> [INFO] 
> {code}
>  



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

Mime
View raw message