下文分四部分:
一.清除旧有数据
二.增添测试数据
三.设置对name进行优化
四.将查询结果按name升序输出
一.清除旧有数据
#删除所有旧有数据并删除索引结构
命令:
curl -u elastic:123456 -XDELETE 'localhost:9200/apple'
返回结果:
{"acknowledged":true}
二.增添测试数据
#插入数据 Andy
命令:
curl -H "Content-Type: application/json" -XPUT 'localhost:9200/apple/emp/1?pretty' -d' {"name":"andy","age":"18","from":"China"}'
返回结果:
{ "_index" : "apple", "_type" : "emp", "_id" : "1", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 0, "_primary_term" : 1 }
#插入数据 Bill
curl -H "Content-Type: application/json" -XPUT 'localhost:9200/apple/emp/2?pretty' -d' {"name":"bill","age":"28","from":"England"}'
返回结果:
{ "_index" : "apple", "_type" : "emp", "_id" : "2", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 1, "_primary_term" : 1 }
#插入数据 Cindy
curl -H "Content-Type: application/json" -XPUT 'localhost:9200/apple/emp/3?pretty' -d' {"name":"Cindy","age":"38","from":"France"}'
返回结果:
{ "_index" : "apple", "_type" : "emp", "_id" : "3", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 2, "_primary_term" : 1 }
#插入数据 Douglas
curl -H "Content-Type: application/json" -XPUT 'localhost:9200/apple/emp/4?pretty' -d' {"name":"Douglas","age":"48","from":"USA"}'
返回结果:
{ "_index" : "apple", "_type" : "emp", "_id" : "4", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 3, "_primary_term" : 1 }
#查询全体
curl -H "Content-Type: application/json" -XGET 'localhost:9200/apple/emp/_search?pretty' -d' {"query":{"match_all":{}}}'
返回结果:
{ "took" : 523, "timed_out" : false, "_shards" : { "total" : 1, "successful" : 1, "skipped" : 0, "failed" : 0 }, "hits" : { "total" : { "value" : 4, "relation" : "eq" }, "max_score" : 1.0, "hits" : [ { "_index" : "apple", "_type" : "emp", "_id" : "1", "_score" : 1.0, "_source" : { "name" : "andy", "age" : "18", "from" : "China" } }, { "_index" : "apple", "_type" : "emp", "_id" : "2", "_score" : 1.0, "_source" : { "name" : "bill", "age" : "28", "from" : "England" } }, { "_index" : "apple", "_type" : "emp", "_id" : "3", "_score" : 1.0, "_source" : { "name" : "Cindy", "age" : "38", "from" : "France" } }, { "_index" : "apple", "_type" : "emp", "_id" : "4", "_score" : 1.0, "_source" : { "name" : "Douglas", "age" : "48", "from" : "USA" } } ] } }
三.设置对name进行优化
#优化emp的name字段
curl -X PUT "localhost:9200/apple/_mapping?pretty" -H 'Content-Type: application/json' -d' { "properties": { "name": { "type": "text", "fielddata": true } } } '
返回结果:
{ "acknowledged" : true }
四.将查询结果按name升序输出
#按name升序查询全体
curl -H "Content-Type: application/json" -XGET 'localhost:9200/apple/emp/_search?pretty' -d' { "query":{"match_all":{} }, "sort":[{"name":{"order":"asc"}}] }'
返回结果:
{ "took" : 5, "timed_out" : false, "_shards" : { "total" : 1, "successful" : 1, "skipped" : 0, "failed" : 0 }, "hits" : { "total" : { "value" : 4, "relation" : "eq" }, "max_score" : null, "hits" : [ { "_index" : "apple", "_type" : "emp", "_id" : "1", "_score" : null, "_source" : { "name" : "andy", "age" : "18", "from" : "China" }, "sort" : [ "andy" ] }, { "_index" : "apple", "_type" : "emp", "_id" : "2", "_score" : null, "_source" : { "name" : "bill", "age" : "28", "from" : "England" }, "sort" : [ "bill" ] }, { "_index" : "apple", "_type" : "emp", "_id" : "3", "_score" : null, "_source" : { "name" : "Cindy", "age" : "38", "from" : "France" }, "sort" : [ "cindy" ] }, { "_index" : "apple", "_type" : "emp", "_id" : "4", "_score" : null, "_source" : { "name" : "Douglas", "age" : "48", "from" : "USA" }, "sort" : [ "douglas" ] } ] } }
END