a SQL dialect that enables Sphinx search functionality in a standard SQL syntax.
Questions tagged [sphinxql]
120 questions
1
vote
0 answers
Sphinxsearch - how do I find items with the most similar tags?
I have a posts index with MVA tag, config similar to the following:
source posts {
sql_query = SELECT id, title, text FROM posts;
sql_attr_multi = uint tag from query; SELECT postid, tagid FROM tagstoposts
}
Now for a given post I…
Fluffy
- 27,504
- 41
- 151
- 234
1
vote
0 answers
in SphinxQL get largest matching value from JSON MVA field
With SphinxQL, I would like to sort the results by a JSON MVA property that has a filter criteria associated with it.
For example, I have an Index that contains:
event_id,
tickets
where tickets is a JSON array…
Darrin
- 46
- 4
1
vote
1 answer
SphinxQL query builder - how to add multiple and/or operators to match
this is my query:
$query = SphinxQL::create($conn)->select('*')
->from('my_index')
->match('name', 'bird + monkey', true);
$result = $query->execute();
adding + or || between values works (giving results that match 'bird' and/or…
AnatPort
- 748
- 8
- 20
1
vote
2 answers
SphinxQL: How to SUM() custom field with GROUP BY or RANK results by custom field
I have an index with next structure:
+----+-----------+---------+--------------+
| id | entity_id | content | weight_field |
+----+-----------+---------+--------------+
| 1 | 1 | car | 1.2 …
Stafox
- 1,007
- 14
- 25
1
vote
1 answer
Beginner: about Sphinx & SphinxQL
I have manage to configure, indexed and run sphinx and now I am using SphinxQL to retrieve some data.
Problem is, when I try to query, the result only gives me the "id".
This what confuses me.
My data on mySQL composes of the following…
Roi
- 503
- 1
- 12
- 25
1
vote
1 answer
How to get global variable in sphinx search
How to get global variable in sphinx search which I have set it custom like
SET GLOBAL @test = (1,2,3)
SHOW GLOBAL VARIABLES
returns
+----------------------+---------+
| Variable_name | Value |
+----------------------+---------+
|…
Aramayis Mkrtchyan
- 339
- 3
- 12
1
vote
1 answer
Sphinxql Replace() function like mysql
i can able to find search on mysql such as example below;
Record is : I'Histoire
Query search :IHistoire
with this sql query i can able find word with '…
x0r
- 50
- 7
1
vote
1 answer
Sphinx match by first letter
I need simple explanation of why my queries fail to bring the results i need.
Sphinx 2.0.8-id64-release (r3831)
Here is what i have in sphinx.conf:
SELECT
trackid,
title,
artistname,
SUBSTRING(REPLACE(TRIM(`artist_name`), 'the ', ''),1,3) AS…
Papa Zhi
- 45
- 1
- 11
1
vote
1 answer
Sphinx PHP library returns different results from the Sphinx MySQL interfance
If i run the 2 peices of code to get Sphinx results:
One in PHP:
$host = \Config::get('sphinxsearch::host');
$port = \Config::get('sphinxsearch::port');
$s = new \Sphinx\SphinxClient();
$s->setServer($host, $port);
$sql = "SELECT * FROM essays,posts…
kjones1876
- 762
- 2
- 10
- 17
1
vote
1 answer
Sphinx sql_query_killlist is ignored
I'm trying to get main index sql_query_killlist to work, but no matter what I do, deleted documents are still appear is SphinxQL results. My sphinx version is 2.0.4.
Part of the sphinx.conf file:
source torrents
{
type = mysql
…
artyomboyko
- 2,781
- 5
- 40
- 54
1
vote
1 answer
Sphinx ranking mode not working
I'm using sphinx 2.1.4
I'm searching with sphinx with following methods,
First::
Using sphinxql through PDO in php using this query
SELECT * FROM $indexes WHERE MATCH(:match) LIMIT 0,10 OPTION ranker=bm25
Now when I do the same thing with…
Tarun Chabarwal
- 332
- 4
- 15
1
vote
1 answer
SphinxQL query does not return all matches
I am usign SphinxQL to query Sphinx RT indexes. Found that queries return 20 matches at most (20 seems to be a default value).
Tried adding options the SELECT query to change that limit to 1000:
SELECT [...] OPTION cutoff = 1000, max_matches =…
German Latorre
- 10,058
- 14
- 48
- 59
1
vote
1 answer
sphinx Lost connection to MySQL server during query
I'm tyring to convert plain indices to real time by running the following query
ATTACH INDEX comment TO RTINDEX comment_rt;
But when I run it in sphinxql it gives me the following error:
WARNING: sql_query_post[0]: error=Lost connection to MySQL…
Pendar
- 71
- 8
1
vote
1 answer
SphinxQL Data too long for column
I'm inserting data into a Sphinx RT index using SphinxQL, which is working fine. Just occasionally I get really large values in my dataset and I get the following error:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column…
Colin Pickard
- 45,724
- 13
- 98
- 148
0
votes
0 answers
SphinxQL / Sphinx Search: Query to find rows where columns are equal (category1 = category2)?
SphinxSearch: 3.3.1
Ubuntu 22.04
PHP 8.1.12
I am trying to use SphinxQL with PHP to find rows where two different categories match, such as:
$db = new PDO('mysql:host=127.0.0.1;port=9306', '', '');
$sql = "SELECT id FROM index,delta,rtindex WHERE…
peppy
- 173
- 2
- 17