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 If you are using iLatics Search version 1.0.0, then your installation command 4) Now download MySQL JDBC driver. The current version is 5.1.30 You can copy copy jar in 6) Now from your installation directory Restart elasticsearch 7) Configure command commands with your elastic search index jbdc river. 8) Now test your plugin or not using the command < / P> 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
./bin / plugin --install will be river-jdbc --url http://bit.ly/1gIk4jW
elasticsearch / plugins / river-jdbc direcory
bin / elsaticsearch -f
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
curl -XGET 'localhost: 9200 / jdbc / _search? Pretty & amp; ; Q = * '
Comments
Post a Comment