Miscellaneous SQL functions
The InfluxDB SQL implementation supports the following miscellaneous functions for performing a variety of operations:
arrow_cast
Casts a value to a specific Arrow data type.
arrow_cast(expression, datatype)
Arguments
- expression: Expression to cast. Can be a constant, column, or function, and any combination of arithmetic or string operators.
- datatype: Arrow data type to cast to.
arrow_typeof
Returns the underlying Arrow data type of the the expression:
arrow_typeof(expression)
Arguments
- expression: Expression to evaluate. Can be a constant, column, or function, and any combination of arithmetic or string operators.
interpolate
Fills null values in a specified aggregated column by interpolating values
from existing values.
Must be used with date_bin_gapfill
.
interpolate(aggregate_expression)
Arguments
- aggregate_expression: Aggregate operation on a specified expression. The operation can use any aggregate function. The expression can be a constant, column, or function, and any combination of arithmetic operators supported by the aggregate function.
Related functions
locf
Fills null values in a specified aggregated column by carrying the last observed
value forward.
Must be used with date_bin_gapfill
.
LOCF is an initialism of “last observation carried forward.”
locf(aggregate_expression)
Arguments
- aggregate_expression: Aggregate operation on a specified expression. The operation can use any aggregate function. The expression can be a constant, column, or function, and any combination of arithmetic operators supported by the aggregate function.
Related functions
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.