我的目标是在centos7上使用elasticsearch从mysql数据库中提取数据。
我跟踪了这个link:elasticsearch how 与mysql集成。
已创建名为elasticsearchdatabase的数据库
“test”表名
已安装java 8。
已安装elasticsearch 6.2.4。
elasticsearch-jdbc-2.3.4.1-dist.zip在/etc/elasticsearch下解压缩
“logs”文件夹是在/etc/elasticsearch下创建的
当我执行以下命令时得到了这个结果：
curl -xget'http://localhost：9200/“漂亮”

{
  "name" : "vps.server.com",
  "cluster_name" : "my-application",
  "cluster_uuid" : "ICqEEr1VQHK8mZ82x7J_YQ",
  "version" : {
    "number" : "6.2.4",
    "build_hash" : "ccec39f",
    "build_date" : "2018-04-12T20:37:28.497551Z",
    "build_snapshot" : false,
    "lucene_version" : "7.2.1",
    "minimum_wire_compatibility_version" : "5.6.0",
    "minimum_index_compatibility_version" : "5.0.0"
  },
  "tagline" : "You Know, for Search"

然后我把：

echo '{                                               
"type":"jdbc",
"jdbc":{
"url":"jdbc:mysql://localhost:3306/ElasticSearchDatabase",
"user":"root",
"password":"root",
"sql":"SELECT id as _id, id, name,email FROM test",
"index":"users",
"type":"users",
"autocommit":"true",
"metrics": {
            "enabled" : true
        },
        "elasticsearch" : {
             "cluster" : "my-application",
             "host" : "localhost",
             "port" : 9300 
        } 
}
}' | java -cp "/etc/elasticsearch/elasticsearch-jdbc-2.3.4.1/lib/*" - 
 "Dlog4j.configurationFile=file:////etc/elasticsearch/elasticsearch-jdbc- 
  2.3.4.1/bin/log4j2.xml" "org.xbib.tools.Runner" 
 "org.xbib.tools.JDBCImporter"

为了得到我想要的结果，我已经执行了这个命令：
curl -xgethttp://localhost：9200/users/\u search/？漂亮
这是我得到的结果：

{
  "error" : {
    "root_cause" : [
      {
        "type" : "index_not_found_exception",
        "reason" : "no such index",
        "resource.type" : "index_or_alias",
        "resource.id" : "users",
        "index_uuid" : "_na_",
        "index" : "users"
      }
    ],
    "type" : "index_not_found_exception",
    "reason" : "no such index",
    "resource.type" : "index_or_alias",
    "resource.id" : "users",
    "index_uuid" : "_na_",
    "index" : "users"
  },
  "status" : 404
}

任何人都知道这个错误。谢谢你的帮助。