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
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.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.