需要安装elasticsearch-jdbc,地址:https://github.com/jprante/elasticsearch-jdbc
要注意查看elasticsearch-jdbc的lib目录下是否有jdbc driver的jar文件,如jdbc-driver-csv-1.0.0.jar,若没有则自行下载并添加到lib目录下。
安装完成后,写bash脚本,例如:
#!/bin/sh
bin=/usr/local/elasticsearch-jdbc-1.7.1.0/bin
lib=/usr/local/elasticsearch-jdbc-1.7.1.0/lib
echo '{
"type" : "jdbc",
"jdbc": {
"url":"jdbc:mysql://localhost:3306/elasticsearch",
"user":"root",
"password":"***",
"sql":"select * from goods",
"index" : "elasticsearch",
"type" : "goods"
}
}' | java -cp "${lib}/*" -Dlog4j.configurationFile=/usr/local/elasticsearch-jdbc-1.7.1.0/bin/log4j2.xml org.xbib.tools.Runner org.xbib.tools.JDBCImporter
运行bash脚本即可