elasticsearch-jdbc 例子
#!/bin/sh
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
bin=${DIR}/../bin
lib=${DIR}/../lib
echo '{
"type" : "jdbc",
"jdbc": {
"elasticsearch.autodiscover":true,
"elasticsearch.cluster":"*",
"url":"jdbc:mysql://***:3306/es",
"user":"***",
"password":"***",
"sql":"SELECT id as _id , id, name, status, type, full_name, frequency, gmt_modified FROM table",
"elasticsearch" : {
"host" : "***.***.***.***",
"port" : 9300
},
"index" : "*",
"type" : "*",
"type_mapping": {
"*": {
"properties": {
"id": {
"type" : "long",
"include_in_all" : false
},
"name": {
"type" : "string",
"index" : "not_analyzed",
"include_in_all" : false
},
"status": {
"type" : "integer",
"include_in_all" : false
},
"type": {
"type" : "integer",
"include_in_all" : false
},
"full_name": {
"type" : "string",
"index" : "not_analyzed",
"include_in_all" : false
},
"frequency": {
"type" : "integer",
"include_in_all" : false
},
"gmt_modified": {
"type" : "date",
"include_in_all" : false
}
}
}
}}
}'| java \
-cp "${lib}/*" \
-Dlog4j.configurationFile=${bin}/log4j2.xml \
org.xbib.tools.Runner \
org.xbib.tools.JDBCImporter
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
