有老铁测试了es6.3.0的sql功能吗?
feloxx 发表了文章 • 16 个评论 • 6502 次浏览 • 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 个回复 • 2575 次浏览 • 2018-06-19 15:59
请问elasticsearch-analysis-pinyin插件有没有
回复weizhuang 发起了问题 • 2 人关注 • 0 个回复 • 2081 次浏览 • 2018-06-19 12:05
es创建了索引和类型之后能不能添加新的类型
laoyang360 回复了问题 • 2 人关注 • 1 个回复 • 3356 次浏览 • 2018-06-18 22:56
elasticsearch-analysis-pinyin可以用于繁体字吗？谢谢
回复weizhuang 发起了问题 • 2 人关注 • 0 个回复 • 2690 次浏览 • 2018-06-17 12:18
关于拼音搜索，像我们这种情况怎样设计比较合理？
laoyang360 回复了问题 • 5 人关注 • 1 个回复 • 2651 次浏览 • 2018-06-18 23:08
elasticsearch 分词后，还可以保留大写吗
rockybean 回复了问题 • 3 人关注 • 1 个回复 • 1657 次浏览 • 2018-06-17 08:01
Elasticsearch 之 Term Vectors
superman 回复了问题 • 2 人关注 • 1 个回复 • 1688 次浏览 • 2018-06-19 10:54
elasticsearch升级带来的问题java api使用的问题，请牛人指教
401825317 回复了问题 • 3 人关注 • 2 个回复 • 4792 次浏览 • 2019-12-11 11:19
scroll查询 设置滚动时间长短问题
pony_maggie 回复了问题 • 3 人关注 • 2 个回复 • 9341 次浏览 • 2020-07-27 14:35
elasticsearch分析器
laoyang360 回复了问题 • 3 人关注 • 2 个回复 • 2377 次浏览 • 2018-07-02 08:12
有没有了解elasticsearch的，我们需要一个人做技术支持，待遇优厚
回复heyajun 发起了问题 • 1 人关注 • 0 个回复 • 2348 次浏览 • 2018-06-15 16:55
