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":"company",

"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" : "searchsuggestion-temp",

"type" : "searchsuggestion-temp",

"type_mapping": {

     "searchsuggestion-temp": {

      "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

本文转自whk66668888 51CTO博客，原文链接:http://blog.51cto.com/12597095/1909404