Is possible to use regex in Sort Key on a on dynamodb query?

Question

I want to make a query like this.

val dynamoDB = DynamoDB(dynamoDBConfig.amazonDynamoDB()) val table: Table = dynamoDB.getTable("music")

    val spec = QuerySpec()
            .withKeyConditionExpression("artist = :_artist and begins_with(title, :_title)")
            .withValueMap(ValueMap()
                    .withString(":_artist", "Guns n' Roses")
                    .withString(":_title", "*to the Jungle")
            )

and this results in a list of music containing a music with title "Welcome to the Juntle"

No, you can’t. To support that type of usecase you will generally need to look at a complimentary solution, such as Elastic Search — Mike Dinescu, Nov 29 '20 at 18:32

score 2 · Accepted Answer · answered Nov 27 '20 at 01:54

2

No, regex is not supported in Key Condition Expression.

answered Nov 27 '20 at 01:54

jellycsc

10,904
2
15
32

Is possible to use regex in Sort Key on a on dynamodb query?

1 Answers1