DynamoDB query on sub field of JSON Object

Question

Is it possible to search for a subfield of a json object in dynamoDB table?

My table:

Item: "item name",  
Location: {...},  
ItemInformation :  
{  
   ItemName: "itemName",  
   ProductLine: {  
      Brand: "Razer",  
      ManufacturerSource: "Razer"  
}

Originally in this table ItemInformation would be a key and searching for an object we would construct the json for the item information and then query with the json string as a key.. Now we need to implement searching by sub fields of that object, which can contain different fields each time, i.e. isDigital: "true".

I notice in the question: DynamoDB advanced scan - JAVA

The answer would seem to be no and I would have to separate out the fields. But I am curious about why and how the PHP library can query for sub fields on a JSON object in dynamoDB. Is there really no better solution then to store the column as separate fields and then add an index on all fields?

forums.aws.amazon.com/thread.jspa?messageID=581700, have a look at this example — Shibashis
– Shibashis, Commented Jun 7, 2016 at 3:42

Niru · Accepted Answer · 2016-06-08 01:06:46Z

3

After looking through documentation it is not feasible to implement the search fields as I originally intended. The problem is that while the values are JSON they are stored as string literals so I have to do refactoring to start storing as JSON objects. Additionally I cannot add in columns and index because the search could operate on any number of fields and different items can have different fields, i.e. an Item can have Brand, BatteryInformation, Name. Given that the requirement is that any of these subfields should be searchable its better to do this in Cloud Search or ElasticSearch where I can index and search on arbitrary fields and values within a column of an object.

Since this is a DynamoDB table, I am going to use CloudSearch since it offers easier indexing option and integration for data.

answered Jun 8, 2016 at 1:06

Niru

1,5971 gold badge33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

notionquest · Accepted Answer · 2016-06-07 06:56:57Z

1

At the moment, the only solution available is to store the column as separate fields. Probably, aws may come up with a solution in future releases.

answered Jun 7, 2016 at 6:56

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

Collectives™ on Stack Overflow

DynamoDB query on sub field of JSON Object

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related