#!/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
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
