elasticsql

elasticsql copied to clipboard

nest

3

hswuhao

sql translate 咨询

1

请问一下 opendistro的_sql/_translate 您了解吗？我实验sql转换为dsl失败了

JackrayWang

支持这种子查询吗？

1

select count(DISTINCT deviceId) from uv where deviceId in (select deviceId from uv where userId = 'unknown') and uv.userId != 'unknown';

dingzhjie

Multiple Group by errors

3

sql like : select count(id) from A where A.id > 5 group by A.a, A.b; because of `innerMap["terms"] = msi{ "field": colName.Name.String(), "size": 0, }` will gen the dsl like:...

vitaneyeyu

convert error : nend convert select sql fields to json fields like `"_source":["title", "price"]`

2

original SQL : ``` sql select title, price from products where title = '%A%' ``` expect like that : ``` json { "_source": [ "title", "price", ], "query": { "bool":...

gudigudi

不支持bigint 值比较

1

bigint 自动转成字符串了， 拿进去查询，查出来的结果是错的

tx991020

cch123

current: ``` select * from a where id = missing ``` the expected: ``` select * from a where missing(id) = true ```

cch123

cch123

Does this library have the capability to perform a conversion from DSL to SQL?

1

Does this library have the capability to perform a conversion from DSL to SQL?

qaqrt