DATE_TRUNC bug with superset

Dremio University
1 
SELECT "PointName" AS "PointName",
       "MeasurementDate2" AS "MeasurementDate2",
       "MeasurementDate1" AS "MeasurementDate1",
       DATE_TRUNC('day', td) AS td,
       "PartNo" AS "PartNo",
       "SerialNo" AS "SerialNo",
       "Specification" AS "Specification",
       "ToleranceUp" AS "ToleranceUp",
       "ToleranceDown" AS "ToleranceDown",
       min("PointData") AS "MIN(PointData)"
FROM "OA"."ThreeD"."MaxAndMinTable"
GROUP BY "PointName",
         "MeasurementDate2",
         "MeasurementDate1",
         DATE_TRUNC('day', td),
         "PartNo",
         "SerialNo",
         "Specification",
         "ToleranceUp",
         "ToleranceDown"
ORDER BY "MIN(PointData)" ASC
LIMIT 10000;

the above query is generated automatically by superset tool, after then show error Expression 'MaxAndMinTable.td' is not being grouped.
if i revised it to whether of below, it works.

SELECT "PointName" AS "PointName",
       "MeasurementDate2" AS "MeasurementDate2",
       "MeasurementDate1" AS "MeasurementDate1",
       DATE_TRUNC('day', td) AS td2,
       "PartNo" AS "PartNo",
       "SerialNo" AS "SerialNo",
       "Specification" AS "Specification",
       "ToleranceUp" AS "ToleranceUp",
       "ToleranceDown" AS "ToleranceDown",
       min("PointData") AS "MIN(PointData)"
FROM "OA"."ThreeD"."MaxAndMinTable"
GROUP BY "PointName",
         "MeasurementDate2",
         "MeasurementDate1",
         DATE_TRUNC('day', td),
         "PartNo",
         "SerialNo",
         "Specification",
         "ToleranceUp",
         "ToleranceDown"
ORDER BY "MIN(PointData)" ASC
LIMIT 10000;

or

SELECT "PointName" AS "PointName",
       "MeasurementDate2" AS "MeasurementDate2",
       "MeasurementDate1" AS "MeasurementDate1",
       DATE_TRUNC('day', td) AS td,
       "PartNo" AS "PartNo",
       "SerialNo" AS "SerialNo",
       "Specification" AS "Specification",
       "ToleranceUp" AS "ToleranceUp",
       "ToleranceDown" AS "ToleranceDown",
       min("PointData") AS "MIN(PointData)"
FROM "OA"."ThreeD"."MaxAndMinTable"
GROUP BY "PointName",
         "MeasurementDate2",
         "MeasurementDate1",
          td,
         "PartNo",
         "SerialNo",
         "Specification",
         "ToleranceUp",
         "ToleranceDown"
ORDER BY "MIN(PointData)" ASC
LIMIT 10000;
2

@niyouzhu

Remember there was a bug like this, what version of Dremio are you on? Can you please send us the profile?

4

dremio-oss version 20.1.0, we deployed Dremio in kubernetes environment by using helm.
actually this bug also existed in previous version of Dremio.

5

@niyouzhu Are you able to send us the profile so we can try to reproduce?

6

what is the profile? detail it.

7