Sorted query?
GET /myIndex/_search
{
"query":{"match_all": {}},
"fields":["myDate","col1"],
"sort": [
{
"myDate": {
"order": "desc"
}
}
]
}
On Thursday, January 15, 2015 at 1:05:22 PM UTC, Lokesh Gupta wrote:
>
> Thanks.. Any other creative solutions?
>
> On Thursday, January 15, 2015 at 1:54:10 PM UTC+5:30, David Pilato wrote:
>>
>> I think you need to run two queries for now. One is an aggregation (max).
>> The other one use the result of this aggregation to search for documents.
>>
>> My 2 cents
>>
>> --
>> *David Pilato* | *Technical Advocate* | *Elasticsearch.com
>> <http://Elasticsearch.com>*
>> @dadoonet <https://twitter.com/dadoonet> | @elasticsearchfr
>> <https://twitter.com/elasticsearchfr> | @scrutmydocs
>> <https://twitter.com/scrutmydocs>
>>
>>
>>
>> Le 15 janv. 2015 à 09:13, Lokesh Gupta <[email protected]> a écrit :
>>
>> What will be equivalent of the following query in the Elasticsearch
>> world..
>>
>> select myDate, col1, col2 from myTable
>> where myDate = (select max(myDate) from myTable)
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "elasticsearch" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/elasticsearch/cee4d390-a53c-4c11-ae4b-4d40023ca889%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/elasticsearch/cee4d390-a53c-4c11-ae4b-4d40023ca889%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/8dffc8cf-8dee-4584-8fac-119482ea0831%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
