OrientDB Query

Executes idempotent query. This node is used for retrieving information from the database. Suggested commands: select, traverse, expand, match, shortestPath.

Options

Schema
Select source of schema of future Knime data table. Next different modes are available:
  1. _dynamic_: The result will be returned as Knime table according to the user query.
  2. _as_json_: The result will be returned as table of JSON rows with one column.
  3. class name: Selected schema class will be used to get information about columns and their types.
Query
Executes user defined query
Generate RowID by @rid
In case of error with RowID duplicates use this option, so the RowID will be defined according to unique @rid.
Flow Variables
List of the workflow Flow Variables, that can be used as the wildcards in the query text.
Classes and Fields
Fetched from the connected database according to the schema. Can be used as the wildcards in the query text.

Input Ports

Icon
Input data table.
Icon
OrientDB Connection.

Output Ports

Icon
Output data table.
Icon
OrientDB Connection.

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.