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

[xubo245 (JIRA)]

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

xubo245 commented on CARBONDATA-1506:
-------------------------------------

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