walterddr opened a new issue, #10482:
URL: https://github.com/apache/pinot/issues/10482

   related to #10456 , test speed is 1000 slower after H2 upgrade
   
   See:
   https://github.com/apache/pinot/actions/runs/4485055239/jobs/7886201102
   https://github.com/apache/pinot/actions/runs/4492805230/jobs/7903173676
   
   before:
   ```
   2023-03-22T01:02:33.4046670Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 = i2, i2 = i1 FROM float_x_numeric_comp_tbl, null, false](456)  Time 
elapsed: 0.008 s
   2023-03-22T01:02:33.4047832Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 < i2, i2 < i1 FROM float_x_numeric_comp_tbl, null, false](457)  Time 
elapsed: 0.007 s
   2023-03-22T01:02:33.4048692Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 <= i2, i2 <= i1 FROM float_x_numeric_comp_tbl, null, false](458)  
Time elapsed: 0.005 s
   2023-03-22T01:02:33.4049551Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 > i2, i2 > i1 FROM float_x_numeric_comp_tbl, null, false](459)  Time 
elapsed: 0.006 s
   ```
   
   after:
   ```
   2023-03-22T18:19:55.0910871Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 = i2, i2 = i1 FROM float_x_numeric_comp_tbl, SELECT i1 = i2, i2 = i1 
FROM float_x_numeric_comp_tbl, null, false](453)  Time elapsed: 7.671 s
   2023-03-22T18:19:55.0911994Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 < i2, i2 < i1 FROM float_x_numeric_comp_tbl, SELECT i1 < i2, i2 < i1 
FROM float_x_numeric_comp_tbl, null, false](454)  Time elapsed: 7.592 s
   2023-03-22T18:19:55.0913062Z [INFO] 
org.apache.pinot.query.runtime.queries.ResourceBasedQueriesTest.testQueryTestCasesWithH2[float_x_numeric_comp,
 SELECT i1 <= i2, i2 <= i1 FROM float_x_numeric_comp_tbl, SELECT i1 <= i2, i2 
<= i1 FROM float_x_numeric_comp_tbl, null, false](455)  Time elapsed: 7.622 s
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to