#!/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進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
