Questions tagged [range-query]
95 questions
0
votes
0 answers
Query Range in a google sheet dynamically
I have a chart developed from google app script that references a spreadsheet.
My Data source looks like this
It has blank cells in between representing the holiday period when no recording is done. The source sheet grows daily by 1 row.…
Sai Ram
- 43
- 1
- 9
0
votes
1 answer
Date range query with Lucene 7
In the old Lucene version, building date range query was easy:
query = NumericRangeQuery.newLongRange(name, startDate(null if not), endDate(null if not), includeStart, includeEnd);
I switched to Lucene 7 (lucene-core 7.3.1) and I cannot find a…
gospodin
- 1,133
- 4
- 22
- 42
0
votes
1 answer
Algorithms for range query on streams of integers
I'm getting a stream of positive integers to my program. I've to store them as I receive them and be able to answer to range queries that come in between.
A simple solution that came to my mind is to store integers in a hashtable where keys are…
SpiderRico
- 1,890
- 8
- 28
- 48
0
votes
1 answer
Lucene String and Numeric range queries
I'm just curious why Lucene doesn't distinguish string and numeric values in a standard way.. for example ['2' TO '6'] and [2 TO 6] for range queries and treat all of them by default as String.
Is there any particular reason to treat both of these…
alexanoid
- 24,051
- 54
- 210
- 410
0
votes
1 answer
Lucene query language and numeric range
I'm applying the following Lucene query predicate in order to get all inclusive numbers in 2 to 6 range:
value:[2 TO 6]
and receive the documents with the following…
alexanoid
- 24,051
- 54
- 210
- 410
0
votes
1 answer
Elastichsearch range query does not work with icu_collation for Turkish words
I've document which has Turkish words like "şa, za, sb, şc, sd, şe" etc. as customer_address property.
I've indexed my documents as documented below because I want to order documents according to the customer_address field. Sorting is working…
gul.cabuk
- 1
- 4
0
votes
2 answers
Range Query: Maximum element more than X and less than Y present in the index range [l : r] in array A
You are given an array A of positive integers and some queries.
In each query, you are given positive integers X, Y, l and r.
For each query, you are to find the maximum element in range [l : r] of array A, which is more than X and less than Y. If…
Sushil Verma
- 659
- 9
- 23
0
votes
1 answer
A Range Search Query is causing Garbage Collection in Elastic Search
I have an Elastic Search 5.2 cluster with 16 nodes (13 data nodes/3 master/24 GB RAM/12 GB Heap). I am performance testing a query and making 50 calls of a search query per second on the Elastic cluster. My query looks like the following -
{
…
sgsi
- 382
- 1
- 8
- 18
0
votes
1 answer
numbers not divisible by all array elements
Given an array of 3 elements :- 2,4,5
and given a number n = 10
Find count of all numbers in the range 1 to n which are not dvisible by multiple of all array elements.
output:- 4
(1,3,7,9)
Any better approach brute force?
n is in the range of 1 to…
user8569142
0
votes
0 answers
Solr numeric rangeQuery returns only partial results
I've implemented Solr and I am attempting to range query on a field and I am getting only half the expected results. Anyone have any ideas as to what might be going on here?
example:
myData = {
item1: {
my_field: 98
},
item2: {
…
user1325159
- 187
- 1
- 9
0
votes
1 answer
Elasticsearch range query on list of object
here my mapping
{ "seoSubscribedFlag": {"type": "boolean"},
"seoSubscribedExpiryDate": {"type": "date"},
"userActive" :{"type" : "boolean"},
"emailVerified" :{"type" : "boolean"},
…
Amar Gohil
- 163
- 2
- 12
0
votes
1 answer
Nested search query in Elasticsearch with range filter and unknown names of inner fields
I am storing data in elasticsearch database and am trying to query it, filtered by range of numbers.
This is minimized structure of a document in my database:
"a": {
"b": {
"x": [1, 2, 3, 4], // note: x, y and z are not compulsory
…
patriciasmh
- 350
- 2
- 4
- 14
0
votes
1 answer
Umbraco Examine - Querying Integers not Working
I'm using Umbraco v.7.6.1 with Examine v0.1.82 (Lucene 2.9.4.1). I have a list of vehicles and a search form to query different types of fields, including Price. The Price field is a Numeric data field and in the ExamineIndex is defined as:
Raquel Fialho
- 1
- 1
0
votes
1 answer
Range Query not returning results in Elasticsearch
I am trying to fetch the following section of a document i have indexed through elasticsearch:
temporal: {
begin: "2016-11-30T00:00:00",
end: "2016-12-08T13:55:02"
},
The query that i am using on CURL as i am currently just testing the queries on…
Rehan
- 371
- 1
- 6
- 29
0
votes
0 answers
How fast would this Firebase range query be
I wonder about search in Firebase database and try to understand if this is a good approche or how to change it. the "andromeda-planetgroup.123-local1001-1234548" below is an immutable id string and I would like to perform searches on the list…
Tord Larsen
- 2,670
- 8
- 33
- 76