可以实现这类嵌套查询吗

[jecyyu]

需要满足的语句是： select from ( select media,province,age,sex,count()as counts from mahad where sex in ('02401') GROUP BY media,province,age,sex)

[yangsishu]

嵌套子查询现在好像不支持

[shi-yuan]

As far as I know, elasticsearch doesn't support subqueries. you would need to perform your first query, then construct a second query using the results of the first query as an input

[treecy]

@shi-yuan Sorry, but could I ask how to use the results as an input? Like temporary table or something?

[shi-yuan]

SELECT * FROM test/dog WHERE holdersName IN (SELECT firstname FROM test/account WHERE firstname = 'Hattie') AND age IN (SELECT name.ofHisName FROM test/gotCharacters WHERE name.firstname <> 'Daenerys') 

[treecy]

@shi-yuan Thanks a lot! If I want to do something like:

select sum(gms), A
from (
    select max(gms) as gms, A, B
    from test
    group by A, B
)
group by A

Is there any way possible?

[treecy]

I resolved this one by Pipeline aggregations. @shi-yuan Thank you all the same 😀 Hope you can implement this feature.

[dick318]

@treecy select sum(gms), A from ( select max(gms) as gms, A, B from test group by A, B ) group by A 你举的例子中，用Pipeline aggregations怎么写的 能提供下吗

[JamesZhan107]

@treecy May I ask how to do this： select count(*) cnt from (select a0.name from worker a0) ttt