Elasticsearch Reader (ES 7)

Go to Product

This node executes a given query against Elasticsearch and returns a list of results as JSON documents. We recommend using the “JSON to Table” node as predecessor to convert the JSON results to a KNIME table.

Options

Protocol
The protocol used to connect to Elasticsearch. The following strategies are available:
  • HTTP: Connect via HTTP. Be aware: Data transfer is send unencrypted and vulnerable to man-in-the-middle attacks.
  • HTTPS: Connect via HTTPS. Data transfer is send encrypted. The Elasticsearch server has to support this mode.
Host
Host name.
Port
Network port under which Elasticsearch can be reached. By default Elasticsearch uses port 9200 for communication.
Accept all certificates
If enabled, all SSL certificates will be accepted. Caution: Only enable this option if you really know what you are doing!
Authentication
The protocol used to connect to Elasticsearch. The following strategies are available:
  • None: No authentication is used. Elasticsearch can be accessed without any access restrictions.
  • Credentials: Credentials are injected via KNIME credentials. Select the proper credential via drop-down menu.
  • Username & Password: Username and password are provided within the dialog. Enter username and password in the provided text fields.
Index
Elasticsearch index the query is executed against. Fetch existing indices via "Select an index…". Don't specify an index if you like to query all existing indices. You can also use wildcards. This option might not be available if you have specified the index via the "Elasticsearch Index" node already .
Routing
Specify a custom routing, if you like the query to be executed to a particular shard. This option might not be available if you have specified the route via the "Elasticsearch Route" node already.
Query
The query written in Elasticsearch Query DSL . This option might not be available if you have specified the query via the "Elasticsearch Query" node already. The following options might be defined to limit the amount of retrieved hits:
  • From: Retrieve hits from a certain offset. This defaults to 0, meaning you first get the best matching items.
  • Size: The number of hits that should be retrieved. By default, the node provides 10 items. Set this to "0" if you like to get all relevant hits. To query more efficient, the node uses Elasticsearch's Scroll API for deep scrolling and returning large amounts of items.

Input Ports

Icon
An Elasticsearch connection or Elasticsearch search.

Output Ports

Icon
The results of the executed query.

Views

This node has no views

Workflows

  • No workflows found

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.