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

另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。