Currently, I'm thinking of how to search a keyword within a string of text (e.g. search "happy" inside the string "I'm a very happy man" and return to me that text) using AWS DynamoDB. Is there a way to query this?
What I know of is that Query allows "begin with" or "between" which doesn't really help me in this case.
Also, lets say i have a million records in the table "A", is it easy to migrate data into a different table "B"/"C" if I break up table "A"?
Thanks in advance!
On
DynamoDB cannot efficiently do a query for "Contains" keyword because it doesn't build indices to do so. The only indices that are built are those on the primary key (hash or hash and range), local secondary indices and global secondary indices. Using the CONTAINS filter in scan will cause Dynamo DB to perform a full table scan, which could potentially eat a lot of your configured read throughput, causing other queries to get throttled. You can consider scan with CONTAINS filter if this is not a concern for you.
AWS cloud search is more appropriate for full text search queries. The AWS cloud search service has a section documenting how data in DynamoDB maybe queried - http://docs.aws.amazon.com/cloudsearch/latest/developerguide/searching-dynamodb-data.html.
On
Amazon CloudSearch is probably what you're looking for:
You can specify a DynamoDB table as a source when configuring indexing options or uploading data to a search domain through the console or command line tools. This enables you to quickly set up a search domain to experiment with searching data stored in DynamoDB database tables.
http://docs.aws.amazon.com/cloudsearch/latest/developerguide/searching-dynamodb-data.html
It sounds like what you are looking for is the Contains condition:
You didn't specify how you where querying DynamoDB, so unfortunately I can't give you a specific example. However, if you were using java, you would probably use a QueryFilter.
Your second question seems to have already been answered.