Starting to ramp up using Percolate queries for the first time, and noticed an inconsistency.
You define all the fields (and attributes) in the percolate index in the .conf file,
But then when run a ‘DESCRIBE’ on the index just get the ‘id’, ‘query’, ‘tags’, ‘filters’ columns, in many ways this makes sense, as that is surely what the PQ index must contain. It a list of queries.
sphinxQL>describe pq1;
+---------+--------+------------+
| Field | Type | Properties |
+---------+--------+------------+
| id | bigint | |
| query | string | |
| tags | string | |
| filters | string | |
+---------+--------+------------+
4 rows in set (0.00 sec)
The same columns get from CALL PQ (if 1 as query anyway!)
i think the right examples are already in the docs as describe show general schema for index and for all pq index the schema is the same but desc table shows internal schema that could vary for different pq indexes.
And we also will release new documentation with new structure and this will be achieved not sure it is worth to change current documentation
Ah ok thanks! Not sure how to find it tho
Had tried searches like ‘Percolate schema’ and ‘Percolate desc’ / ‘Percolate describe’
Even just ‘describe pq table’ just finds a reference in changelog ( Asuming I now what it called). Not the actual syntax.
Oh, just found it now in the results for ‘percolate index’
And turns out it is in the general DESCRIBE section https://manual.manticoresearch.com/Listing_indexes#DESCRIBE
just that it listed UNDER heading about SHOW CREATE, so looks like it already moved on from ‘DESCRIBE’ - so wouldnt think to continue scrolling, once the subject changed to something else.