2,422 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
26
views
How to order output by which columns match?
I'm currently struggling to change the way Sphinx searches are order. The table in question has three columns: title, type (1, 2 or 3) and content. the current query we use is:
select *
from tablename
...
1
vote
0
answers
80
views
Sphinx 3.7 search prioritising proximity and exact matches
I'm trying to prioritize search results in Sphinx Search based on two main factors:
Proximity of matches to the start of a field or document
Exact matches (higher weight for exact matches)
I'm using ...
0
votes
1
answer
23
views
FlyingSphinx::Error: BLOCKED: Single-index processing is not permitted for your plan level
I Have error,
FlyingSphinx::Error: BLOCKED: Single-index processing is not permitted for your plan level,
Stack:
heroku 22
"Flying Sphinx": Wooden
Rails 6
Sphinx
Flying Sphinx
Delayed Job ( ...
0
votes
1
answer
57
views
SphinxSearch ranking
I have 5 fields across 3 tables in my database and I am trying to use SphinxSearch to make a search in those fields. I am trying to achieve this - for example I have three words to make a search word1,...
1
vote
0
answers
68
views
What are the restrictions on the number of records for real time manticoresearch indexes?
#1. What are restrictions on the number of records for real time manticoresearch indexes?
#2. What problems can arise with >300kk records?
#3. How will manticore feel when writing to an index with ...
0
votes
1
answer
60
views
SphinxQL MATCH with or operator
I'm running this query
SELECT * FROM stockcategories_fr WHERE MATCH('@mycolumn ^t-shirt|^tee-shirt|^ tee-shirt|^ t-shirt');
It returns results :
T-shirts
T-shirts enfant
...
But if I run this query
...
0
votes
1
answer
102
views
Why is the text field from the real-time index blank when querying in manticoresearch?
There is the following config of manticoresearch:
searchd {
listen = 9312
listen = 9306:mysql
listen = 9308:http
log = /var/log/manticore/searchd.log
query_log = /var/log/manticore/...
0
votes
1
answer
39
views
Compare groups in Sphinx
This example not working in Sphinx with HAVING. I get syntax error.
Please explain me, how can I compare groups correctly?
SELECT someId from rt_index
GROUP BY someId
HAVING MIN(someId) != MAX(someId)...
0
votes
1
answer
250
views
How to use Manticore Regex using sphinxapi
I am using sphinxapi adding queries using addQuery() but It does add everything inside MATCH("...") and in Manticore there is Regex functionality apart from Sphinx. Do you know how to use ...
0
votes
0
answers
28
views
Sphinx search: wordforms result
There is a table with products.
select * from mytbl where match('Rennie ');
id
name
1
Rennie with menthol flavor tablet 24
2
Rennie Sugar Free tablet 24
3
Rennie with orange tablet 24
My wordforms is:
...
0
votes
1
answer
31
views
Sphinx query index: exclude rows containig particular value
I have a Sphinx index with the following columns
id
article_id
country_id
1
1
1
2
1
2
3
1
3
4
2
2
5
2
3
6
3
4
7
4
1
8
4
2
9
5
1
I need to get article_ids which don't contain country_id = 1 at all ...
0
votes
0
answers
52
views
Why does sphinx 3.4.1 return zeros when creating a query via SetSelect()
I am using sphinx 3.4.1 and php 7.4.
I have a sql_attr_multi field
and when I filter its data through setFilterRange(), the data is returned correct
However, if I do this via setSelect(), for example
$...
1
vote
0
answers
55
views
Django MySql backend errors when getting features from Sphinxsearch
Django MySql backend tries to evaluate MySql settings every time it uses a connection and cannot convert an empty string, that is being returned to an integer.
When it does so it throws an error as ...
0
votes
0
answers
250
views
Sphinx Results Take Huge Time To Show (Slow Index)
I'm new to Sphinx, i have simple table tbl_urls with two columns (domain_id,url)
i created my index as below to get domain id and number of urls for any giving keyword
source src2
{
type ...
0
votes
0
answers
380
views
spinxsql combine match and filter
I use Manticore Search. Fork of Spinx.
I'am trying to use Full text search. But problem in json fields. So I fond solutions via ANY()
ANY(client_user.login = "test" FOR client_user IN ...