- SERIES_SPEC (Primary input)
- The first of two series to compare. The primary input and secondary input must be of the same input payload content, meaning both are REAL or both are MULTIVAR_REAL. It does not matter which is passed in as primary or secondary. The computed distances are the same.
- SERIES_SPEC (Secondary input)
- The second of two series to compare. The primary input and secondary input must be of the same input payload content, meaning both are REAL or both are MULTIVAR_REAL. It does not matter which is passed in as primary or secondary. The computed distances are the same.
- FUNC_PARAMS
-
Name Data Type Description RADIUS Integer [Optional] The search radius for the FastDTW algorithm. The range is between 0 and 1000. Using a small radius is sufficient for finding the optimal match.
Default is 10.
DISTANCE VARCHAR(128) [Optional] The distance function to be used. The function options are: - Euclidean: Use the Euclidean distance function.
- Manhattan: Use the Manhattan distance function.
- Binary: Use the binary distance function.
Default is Euclidean.
WARPPATH BYTEINT [Optional] The type of warp paths. The following values are valid: - 0: No warp paths to be generated. Only the warp distance is calculated.
- 1: Warp paths to be generated with WarpX and WarpY output columns as the path index.
- 2: Warp paths to be generated with WarpX_I and WarpY_I using the series 1 and series 2 ROW_I values at the path index.
- 3: Warp paths to be generated with both the output columns 1 and 2.
Default is 0.
- INPUT_FMT
- Mandatory specification. The INPUT_MODE parameter has the following options:
- ONE2ONE: Both the primary and secondary series specifications include a WHERE filter clause identifying one series instance to serve as the input series for the mathematical operation.
- MANY2ONE: The primary input SERIES_SPEC references MANY series instances. The secondary input SERIES_SPEC includes a WHERE filter clause identifying a single series instance. When applying the mathematical operation, the secondary input single series is reused as many times as necessary to match the number of series instances found in the primary input.
- MATCH: A series instance residing in the primary input whose SERIES_ID matches the SERIES_ID of a series instance in the secondary input, has the mathematical operation applied to produce a result series. For those instances in one input who have no corresponding SERIES_ID partner in the other input, the series is skipped over.
- OUTPUT_FMT
- No OUTPUT_FMT options are available for this function.