Azure Redis Enterprise RediSearch results limited to 200 - How to adjust MAXEXPANSIONS?

Hi Daram, Manikanta,

It seems the issue you are facing with the RediSearch module in Azure Redis Enterprise Cache might be related to the MAXEXPANSIONS parameter. Below are the steps to help you resolve this

1.Check MAXEXPANSIONS Parameter:

• Ensure that the MAXEXPANSIONS parameter is set to a value that allows for the desired number of records to be returned. You can adjust this parameter in your RediSearch configuration.
• Example configuration change:

FT.CONFIG SET MAXEXPANSIONS 1000

2.Verify Configuration in RedisInsight:

• If you are unable to view configuration details from the RedisInsight console, you might need to check the configuration directly in your Redis instance using the Redis CLI or API

3.Example Query:

• Ensure that your query syntax is correct and that the MAXEXPANSIONS parameter is set appropriately.

FT.SEARCH index_name "@filendname:keywordname*" MAXEXPANSIONS 1000

I hope this information helps. Please do let us know if you have any further queries.

Thank You @Prasad Chaganti . Here is the problem, we already tried to set the same, and it says unknown command FT.CONFIG .Other commands like FT.SEARCH, FT.AGGREGATE and FT.INFO commands work fine.

I also tried to set the MAXEXPANSIONS along with the search query(FT.SEARCH index_name "@filendname:keywordname*" MAXEXPANSIONS 1000), and here is the issue.

Hi Daram, Manikanta,

Sorry for the inconvenience.

It appears that the FT.CONFIG command has been deprecated in RediSearch version 8.0.0 and can be replaced by the CONFIG GET command when migrating or writing new code. This might be the reason why you are encountering the "unknown command" error.

1.Use CONFIG GET Instead of FT.CONFIG:

Example Command:

CONFIG GET MAXEXPANSIONS

2.Set MAXEXPANSIONS in the Query:

• You can set the MAXEXPANSIONS parameter directly in your search query.

Example query:

FT.SEARCH index_name "@filendname:keywordname*" MAXEXPANSIONS 1000

Here is an example of how you can use Python to connect to Redis and set the MAXEXPANSIONS parameter:

import redis
# Connect to Redis
redis_client = redis.StrictRedis(
    host='your_redis_host',
    port=6379,
    password='your_redis_password',
    ssl=True
)
# Set MAXEXPANSIONS parameter
redis_client.execute_command('CONFIG SET MAXEXPANSIONS 1000')
# Perform search query
result = redis_client.execute_command('FT.SEARCH', 'index_name', '@filendname:keywordname*', 'MAXEXPANSIONS', 1000)
print(result)

I hope this information helps. Please do let us know if you have any further queries.

Hi Daram, Manikanta,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. 

Thank You for the deatils @Prasad Chaganti . But no luck here.

CONFIG GET MAXEXPANSIONS

CONFIG SET MAXEXPANSIONS 1000

MAXEXPANSION with ft.search

After the data reload and index recreation, it seems to work fine for more than 200 records. But, when we perform a contains search or search using part of the field, it's not returning all the expected results.