0 ×

Elasticsearch Reader

Elasticsearch Nodes version 1.1.0.202004201728 by Daniel Esser

This node executes a given query against Elasticsearch and returns a list of results.

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 authentidaction 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
The Elasticsearch index the query is executed against. Fetch existing indices via "Fetch from ES" button. Don't specify an index, if you like to query all existing indices. This option might not be available if you have speficied the index via the "Elasticseach Index" node already.
Type
The document type the query should be restricted to. Fetch existing types via "Fetch from ES" button. Don't specify a type, if you like to query all existing documents ignoring the document type. This option might not be available if you have speficied the type via the "Elasticseach Type" 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 speficied the route via the "Elasticseach Route" node already.
Query
The query written in Elasticsearch Query DSL. This option might not be available if you have speficied the query via the "Elasticseach 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 Elasticseach Search.

Output Ports

Icon
The results of the executed query.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install Elasticsearch Nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.