Skip to main content

length (Function)

Returns the length of the input string.

Syntax

<INT> str:length(<STRING> input.string)

Query Parameters

NameDescriptionDefault ValuePossible Data TypesOptionalDynamic
input.stringThe input string to derive the length.STRINGNoYes

Example 1

@info(name = 'lengthExample')
SELECT str:length('Hello World') AS stringLength;

The lengthExample demonstrates the use of the str:length() function to calculate the length of the given input string. In this example, the input string is 'Hello World'. The function returns 11, which is the length of the input string.

Example 2

CREATE STREAM InputDataStream (eventTime long, inputString string);
CREATE SINK STREAM OutputStream (eventTime long, stringLength int);

@info(name = 'lengthStreamWorker')
INSERT INTO OutputStream
SELECT eventTime, str:length(inputString) AS stringLength
FROM InputDataStream;

The lengthStreamWorker processes events from the InputDataStream and uses the str:length() function to calculate the length of the inputString attribute. The query outputs the eventTime and the calculated stringLength for each event to the OutputStream.