This operator can be used to translate a key-value/json object to a tuple.
Names are JSON-Path Exceptions
If names contains special chars like ".", "*", etc. the chars will be replaced by "_".
To define own names you ['Path','Name','Type'] in the schema.
Parameter
schema:
The list of requested attributes (keys) and their data type.
type:
The type of the output tuplekeepInput:
If set to true, the key-value is stored in the additional content container of the output tuple.dateFormat:
Can be used to format the timestamp. To create a timestamp an attribute of data type STARTTIMESTAMP or ENDTIMESTAMP has to be added to schema.
Example
Example
out = KEYVALUETOTUPLE({ schema=[['Name', 'Double']], type='Measurement', keepinput='false' }, in )
Example 2
Assume that a data source in
sends key-value-pairs about persons in the following (JSON-)format:
{person.name="Max", person.age=22, timestamp=11123}
Then, reading the name (and timestamp) is as follows:
Example
out = KEYVALUETOTUPLE({ schema=[['person.name', 'String'], ['timestamp', 'STARTTIMESTAMP']], type='Measurement', keepinput='false' }, in )