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…
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…
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', …
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