| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
...
Tab | Field | Description | |
|---|---|---|---|
General | Name | Enter a name for the unit. It must start with a letter, and cannot contain spaces. Only letters, numbers, and underscores are allowed. | |
Description | Enter a description detailing the scope of the unit. | ||
Query | The Devo query to be performed. This query can include parameters (defined in the 'parameters' field), that will be filled with the corresponding input event field. | ||
Start time | You can specify a start time if you wish to test the query without input events. The unit will start sending data from that time included. | ||
End time | You can specify an end time if you wish to test the query without input events. The unit will stop sending data from this time (excluded). | ||
Parameters | A list of field names of the input events to be used as parameters in the query. | ||
Map on | When defined, this is the name of the output event field if you wish it to contain a map from column names to values. | ||
Kill current queries | As this is a passive unit, there can be a number of queries running simultaneously, depending on the number of threads (active units) providing data to it. Turn this on to kill previous queries before issuing a new query on a new input event. | ||
Columns | Event field | The name of an input event field containing a list of (name, type) pairs. | |
Fields | Click the plus icon to add name-type pairs. You can collapse and expand the pairs using the You can also reorder the fields using drag and drop. | ||
Name | The name of an output event field where the query result will be inserted. | ||
Type | The expected type for the query result (you can also write a java class qualified name). | ||
From event In this tab, you can specify values corresponding to input event fields, overriding previous settings. If no corresponding field is found in the input event, the default values are applied. | Query | Input event field containing the query. | |
Start time | Input event field containing the start time. | ||
End time | Input event field containing the end time. | ||
...
Then, we will define the destination table using the Devo Sink unit as a my.app table. Link the Data port of the Devo Full Query unit to the in port of the Devo Sink.
| Info |
|---|
After saving and starting the Flow, you must click the red button of the Tick unit to begin sending events. |
📁 Download this example
You can try this flow by downloading the following JSON file and uploading it to your domain using the Import option:
...