Does insert order matter for date range queries


(None) #1

Say I insert a few documents that have my own "date" field (NOT the ES
insert stamp) but not inserted in order of that specific date field.

{
...
"DateMoved": "2014-12-31..."
}

{
...
"DateMoved": "2013-12-31..."
}

{
...
"DateMoved": "2014-12-25..."
}

{
...
"DateMoved": "2012-12-25..."
}

{
...
"DateMoved": "2013-12-25..."
}

And so on...

If i wanted to do a range query by DateMoved (For all documents in 2013-12)
would it affect the speed of the query?

I have been testing my query and seems to be running ok. But just double
checking to see there's no caveats.

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/cca69f29-b674-4505-9837-712e86ed59d2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Nik Everett) #2

I don't believe it matters, no.

On Tue, Jul 15, 2014 at 11:47 AM, John Smith java.dev.mtl@gmail.com wrote:

Say I insert a few documents that have my own "date" field (NOT the ES
insert stamp) but not inserted in order of that specific date field.

{
...
"DateMoved": "2014-12-31..."
}

{
...
"DateMoved": "2013-12-31..."
}

{
...
"DateMoved": "2014-12-25..."
}

{
...
"DateMoved": "2012-12-25..."
}

{
...
"DateMoved": "2013-12-25..."
}

And so on...

If i wanted to do a range query by DateMoved (For all documents in
2013-12) would it affect the speed of the query?

I have been testing my query and seems to be running ok. But just double
checking to see there's no caveats.

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/cca69f29-b674-4505-9837-712e86ed59d2%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/cca69f29-b674-4505-9837-712e86ed59d2%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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAPmjWd16%2BjjVCjMJJCZLqaa1E-y2k_gfptHbC0YMwmSVXN3Ezg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(None) #3

Thanks

On Tuesday, 15 July 2014 11:49:56 UTC-4, Nikolas Everett wrote:

I don't believe it matters, no.

On Tue, Jul 15, 2014 at 11:47 AM, John Smith <java.d...@gmail.com
<javascript:>> wrote:

Say I insert a few documents that have my own "date" field (NOT the ES
insert stamp) but not inserted in order of that specific date field.

{
...
"DateMoved": "2014-12-31..."
}

{
...
"DateMoved": "2013-12-31..."
}

{
...
"DateMoved": "2014-12-25..."
}

{
...
"DateMoved": "2012-12-25..."
}

{
...
"DateMoved": "2013-12-25..."
}

And so on...

If i wanted to do a range query by DateMoved (For all documents in
2013-12) would it affect the speed of the query?

I have been testing my query and seems to be running ok. But just double
checking to see there's no caveats.

--
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 elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/cca69f29-b674-4505-9837-712e86ed59d2%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/cca69f29-b674-4505-9837-712e86ed59d2%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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/2c764769-e24e-4134-8c2f-d88333024724%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #4