weijunlu

@cgivre Ok, thank you very much!

add the log and the sql execute plan: `Caused by: org.apache.drill.exec.ops.QueryCancelledException: null at org.apache.drill.exec.work.fragment.FragmentExecutor$ExecutorStateImpl.checkContinue(FragmentExecutor.java:533) at org.apache.drill.exec.record.AbstractRecordBatch.checkContinue(AbstractRecordBatch.java:246) at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:100) at org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59) at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:160) at org.apache.drill.exec.record.RecordIterator.clearInflightBatches(RecordIterator.java:359) at org.apache.drill.exec.record.RecordIterator.close(RecordIterator.java:365) at org.apache.drill.exec.physical.impl.join.MergeJoinBatch.close(MergeJoinBatch.java:300) at org.apache.drill.common.DeferredException.suppressingClose(DeferredException.java:159)...

I run the whole test process again, found that the heap memory reached 94%, no longer release, and then executed the above sql statement, immediately reported an error:  

@cgivre yes, I used the master version. apache drill> select version, commit_message, commit_time from sys.version; +----------------+----------------------------------------------------------------------------------+---------------------------+ | version | commit_message | commit_time | +----------------+----------------------------------------------------------------------------------+---------------------------+ | 2.0.0-SNAPSHOT | DRILL-8314: Add support...

I opened the trace log, included the calcite log. Log configurations are as follows:

2022-12-28 19:03:07,204 [main] DEBUG o.a.d.j.impl.DrillStatementRegistry - Adding to open-statements registry: org.apache.drill.jdbc.impl.DrillStatementImpl@71df3d2b 2022-12-28 19:03:07,204 [main] DEBUG o.a.d.j.i.DrillCursor$ResultsListener - [#2] Query listener created. 2022-12-28 19:03:07,204 [main] DEBUG o.apache.drill.jdbc.impl.DrillCursor - Setting timeout as...

2022-12-28 19:03:07,330 [1c53dd94-4277-9ab0-effe-18b1ab8989ac:foreman] TRACE o.apache.calcite.plan.RelOptPlanner - Rule queue: rule [JdbcTableModificationRule(in:NONE,out:JDBC.mysql)(in:NONE,out:JDBC.mysql)] rels [#112] rule [JdbcTableModificationRule(in:NONE,out:JDBC.pg)(in:NONE,out:JDBC.pg)] rels [#112] rule [ExpandConversionRule] rels [#115] rule [JDBC_PREL_ConverterJDBC.mysql] rels [#118,#89] rule [JdbcTableModificationRule(in:NONE,out:JDBC.mysql)(in:LOGICAL,out:JDBC.mysql)] rels [#120] rule [JdbcTableModificationRule(in:NONE,out:JDBC.pg)(in:LOGICAL,out:JDBC.pg)]...

2022-12-28 19:03:07,350 [1c53dd94-4277-9ab0-effe-18b1ab8989ac:foreman] TRACE o.apache.calcite.plan.RelOptPlanner - Rule queue: rule [ExpandConversionRule] rels [#130] rule [VertexDrelConverterRuleJDBC.pg(in:JDBC.pg,out:LOGICAL)] rels [#130] rule [JDBC_PREL_ConverterJDBC.mysql] rels [#134,#121] rule [JDBC_PREL_ConverterJDBC.pg] rels [#136,#124] 2022-12-28 19:03:07,350 [1c53dd94-4277-9ab0-effe-18b1ab8989ac:foreman] DEBUG o.apache.calcite.plan.RelOptPlanner -...

2022-12-28 19:03:07,401 [1c53dd94-4277-9ab0-effe-18b1ab8989ac:foreman] DEBUG o.a.d.e.p.s.h.DefaultSqlHandler - Drill Plan : { "head" : { "version" : 1, "generator" : { "type" : "InsertHandler", "info" : "" }, "type" : "APACHE_DRILL_PHYSICAL", "options"...

@vvysotskyi @cgivre. If MySQL disables only_full_group_by, the sql can be executed. Jupiter (mysql.test)> select 2..........semicolon> extract(year from o_orderdate) as o_year 3..........semicolon> from orders 4..........semicolon> group by o_year 5..........semicolon> order by...