bug: some simple query statements cannot be executed with pivot

[cdmikechen]

Search before asking

• I had searched in the issues and found no similar issues.

Version

v1.2.615

What's Wrong?

SQL 错误: Error executing query: SQL: SELECT *
FROM test_table
PIVOT(avg("VALUE") FOR metric_code IN ('0101')) Query failed: QueryErrors{code=1005, message=Aggregate function is required} cause: null

How to Reproduce?

drop table test_table;
CREATE TABLE test_table (
  "DATA_TIME" timestamp, 
  "METRIC_CODE" string, 
  "VALUE" decimal(16,4)
);
insert into test_table values ('2024-09-30 14:09:36.000', '0101', 3.5128);

SELECT * 
FROM test_table
PIVOT(avg("VALUE") FOR metric_code IN ('0101'));

Are you willing to submit PR?

• Yes I am willing to submit a PR!