ElasticSearch - creating JDBC river -


I am working on a PHP project, using MYSQL to store data. I want to use Elastic Search Search Engine to search for setting up ES on my Mac OS. I know that I should make JDBC river but I do not know how any body can help me? Thank you.

Steps to install

1) Download and install Elasticsearch
2) Installing flexible accesskey from the installation directory bin / elasticsearch start <3> install river-jdbc Plugin for Flexible Detector version. You can get the JDBC River Plugin for your version from

If you are using iLatics Search version 1.0.0, then your installation command

  ./bin / plugin --install will be river-jdbc --url http://bit.ly/1gIk4jW   

4) Now download MySQL JDBC driver. The current version is 5.1.30 You can copy copy jar in elasticsearch / plugins / river-jdbc direcory

6) Now from your installation directory Restart elasticsearch

bin / elsaticsearch -f

7) Configure command commands with your elastic search index jbdc river.

  curl -XPUT 'localhost: 9200 / _river / my_jdbc_river / my_jdbc_river / _meta' -d '{"type": "jdbc", "jdbc": {"url": "jdbc: Mysql: // localhost: 3306 / test "," user ":" "," password ":" "," SQL ":" select from your dbbit "," index ":" list_index_name_ here "," type " You can use more parameters  

8) Now test your plugin or not using the command < / P>

  curl -XGET 'localhost: 9200 / jdbc / _search? Pretty & amp; ; Q = * '   

Comments

Popular posts from this blog

Java - Error: no suitable method found for add(int, java.lang.String) -

java - JPA TypedQuery: Parameter value element did not match expected type -

c++ - static template member variable has internal linkage but is not defined -