[jira] [Comment Edited] (CARBONDATA-1506) SDV tests error in CI

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-1506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16198336#comment-16198336 ]

xubo245 edited comment on CARBONDATA-1506 at 10/10/17 8:48 AM:
---------------------------------------------------------------

[~ravipesala] What is the goal of this test case? Why is it covar_samp(1,2) ?

 
{code:java}
 checkAnswer(s"""select covar_samp(1,2) from uniqdata where upper(CUST_NAME)=15 or upper(CUST_NAME) is NULL or upper(CUST_NAME) is NOT NULL""",
      s"""select covar_samp(1,2) from uniqdata_hive where upper(CUST_NAME)=15 or upper(CUST_NAME) is NULL or upper(CUST_NAME) is NOT NULL""", "QueriesBasicTestCase_PushUP_FILTER_uniqdata_TC076")

{code}



was (Author: xubo245):
[~ravipesala] What is the goal of this test case?

 
{code:java}
 checkAnswer(s"""select covar_samp(1,2) from uniqdata where upper(CUST_NAME)=15 or upper(CUST_NAME) is NULL or upper(CUST_NAME) is NOT NULL""",
      s"""select covar_samp(1,2) from uniqdata_hive where upper(CUST_NAME)=15 or upper(CUST_NAME) is NULL or upper(CUST_NAME) is NOT NULL""", "QueriesBasicTestCase_PushUP_FILTER_uniqdata_TC076")

{code}

> SDV tests error in CI
> ---------------------
>
>                 Key: CARBONDATA-1506
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1506
>             Project: CarbonData
>          Issue Type: Bug
>          Components: test
>            Reporter: xubo245
>            Assignee: xubo245
>            Priority: Minor
>   Original Estimate: 480h
>          Time Spent: 1.5h
>  Remaining Estimate: 478.5h
>
> Sometimes, there is error in SDV test:
> == Results ==
> !== Correct Answer - 1 ==   == Spark Answer - 1 ==
> ![0.0]                      [1.0E-5]
> sometimes it is correct.
> It's better to fix this error.
> failed CI like：
> http://144.76.159.231:8080/job/ApacheSDVTests/879/testReport/junit/org.apache.carbondata.cluster.sdv.generated/QueriesBasicTestCase/PushUP_FILTER_uniqdata_TC075/
> http://144.76.159.231:8080/job/ApacheSDVTests/841/testReport/junit/org.apache.carbondata.cluster.sdv.generated/QueriesBasicTestCase/PushUP_FILTER_uniqdata_TC074/
> http://144.76.159.231:8080/job/ApacheSDVTests/797/testReport/junit/org.apache.carbondata.cluster.sdv.generated/QueriesBasicTestCase/PushUP_FILTER_uniqdata_TC074/

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)