ElasticSearch Cookbook

Book Image

ElasticSearch Cookbook

By : Alberto Paro

Book Image

ElasticSearch Cookbook

By: Alberto Paro

Overview of this book

ElasticSearch Cookbook Second Edition

ElasticSearch Cookbook Second Edition

Credits

About the Author

About the Author

Acknowledgments

Acknowledgments

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Getting Started

Getting Started

Understanding nodes and clusters

Understanding node services

Managing your data

Understanding clusters, replication, and sharding

Communicating with ElasticSearch

Using the HTTP protocol

Using the native protocol

Using the Thrift protocol

Downloading and Setting Up

Downloading and Setting Up

Downloading and installing ElasticSearch

Setting up networking

Setting up a node

Setting up for Linux systems

Setting up different node types

Installing plugins in ElasticSearch

Installing a plugin manually

Removing a plugin

Changing logging settings

Managing Mapping

Managing Mapping

Using explicit mapping creation

Mapping base types

Mapping an object

Mapping a document

Using dynamic templates in document mapping

Managing nested objects

Managing a child document

Adding a field with multiple mappings

Mapping a geo point field

Mapping a geo shape field

Mapping an IP field

Mapping an attachment field

Adding metadata to a mapping

Specifying a different analyzer

Mapping a completion suggester

Basic Operations

Basic Operations

Creating an index

Deleting an index

Opening/closing an index

Putting a mapping in an index

Getting a mapping

Deleting a mapping

Refreshing an index

Flushing an index

Optimizing an index

Checking if an index or type exists

Managing index settings

Using index aliases

Indexing a document

Getting a document

Deleting a document

Updating a document

Speeding up atomic operations (bulk operations)

Speeding up GET operations (multi GET)

Search, Queries, and Filters

Search, Queries, and Filters

Executing a search

Sorting results

Highlighting results

Executing a scan query

Suggesting a correct query

Counting matched results

Deleting by query

Matching all the documents

Querying/filtering for a single term

Querying/filtering for multiple terms

Using a prefix query/filter

Using a Boolean query/filter

Using a range query/filter

Using span queries

Using a match query

Using an ID query/filter

Using a has_child query/filter

Using a top_children query

Using a has_parent query/filter

Using a regexp query/filter

Using a function score query

Using exists and missing filters

Using and/or/not filters

Using a geo bounding box filter

Using a geo polygon filter

Using geo distance filter

Using a QueryString query

Using a template query

Aggregations

Executing an aggregation

Executing the stats aggregation

Executing the terms aggregation

Executing the range aggregation

Executing the histogram aggregation

Executing the date histogram aggregation

Executing the filter aggregation

Executing the global aggregation

Executing the geo distance aggregation

Executing nested aggregation

Executing the top hit aggregation

Scripting

Installing additional script plugins

Managing scripts

Sorting data using script

Computing return fields with scripting

Filtering a search via scripting

Updating a document using scripts

Rivers

Managing a river

Using the CouchDB river

Using the MongoDB river

Using the RabbitMQ river

Using the JDBC river

Using the Twitter river

Cluster and Node Monitoring

Cluster and Node Monitoring

Controlling cluster health via the API

Controlling cluster state via the API

Getting cluster node information via the API

Getting node statistics via the API

Managing repositories

Executing a snapshot

Restoring a snapshot

Installing and using BigDesk

Installing and using ElasticSearch Head

Installing and using SemaText SPM

Installing and using Marvel

Java Integration

Java Integration

Creating an HTTP client

Creating a native client

Managing indices with the native client

Managing mappings

Managing documents

Managing bulk actions

Building a query

Executing a standard search

Executing a search with aggregations

Executing a scroll/scan search

Python Integration

Python Integration

Creating a client

Managing indices

Managing mappings

Managing documents

Executing a standard search

Executing a search with aggregations

Plugin Development

Plugin Development

Creating a site plugin

Creating a native plugin

Creating a REST plugin

Creating a cluster action

Creating an analyzer plugin

Creating a river plugin

Index

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Using the JDBC river

Generally, application data is stored in a DBMS of some kind (Oracle, MySQL, PostgreSql, a Microsoft SQL server, and SQLite, among others). To power up a traditional application with the advanced search capabilities of ElasticSearch and Lucene, all this data must be imported to ElasticSearch. The JDBC river by Jörg Prante allows you to connect to the DBMS, executing queries and indexing the results.

This plugin can work both as a standard river or as a standalone feeder, so the ingestion part can be executed independently of ElasticSearch.

Getting ready

You will need a working ElasticSearch cluster.

How to do it...

In order to use the JDBC river, perform the following steps:

First, you need to install the JDBC river plugin, which is available on GitHub (https://github.com/jprante/elasticsearch-river-jdbc). You can install the river plugin using the following code:
```
bin/plugin -url http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4/elasticsearch...
```