What is the bug?
When pushdown enabled, the aggregation result depends on OpenSearch DSL. We found the testQ1 could flaky on different platform:

Suite: Test class org.opensearch.sql.calcite.tpch.CalcitePPLTpchIT

2> REPRODUCE WITH: ./gradlew ':integ-test:integTest' --tests 'org.opensearch.sql.calcite.tpch.CalcitePPLTpchIT.testQ1' -Dtests.seed=5AD3AA18D9879132 -Dtests.security.manager=false -Dtests.locale=ksf-CM -Dtests.timezone=Brazil/DeNoronha -Druntime.java=25 -Djava.security.properties=/tmp/tmphfxkwakx/sql/distribution/src/config/fips_java.security

2> java.lang.AssertionError:

Expected: iterable with items [[A, F, 37474, 3.756962464E7, 3.5676192097E7, 3.7101416222424E7, 25.354533152909337, 25419.231826792962, 0.0508660351826793, 1478], [N, F, 1041, 1041301.07, 999060.898, 1036450.8022800001, 27.394736842105264, 27402.659736842103, 0.04289473684210526, 38], [N, O, 75168, 7.538495537E7, 7.16531663034E7, 7.4498798133073E7, 25.558653519211152, 25632.42277116627, 0.049697381842910573, 2941], [R, F, 36511, 3.657084124E7, 3.47384728758E7, 3.6169060112193E7, 25.059025394646532, 25100.09693891558, 0.05002745367192862, 1457]] in any order

     but: not matched: <["A","F",37474,37569624.64,35676192.096999995,37101416.222424,25.354533152909337,25419.231826792962,0.0508660351826793,1478]>

Suite: Test class org.opensearch.sql.calcite.tpch.CalcitePPLTpchPaginatingIT

2> REPRODUCE WITH: ./gradlew ':integ-test:integTest' --tests 'org.opensearch.sql.calcite.tpch.CalcitePPLTpchPaginatingIT.testQ1' -Dtests.seed=5AD3AA18D9879132 -Dtests.security.manager=false -Dtests.locale=ff-Latn-MR -Dtests.timezone=America/Argentina/Tucuman -Druntime.java=25 -Djava.security.properties=/tmp/tmphfxkwakx/sql/distribution/src/config/fips_java.security

2> java.lang.AssertionError:

Expected: iterable with items [[A, F, 37474, 3.756962464E7, 3.5676192097E7, 3.7101416222424E7, 25.354533152909337, 25419.231826792962, 0.0508660351826793, 1478], [N, F, 1041, 1041301.07, 999060.898, 1036450.8022800001, 27.394736842105264, 27402.659736842103, 0.04289473684210526, 38], [N, O, 75168, 7.538495537E7, 7.16531663034E7, 7.4498798133073E7, 25.558653519211152, 25632.42277116627, 0.049697381842910573, 2941], [R, F, 36511, 3.657084124E7, 3.47384728758E7, 3.6169060112193E7, 25.059025394646532, 25100.09693891558, 0.05002745367192862, 1457]] in any order

     but: not matched: <["N","F",1041,1041301.0700000001,999060.8979999999,1036450.8022800001,27.394736842105264,27402.659736842106,0.04289473684210526,38]>

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

What is the expected behavior?
A clear and concise description of what you expected to happen.

What is your host/environment?

• OS: Linux ARM65
• Version 3.6.0
• Plugins SQL

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Add any other context about the problem.