You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2022/01/05 08:00:00 UTC
[jira] [Created] (IOTDB-2269) Unregistered UDF queries, the Msg prompt should start with 4
xiaozhihong created IOTDB-2269:
----------------------------------
Summary: Unregistered UDF queries, the Msg prompt should start with 4
Key: IOTDB-2269
URL: https://issues.apache.org/jira/browse/IOTDB-2269
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Server
Affects Versions: 0.13.0
Reporter: xiaozhihong
Attachments: image-2022-01-05-15-55-15-039.png
Like this:
Step1：Enter CLI
IoTDB> show functions
15:46:09.654 [main] DEBUG org.apache.iotdb.rpc.AutoResizingBuffer - org.apache.iotdb.rpc.AutoResizingBuffer@815b41f expand from 1024 to 8001, request: 8001
+-----------------------+-------------+--------------------------------------------------------------------+
| function name|function type| class name (UDF)|
+-----------------------+-------------+--------------------------------------------------------------------+
| ABS|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFAbs|
| ACF|external UDTF| org.apache.iotdb.quality.dprofile.UDTFACF|
| ACOS|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFAcos|
| ASIN|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFAsin|
| ATAN|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFAtan|
| AVG| native| |
| BOTTOM_K|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFBottomK|
| CAST|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFCast|
| CEIL|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFCeil|
| COMPLETENESS|external UDTF| org.apache.iotdb.quality.dquality.UDTFCompleteness|
| CONSECUTIVESEQUENCES|external UDTF| org.apache.iotdb.quality.series.UDTFConsecutiveSequences|
| CONSECUTIVEWINDOWS|external UDTF| org.apache.iotdb.quality.series.UDTFConsecutiveWindows|
| CONSISTENCY|external UDTF| org.apache.iotdb.quality.dquality.UDTFConsistency|
| CONST|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFConst|
| CONV|external UDTF| org.apache.iotdb.quality.frequency.UDTFConv|
| COS|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFCos|
| COSH|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFCosh|
| COUNT| native| |
| COV|external UDTF| org.apache.iotdb.quality.dmatch.UDAFCov|
| DECONV|external UDTF| org.apache.iotdb.quality.frequency.UDTFDeconv|
| DEGREES|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFDegrees|
| DERIVATIVE|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFCommonDerivative|
| DIFFERENCE|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFCommonValueDifference|
| DISTINCT|external UDTF| org.apache.iotdb.quality.dprofile.UDTFDistinct|
| DTW|external UDTF| org.apache.iotdb.quality.dmatch.UDAFDtw|
| DWT|external UDTF| org.apache.iotdb.quality.frequency.UDTFDWT|
| E|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFConstE|
| EXAMPLE|external UDTF| org.apache.iotdb.udf.UDTFExample|
| EXP|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFExp|
| EXTREME| native| |
| FFT|external UDTF| org.apache.iotdb.quality.frequency.UDTFFFT|
| FIRST_VALUE| native| |
| FLOOR|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFFloor|
| HIGHPASS|external UDTF| org.apache.iotdb.quality.frequency.UDTFHighPass|
| HISTOGRAM|external UDTF| org.apache.iotdb.quality.dprofile.UDTFHistogram|
| IDWT|external UDTF| org.apache.iotdb.quality.frequency.UDTFIDWT|
| IFFT|external UDTF| org.apache.iotdb.quality.frequency.UDTFIFFT|
| INTEGRAL|external UDTF| org.apache.iotdb.quality.dprofile.UDAFIntegral|
| INTEGRALAVG|external UDTF| org.apache.iotdb.quality.dprofile.UDAFIntegralAvg|
| IQR|external UDTF| org.apache.iotdb.quality.anomaly.UDTFIQR|
| KSIGMA|external UDTF| org.apache.iotdb.quality.anomaly.UDTFKSigma|
| LAST_VALUE| native| |
| LN|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFLog|
| LOF|external UDTF| org.apache.iotdb.quality.anomaly.UDTFLOF|
| LOG10|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFLog10|
| LOWPASS|external UDTF| org.apache.iotdb.quality.frequency.UDTFLowPass|
| MAD|external UDTF| org.apache.iotdb.quality.dprofile.UDAFMad|
| MAX_TIME| native| |
| MAX_VALUE| native| |
| MEDIAN|external UDTF| org.apache.iotdb.quality.dprofile.UDAFMedian|
| MIN_TIME| native| |
| MIN_VALUE| native| |
| MINMAX|external UDTF| org.apache.iotdb.quality.dprofile.UDTFMinMax|
| MODE|external UDTF| org.apache.iotdb.quality.dprofile.UDAFMode|
| MVAVG|external UDTF| org.apache.iotdb.quality.dprofile.UDTFMvAvg|
|NON_NEGATIVE_DERIVATIVE|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFNonNegativeDerivative|
|NON_NEGATIVE_DIFFERENCE|built-in UDTF|org.apache.iotdb.db.query.udf.builtin.UDTFNonNegativeValueDifference|
| PACF|external UDTF| org.apache.iotdb.quality.dprofile.UDTFPACF|
| PEARSON|external UDTF| org.apache.iotdb.quality.dmatch.UDAFPearson|
| PERCENTILE|external UDTF| org.apache.iotdb.quality.dprofile.UDAFPercentile|
| PERIOD|external UDTF| org.apache.iotdb.quality.dprofile.UDAFPeriod|
| PI|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFConstPi|
| PTNSYM|external UDTF| org.apache.iotdb.quality.dmatch.UDTFPtnSym|
| QLB|external UDTF| org.apache.iotdb.quality.dprofile.UDTFQLB|
| RADIANS|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFRadians|
| RANGE|external UDTF| org.apache.iotdb.quality.anomaly.UDTFRange|
| REGEXMATCH|external UDTF| org.apache.iotdb.quality.string.UDTFRegexMatch|
| REGEXREPLACE|external UDTF| org.apache.iotdb.quality.string.UDTFRegexReplace|
| REGEXSPLIT|external UDTF| org.apache.iotdb.quality.string.UDTFRegexSplit|
| ROUND|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFRound|
| SAMPLE|external UDTF| org.apache.iotdb.quality.dprofile.UDTFSample|
| SEGMENT|external UDTF| org.apache.iotdb.quality.dprofile.UDTFSegment|
| SIGN|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFSign|
| SIN|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFSin|
| SINH|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFSinh|
| SKEW|external UDTF| org.apache.iotdb.quality.dprofile.UDAFSkew|
| SPLINE|external UDTF| org.apache.iotdb.quality.dprofile.UDTFSpline|
| SPREAD|external UDTF| org.apache.iotdb.quality.dprofile.UDAFSpread|
| SQRT|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFSqrt|
| STDDEV|external UDTF| org.apache.iotdb.quality.dprofile.UDAFStddev|
| STRING_CONTAINS|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFContains|
| STRING_MATCHES|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFMatches|
| STRREPLACE|external UDTF| org.apache.iotdb.quality.string.UDTFStrReplace|
| SUM| native| |
| TAN|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFTan|
| TANH|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFTanh|
| TIME_DIFFERENCE|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFTimeDifference|
| TIMELINESS|external UDTF| org.apache.iotdb.quality.dquality.UDTFTimeliness|
| TIMESTAMPREPAIR|external UDTF| org.apache.iotdb.quality.drepair.UDTFTimestampRepair|
| TOP_K|built-in UDTF| org.apache.iotdb.db.query.udf.builtin.UDTFTopK|
| TWOSIDEDFILTER|external UDTF| org.apache.iotdb.quality.anomaly.UDTFTwoSidedFilter|
| VALIDITY|external UDTF| org.apache.iotdb.quality.dquality.UDTFValidity|
| VALUEFILL|external UDTF| org.apache.iotdb.quality.drepair.UDTFValueFill|
| VALUEREPAIR|external UDTF| org.apache.iotdb.quality.drepair.UDTFValueRepair|
| XCORR|external UDTF| org.apache.iotdb.quality.dmatch.UDTFXCorr|
| ZSCORE|external UDTF| org.apache.iotdb.quality.dprofile.UDTFZScore|
+-----------------------+-------------+--------------------------------------------------------------------+
Total line number = 96
Step 2：Execute Query SQL：
select TAM(s1) from root.test.d1
!image-2022-01-05-15-55-15-039.png!
--
This message was sent by Atlassian Jira
(v8.20.1#820001)