Apache Solr is an open source search server based on the Lucene Java search library.
Questions tagged [solr]
11 questions
4
votes
2 answers
How we can do full text search and facets stuffs on BigQuery?
In the future, we will have millions ofs record in our web product. So we had used BigQuery for data storage and analysis. We have to build filters on our search page like Flipkart and Amazon provide product filters.
Basically, we need different…
Lalit Kumar Maurya
- 143
- 1
- 6
2
votes
0 answers
List solr replica properties
I'm looking for a way to list all properties on a replica.
I checked this page: https://lucene.apache.org/solr/guide/7_6/collections-api.html
But no such thing is mentioned there. Only adding, editing or deleting existing properties, but no way of…
KdgDev
- 211
- 4
- 12
2
votes
2 answers
SQL performances of selecting recently modified records Solr
I have a SQL Server 2916 database, and Solr.
The Solr indexer runs often such queries:
select book_collection from books group by book_collection having max(updated_on) > '2017-04-04 09:50:05'
The column updated_on is updated by a trigger on…
carlo.borreo
- 1,477
- 6
- 22
- 37
2
votes
1 answer
DSE Cassandra decimal type
I generated solrschema with dsetool on a table name seriesdata (its key is composed by seriesmetadata_id, initialtime; two decimal field).
These fields are defined as DecimalStrField but they are numeric valued (I have to execute range selection). I…
afmulone
- 65
- 4
2
votes
0 answers
Solr with SQL Server or NoSQL
I am working on a POC of using Solr with SQL Server.
I have a very complex data model with SQL server which required a bunch of joining and scalar functions to strip some mark up and other stuff.
This is turning out to be performance bottleneck. To…
HaBo
- 191
- 1
- 3
- 10
1
vote
2 answers
SQL Server vs SOLR (Or any document db)
I have my "customer" data in a normalized sql server database.
Getting out the customer data in my app is taking too long. This is because I have to go to 10+ tables to get all the data I need.
My company has an installation of SOLR that I thought…
Vaccano
- 2,550
- 5
- 31
- 56
1
vote
0 answers
Where do custom Solr schemas go in Riak?
I have checked these two pages in the Riak docs http://docs.basho.com/riak/kv/2.2.0/developing/usage/search/ http://docs.basho.com/riak/kv/2.2.0/developing/usage/search-schemas/
and they tell how to make a custom schema and how to attach it to an…
AndrewK
- 11
- 1
0
votes
1 answer
Database / Search-Index recommendation: Match time ranges from different categories
300k+ videos
10+ millions of markers, pointing to timeranges in videos
{
"markerCategory": "something",
"markerDesc": "something-more-specific",
"frameIn": 120001,
"frameOut": 140002
},
{
"markerCategory": "something-else",
…
gherkins
- 103
- 2
0
votes
1 answer
WCS8 Solr Preprocess failed : Error SQLCODE=-601, SQLSTATE=42710, SQLERRMC=WCSSTGAP.XI_CATENTRY_PRICE_0
Our Solr Pro-process is failing with below error:
[2018/08/28 14:31:36:104 CDT] 00000001 W
com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor:createDBTable(Connection,
String, String) create XI_CATENTRY_PRICE_0 with…
Prardhan
- 1
- 2
-1
votes
1 answer
Indexing system vs raw DMBS connection
I have created a new dataset that has 11,000,000+ rows with 4 pivot tables in MySQL. The tables are not that deep, only 6 - 12 cols per.
My question is I've set up the Lucene Apache SOLR to index the data, and it work's great for searching .. BUT
I…
Zak
- 113
- 5