You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2022/01/07 08:33:00 UTC
[jira] [Assigned] (IOTDB-2269) Unregistered UDF queries, the Msg prompt should start with 4
[ https://issues.apache.org/jira/browse/IOTDB-2269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haonan Hou reassigned IOTDB-2269:
---------------------------------
Assignee: Steve Yurong Su
> 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-SNAPSHOT
> Reporter: xiaozhihong
> Assignee: Steve Yurong Su
> Priority: Major
> 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)