a SQL dialect that enables Sphinx search functionality in a standard SQL syntax.
Questions tagged [sphinxql]
120 questions
0
votes
1 answer
How to use Sphinx search in java
I'm set up Sphinx and indexed my table. It works correctly in the console, but how i can execute this query in java? Is it possible? I guess Intellij Idea doesn't understand SphinxQL.
0
votes
1 answer
Fatal error: Uncaught Error: Class 'Foolz\SphinxQL\Connection' not found
I installed Foolz SphinxQL Query Builder for PHP with composer using the following json file:
{
"require": {
"foolz/sphinxql-query-builder": "^2.0"
}
}
My php is as follows:
Nick Weavers
- 534
- 7
- 23
0
votes
1 answer
REMOVE_REPEATS is not working in SphinxQL
the document said REMOVE_REPEATS ( result_set, column, offset, limit ) - removes repeated adjusted rows with the same 'column' value. but when I run select remove_repeats((select * from rt), gid, 0, 10), The record gid=22 appeared twice.Shouldn't it…
Mario7
- 83
- 1
- 12
0
votes
1 answer
How to use PDO bindParam for SphinxSearch 3?
I have recently installed SphinxSearch 3.1.1 on Ubuntu 18 and am currently creating a snippet of code using PHP 7.2. I am having trouble making bindParam work.
Here is my code:
$mytest = "hello";
$query = $conn->prepare("SELECT *, weight() FROM…
Fica
- 3
- 2
0
votes
1 answer
Find exact word in order in SphinxQL
I'got got an indexed columns that contains some numbers (ids) and I need to extract rows that match exactly some numbers in a given order.
For example
"Give me rows that contains 1 followed by 1 followed by 25 followed by 30"
1 1 1 2 2 25 25 26 30…
alberto-bottarini
- 1,213
- 9
- 21
0
votes
1 answer
Sphinx(Search) - documents which matches keyword twice (thrice, etc.)
Is there a way to only output documents which contains n matches of a search term in it?
F.e. I want to output all documents containing the search term "Pablo Picasso" | "Picasso Pablo" at least two (three, n) times.
How would such a query look…
koseduhemak
- 523
- 2
- 4
- 19
0
votes
1 answer
Wildcard searching between words with CRC mode in Sphinx
I use sphinx with CRC mode and min_infix_length = 1 and I want to use wildcard searching between character of a keyword. Assume I have some data like these in my index files:
name
-------
mickel
mick
mickol
mickil
micknil
nickol
nickal
and when I…
DAVID_ROA
- 309
- 1
- 3
- 18
0
votes
1 answer
Sphinx purge deleted data
What is the best way to purge all old data from the Sphinx indexes? Right now, I issue an OPTIMIZE INDEX command, however this is only adding the job to the queue. Therefore, I thought if I measure the index size before the optimize command, I could…
Thomas van Hesteren
- 123
- 1
- 11
0
votes
0 answers
Sphinx: OR operator in sphinxql
I have a date field (Start_date) in my database that have indexed it in sphinx as sql_field_string and it's format is like: 2000-12-12.
When I want to search on that field I submit a query like this:
select * from all where match ('@Start_date…
DAVID_ROA
- 309
- 1
- 3
- 18
0
votes
1 answer
Sphinx: How to stop a query submitted?
In sphinx, Sometimes there is a situation that a query takes a long time to complete. Is there any way to cancel submitted query or stop it somehow with SphinxQL? (I don't want to kill or stop searchd deamon and just want to kill thread that is…
DAVID_ROA
- 309
- 1
- 3
- 18
0
votes
1 answer
what is a sphinx thread with net_idle state?
I use sphinx search engine and sometimes when I run
show threads;
I see one thread like picture below with "Net_Idle" state among threads that Its "Time" value goes up to 100 seconds and in some cases up to 500 seconds and then automatically…
DAVID_ROA
- 309
- 1
- 3
- 18
0
votes
0 answers
Sphinx: batch query in sphinxQL
I am using sphinx search engine for full text search and I want to send several search queries to searchd deamon in one batch. I know that it's possible in SphinxAPI, but I want to use this feature in SphinxQL.I have read from Sphinx documnetation…
DAVID_ROA
- 309
- 1
- 3
- 18
0
votes
1 answer
SphinxQL connection issue (while daemon is listening)
I'm trying to get my SphinxQL-installation to work on my Ubuntu 16.04LTS environment. However, I can't connect to the server. The configuration I use is below:
searchd
{
listen = 9306:mysql41
log =…
TVA van Hesteren
- 1,031
- 3
- 20
- 47
0
votes
1 answer
How to use two models for single index search in sphinx-django
I'm using django-sphinxql for search requirements in my django project.
I want to use two models in my app for search with some query. Models look as below
Class Model1(models.Model):
name = models.CharField(max_length=50)
model2 =…
Uday Swami
- 395
- 8
- 22
0
votes
1 answer
SphinxQL Error on Show Meta;
As far as I know I can run
Show Meta;
After doing a SphinxQL search to see what Sphinx is actually searching for.
However I keep getting
sphinxql: syntax error, unexpected SUBKEY, expecting $end near '.PROFILING GROUP BY QUERY_ID'
Yet my searches…
user3649739
- 1,829
- 2
- 18
- 28