LmangM opened a new issue, #12943: URL: https://github.com/apache/iotdb/issues/12943
### Search before asking - [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar. ### Version Version: 1.3.1 BuildInfo: 214695d ### Describe the bug and provide the minimal reproduce step SQL Refer: https://iotdb.apache.org/zh/UserGuide/latest/Reference/Function-and-Expression.html#max-by As you can see, when using the built-in function MAX_BY, iotdb says that the function is not registered. It was also not found when I used the SHOW FUNCTIONS command to query registered functions. See the bash code below for details. SQL参考: https://iotdb.apache.org/zh/UserGuide/latest/Reference/Function-and-Expression.html#max-by 如你所见，在使用内置函数MAX_BY时，iotdb提示该函数未注册。当我使用SHOW FUNCTIONS命令查询已注册函数时也未发现此函数。详细内容请看下方bash代码。 ````bash --------------------- Starting IoTDB Cli --------------------- _____ _________ ______ ______ |_ _| | _ _ ||_ _ `.|_ _ \ | | .--.|_/ | | \_| | | `. \ | |_) | | | / .'`\ \ | | | | | | | __'. _| |_| \__. | _| |_ _| |_.' /_| |__) | |_____|'.__.' |_____| |______.'|_______/ version 1.3.1 (Build: 214695d) Successfully login at 192.168.123.123:6667 IoTDB> select stat from root.ln.wf01.wt01 order by time desc limit 10 +-----------------------------+----------------------+ | Time|root.ln.wf01.wt01.stat| +-----------------------------+----------------------+ |2025-01-01T00:00:00.000+08:00| 2630159.0| |2024-12-31T23:30:00.000+08:00| 2630094.5| |2024-12-31T23:00:00.000+08:00| 2630037.2| |2024-12-31T22:30:00.000+08:00| 2629961.5| |2024-12-31T22:00:00.000+08:00| 2629891.5| |2024-12-31T21:30:00.000+08:00| 2629837.0| |2024-12-31T21:00:00.000+08:00| 2629755.0| |2024-12-31T20:30:00.000+08:00| 2629684.2| |2024-12-31T20:00:00.000+08:00| 2629610.0| |2024-12-31T19:30:00.000+08:00| 2629559.2| +-----------------------------+----------------------+ Total line number = 10 It costs 0.140s IoTDB> select max_value(stat) from root.ln.wf01.wt01 +---------------------------------+ |max_value(root.ln.wf01.wt01.stat)| +---------------------------------+ | 2630159.0| +---------------------------------+ Total line number = 1 It costs 0.079s IoTDB> select max_by(time,stat) from root.ln.wf01.wt01 Msg: org.apache.iotdb.jdbc.IoTDBSQLException: 701: Error occurred during inferring UDF data type: java.lang.RuntimeException: Failed to reflect UDF instance, because UDF MAX_BY has not been registered. IoTDB> show functions +--------------------------------+---------------+---------------------------------------------------------------------+ | FunctionName| FunctionType| ClassName(UDF)| +--------------------------------+---------------+---------------------------------------------------------------------+ | ABS| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFAbs| | ACOS| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFAcos| | ASIN| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFAsin| | ATAN| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFAtan| | BOTTOM_K| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFBottomK| | CEIL| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFCeil| | CHANGE_POINTS| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFChangePoints| | CONCAT| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFConcat| | CONST| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFConst| | COS| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFCos| | COSH| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFCosh| | DEGREES| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFDegrees| | DERIVATIVE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFCommonDerivative| | DIFFERENCE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFCommonValueDifference| | E| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFConstE| | ENDSWITH| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFEndsWith| | EQUAL_SIZE_BUCKET_AGG_SAMPLE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFEqualSizeBucketAggSample| | EQUAL_SIZE_BUCKET_M4_SAMPLE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFEqualSizeBucketM4Sample| |EQUAL_SIZE_BUCKET_OUTLIER_SAMPLE| built-in UDTF|org.apache.iotdb.commons.udf.builtin.UDTFEqualSizeBucketOutlierSample| | EQUAL_SIZE_BUCKET_RANDOM_SAMPLE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFEqualSizeBucketRandomSample| | EXP| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFExp| | FLOOR| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFFloor| | IN_RANGE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFInRange| | JEXL| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFJexl| | LENGTH| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFStrLength| | LN| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFLog| | LOCATE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFStrLocate| | LOG10| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFLog10| | LOWER| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFLower| | M4| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFM4| | MASTER_REPAIR| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFMasterRepair| | NON_NEGATIVE_DERIVATIVE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFNonNegativeDerivative| | NON_NEGATIVE_DIFFERENCE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFNonNegativeValueDifference| | NON_ZERO_COUNT| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFNonZeroCount| | NON_ZERO_DURATION| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFNonZeroDuration| | ON_OFF| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFOnOff| | PI| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFConstPi| | RADIANS| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFRadians| | SIGN| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFSign| | SIN| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFSin| | SINH| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFSinh| | SQRT| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFSqrt| | STARTSWITH| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFStartsWith| | STRCMP| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFStrCompare| | STRING_CONTAINS| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFContains| | STRING_MATCHES| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFMatches| | TAN| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFTan| | TANH| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFTanh| | TIME_DIFFERENCE| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFTimeDifference| | TOP_K| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFTopK| | TRIM| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFTrim| | UPPER| built-in UDTF| org.apache.iotdb.commons.udf.builtin.String.UDTFUpper| | ZERO_COUNT| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFZeroCount| | ZERO_DURATION| built-in UDTF| org.apache.iotdb.commons.udf.builtin.UDTFZeroDuration| | VAR_POP| native| | | LAST_VALUE| native| | | COUNT| native| | | STDDEV_SAMP| native| | | VAR_SAMP| native| | | SUM| native| | | STDDEV_POP| native| | | MIN_TIME| native| | | MODE| native| | | COUNT_TIME| native| | | MIN_VALUE| native| | | AVG| native| | | VARIANCE| native| | | FIRST_VALUE| native| | | TIME_DURATION| native| | | MAX_TIME| native| | | STDDEV| native| | | EXTREME| native| | | COUNT_IF| native| | | MAX_VALUE| native| | | CAST|built-in scalar| | | ROUND|built-in scalar| | | REPLACE|built-in scalar| | | DIFF|built-in scalar| | | SUBSTRING|built-in scalar| | +--------------------------------+---------------+---------------------------------------------------------------------+ Total line number = 79 It costs 0.099s ### What did you expect to see? Make the MAX BY function usable as a user manual. ### What did you see instead? Msg: org.apache.iotdb.jdbc.IoTDBSQLException: 701: Error occurred during inferring UDF data type: java.lang.RuntimeException: Failed to reflect UDF instance, because UDF MAX_BY has not been registered. ### Anything else? nothing ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- 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]
