Questions tagged [ft.search]
6 questions
2
votes
1 answer
SQL IN Operator in Redis by FT.Search/FT.Aggregate
I have a query that I need to translate from sql to redis.
here is an example of this request
id IN(1,2,4,6)
My schema look's like this:
FT.CREATE log // Index name
ON HASH // Indicates the type of data to index
PREFIX 1…

Andrew RutRud
- 35
- 5
1
vote
1 answer
Redis query with wildcard for Hash
I have redis hashes as below.
HSET post:33 postId 33 title "Sumit Title 33"
HSET post:334 postId 334 title "Sumit Title 334"
HSET post:334 postId 22 title "Sumit Title 22"
It had an index like below -
FT.CREATE idx ON HASH PREFIX 1 "post:" SCHEMA…

Sumit Chakraborty
- 17
- 3
1
vote
1 answer
SQL JOIN in Redis(FT module or other solutions)
I want to transfer part of the SQL queries to redis and ran into a problem that redis does not have an analogue of the JOIN functionality
Example in SQL.
Got 2 tables:
CREATE TABLE `games` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
…

Andrew RutRud
- 35
- 5
0
votes
0 answers
Redis: ft.search people-idx returns 1) (integer) 0
I want to make a people index in Redis, containing all values from table a css table.
I imported the following CSV…

Imme
- 15
- 4
0
votes
1 answer
RediSearch search results difference
I use Redis together with the modules RedisJSON and RediSearch.
I have a question about the RediSearch module especially the FT.SEARCH.
My Index looks like this:
FT.CREATE chainIdIdx ON JSON PREFIX 1 chain-id. SCHEMA…

limdan
- 3
- 1
0
votes
0 answers
REDIS-STACK FT SEARCH with hypen as special character not working
I am implementing redis stack search in which my keys has some special character ,
Below is java code for creating schema of the index:
Client client = new Client("my_queue", "localhost", 6379,10000,100,"mypassword");
Schema sc = new Schema()
…

Feroz Siddiqui
- 3,840
- 6
- 34
- 69