Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

union 两个count查询时报错 #1230

Open
AqooDer opened this issue Oct 17, 2023 · 3 comments
Open

union 两个count查询时报错 #1230

AqooDer opened this issue Oct 17, 2023 · 3 comments
Assignees
Labels

Comments

@AqooDer
Copy link

AqooDer commented Oct 17, 2023

sql:select count() as totle from user where state in(1,8) union select count() as totle from user where state in(2,3,4)
报错信息:Caused by: java.lang.NullPointerException
at org.nlpcn.es4sql.Util.clearEmptyPaths(Util.java:222)
at org.elasticsearch.plugin.nlpcn.UnionExecutor.updateFieldNamesToAlias(UnionExecutor.java:90)
at org.elasticsearch.plugin.nlpcn.UnionExecutor.fillInternalSearchHits(UnionExecutor.java:55)
at org.elasticsearch.plugin.nlpcn.UnionExecutor.run(UnionExecutor.java:40)
at org.elasticsearch.plugin.nlpcn.QueryActionElasticExecutor.executeMultiQueryAction(QueryActionElasticExecutor.java:78)
at org.elasticsearch.plugin.nlpcn.QueryActionElasticExecutor.executeAnyAction(QueryActionElasticExecutor.java:90)

@shi-yuan
Copy link
Member

shi-yuan commented Jan 1, 2024

count(*)再union,目前是不支持的

@AqooDer
Copy link
Author

AqooDer commented Jan 15, 2024

这个会考虑去实现么?

@shi-yuan shi-yuan added the bug label Feb 25, 2024
@shi-yuan shi-yuan self-assigned this Feb 25, 2024
@shi-yuan
Copy link
Member

后期会修复的

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants