[
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)
