• v7.2.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Devo
NEXT
Devo Last Event Date

Flow / Unit types / Devo / Devo Full Query

Download as PDF

Devo Full Query

Description

This unit is a Source unit type.

This unit runs the query specified in its settings for each input event.

Output events are generated both to signal query operations and to deliver query results. 

An input event comes through the in port. Then, an event is sent to the init port to signal the start of the query. The query specified in the properties is executed. An event is sent through the data port for each result row.

The error port outputs an event every time there's an error running the query, retrieving new records, etc. The unit adds the field "action" to the output events with the value 'error', plus other standard error fields containing details about the error.

Finally, an event is sent through the end port every time a query ends, be it after an error, or when there are no more results. These events are the same as the input events, without any modification.

Configuration

After dragging this unit into the Flow canvas, double-click it to access its configuration options. The following table describes the configuration options of this unit:

TabFieldDescription
GeneralNameEnter a name for the unit. It must start with a letter, and cannot contain spaces. Only letters, numbers, and underscores are allowed.
QueryThe 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 timeYou 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 timeYou 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).
ParametersA list of field names of the input events to be used as parameters in the query.
Map onWhen 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 queriesAs 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.
ColumnsEvent fieldThe 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 icon, reorder using the arrows, or delete using the X icon.

NameThe name of an output event field where the query result will be inserted.
TypeThe 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.

QueryInput event field containing the query. 
Start timeInput event field containing the start time.
End timeInput event field containing the end time.

Input ports

PortDescription
inEach of the events in this stream will run the indicated query.

Output ports

PortDescription
initOutputs an event every time a new query is launched (on each input event). These events are the same as the input events, without any modification.
dataOutputs an event for each query result row. The events generated are the input events extended with fields including the query results. Further required columns can be specified in the unit configuration options.
errorOutputs an event every time there's an error running the query, retrieving new records, etc. The generated event is an input event enriched with standard error messages.
endOutputs an event every time a query ends, be it after an error, or when there are no more results. These events are the same as the input events, without any modification.
Download as PDF

PREVIOUS
Devo
NEXT
Devo Last Event Date

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.2.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport