bin=/home/elasticsearch-jdbc-2.2.1.0/bin
lib=/home/elasticsearch-jdbc-2.2.1.0/lib
echo '{
"type" : "jdbc",
"jdbc": {
"elasticsearch":{
"cluster":"vsosearch",
"host":"192.168.12.6",
"port":9300
},
"url":"jdbc:mysql://192.168.12.31:3306/com_vsochina_maker",
"user":"root",
"password":"dell_456",
"sql":"select * from tb_crm_company",
"index" : "crm_category_new",
"type" : "mytype"
}
}' | java \
-cp "${lib}/*" \
-Dlog4j.configurationFile=${bin}/log4j2.xml \
org.xbib.tools.Runner \
org.xbib.tools.JDBCImporter