es做分页查询的时候,我设置的每页显示10条数据,如果我查询出来的数据小于10条,返回的数据为什么会是空数据呢
yayg2008 回复了问题 • 3 人关注 • 2 个回复 • 6215 次浏览 • 2018-06-22 09:48
无法启动 es6.3.0
sun_changlong 回复了问题 • 3 人关注 • 2 个回复 • 2976 次浏览 • 2018-10-17 16:36
找出有两个号码以上的人-查询语法如何写?
laoyang360 回复了问题 • 2 人关注 • 1 个回复 • 2396 次浏览 • 2018-06-20 23:25
es搜索引擎安装了xpack。现在es做集群,head现在都连接不上。
Buddha 回复了问题 • 4 人关注 • 4 个回复 • 5635 次浏览 • 2018-06-25 14:56
使用Java初始化TransportClient时,log4j报java.lang.NoSuchMethodError错误
回复匿名用户 发起了问题 • 1 人关注 • 0 个回复 • 8669 次浏览 • 2018-06-20 15:37
es集群下,kibana只有一个节点能登录
Yi 回复了问题 • 5 人关注 • 5 个回复 • 6335 次浏览 • 2020-01-16 11:57
如何在ES中找到某字段首次出现的值?
laoyang360 回复了问题 • 3 人关注 • 1 个回复 • 1822 次浏览 • 2018-06-19 22:16
请问ES如何同时按照日期(年月日)及时间(时分秒)两个范围来查询(过滤)?
laoyang360 回复了问题 • 4 人关注 • 3 个回复 • 11454 次浏览 • 2018-06-24 14:58
有老铁测试了es6.3.0的sql功能吗?
feloxx 发表了文章 • 16 个评论 • 6335 次浏览 • 2018-06-19 16:26
执行的时候老出现如下错误,有老铁遇到过吗?
我是这么来启动的
./elasticsearch-sql-cli http://127.0.0.1:9200
sql> show tables;
name | type
----------------+---------------
hello |BASE TABLE
sql> select * from hello;
Server error [Server encountered an error [Cannot extract value [deliveraddress.address] from source]. [SqlIllegalArgumentException[Cannot extract value [deliveraddress.address] from source]
at org.elasticsearch.xpack.sql.execution.search.extractor.FieldHitExtractor.extractFromSource(FieldHitExtractor.java:139)
at org.elasticsearch.xpack.sql.execution.search.extractor.FieldHitExtractor.extract(FieldHitExtractor.java:95)
at org.elasticsearch.xpack.sql.execution.search.SearchHitRowSet.getColumn(SearchHitRowSet.java:114)
at org.elasticsearch.xpack.sql.session.AbstractRowSet.column(AbstractRowSet.java:18)
这是测试数据的mapping
{
"test2": {
"properties": {
"deliveraddress": {
"properties": {
"phone_no": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"default": {
"type": "boolean"
},
"address": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"province": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"city": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"mapping_id": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"name": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"full_address": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"zip_code": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
}
}
},
"alipaywealth": {
"properties": {
"balance": {
"type": "long"
},
"total_quotient": {
"type": "long"
},
"huabei_creditamount": {
"type": "long"
},
"mapping_id": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
},
"huabei_totalcreditamount": {
"type": "long"
},
"total_profit": {
"type": "long"
}
}
},
"id": {
"type": "text",
"fields": {
"keyword": {
"ignore_above": 256,
"type": "keyword"
}
}
}
}
}
}
这是测试数据
{
"_id": "5b1cbc7935eb6e0007a154bb",
"deliveraddress": [
{
"phone_no": "13*******98",
"default": true,
"address": "江苏省无asdads市徐***镇",
"province": "江苏",
"city": "无锡",
"mapping_id": "3561511087asdasd341",
"name": "b***",
"full_address": "湖asd***上7号",
"zip_code": "214400"
},
{
"phone_no": "15*******70",
"default": false,
"address": "江苏省苏州asdasdasd张家港经济技术开发区",
"province": "江苏",
"city": "苏州",
"mapping_id": "3561511asdasd505341",
"name": "a**",
"full_address": "新asd路***德***",
"zip_code": "215600"
}
],
"alipaywealth": {
"balance": 0,
"total_quotient": 0,
"huabei_creditamount": 500,
"mapping_id": "3561511asdsa63505341",
"huabei_totalcreditamount": 500,
"total_profit": 0
}
}
---
初步怀疑是不是不支持嵌套,数组啥的呀
然后我就翻了翻源码,发现了这个
我的错误就是在最后一个else里出现的
仔细一看,发现这个地方循环只要走了两次,或者前面的条件不成立就肯定会抛这个异常,这怎么看上去像是有点问题呢
@SuppressWarnings("unchecked")
Object extractFromSource(Map<String, Object> map) {
Object value = map;
boolean first = true;
// each node is a key inside the map
for (String node : path) {
if (value == null) {
return null;
} else if (first || value instanceof Map) {
first = false;
value = ((Map<String, Object>) value).get(node);
} else {
throw new SqlIllegalArgumentException("Cannot extract value [{}] from source", fieldName);
}
}
return unwrapMultiValue(value);
}
es启动报:unknown setting [network.hosts] 不知是哪里配置的问题,求助
kepmoving 回复了问题 • 2 人关注 • 1 个回复 • 2478 次浏览 • 2018-06-19 15:59
请问elasticsearch-analysis-pinyin插件有没有
回复weizhuang 发起了问题 • 2 人关注 • 0 个回复 • 2008 次浏览 • 2018-06-19 12:05