Union query

Hi can i do this query in elasticsearch? My elasticsearch is last version. Thank you.

    (SELECT * FROM images where file_id = 0)

UNION

(SELECT * FROM images where file_id > 0 Group by image_path,file_id)

LIMIT 20,20

Union queries are not supported currently by ES-SQL.
There is an open issue to track this feature.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.