Elasticsearch Reader (ES 6)

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 .

Type

The document type the query should be restricted to. Fetch existing types via "Select a type…". 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 specified the type via the "Elasticsearch 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 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.

Views

This node has no views

Workflows

• 01-Query-ElasticsearchNodePit
• 02-Query-Elasticsearch-SimpleNodePit
• 04-Add-Documents-to-ElasticsearchNodePit
• elasticsearch-index-loop-through-indexes-25523NodePit Space

Links

• Install Elastich Search nodes on Knime Server from command lineby csantoni on 2021-01-25

  forum.knime.com/p/114114
• GET with BODY to query Elasticsearch REST APIby danielesser on 2020-04-14

  forum.knime.com/p/87565

Developers