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