从MySQL导入数据到ElastICsearch

#!/bin/sh

JDBC_IMPORTER_HOME="es的绝对路径"

bin=$JDBC_IMPORTER_HOME/bin

lib=$JDBC_IMPORTER_HOME/lib

host=localhost

echo '{

"type" : "jdbc",

"jdbc": {

"elasticsearch.autodiscover":true,

"url":"jdbc:mysql://IP:3306/数据库名字",

"user":"用户",

"password":"密码",

"sql":"select * ,id as _id from news",

"elasticsearch" : {

  "cluster" : "es集群名字",

  "host" : "IP",

  "port" : 9300

},

"index" : "索引",

"type" : "类型"

}

}'| java \

  -cp "${lib}/*" \

  -Dlog4j.configurationFile=${bin}/log4j2.xml \

  org.xbib.tools.Runner \

  org.xbib.tools.JDBCImporter

改成自己对应的名字，然后保存成shell文件运行即可。