is possible search subfield of json object in dynamodb table?
my table:
item: "item name", location: {...}, iteminformation : { itemname: "itemname", productline: { brand: "razer", manufacturersource: "razer" } originally in table iteminformation key , searching object construct json item information , query json string key.. need implement searching sub fields of object, can contain different fields each time, i.e. isdigital: "true".
i notice in question: dynamodb advanced scan - java
the answer seem no , have separate out fields. curious why , how php library can query sub fields on json object in dynamodb. there no better solution store column separate fields , add index on fields?
after looking through documentation not feasible implement search fields intended. problem while values json stored string literals have refactoring start storing json objects. additionally cannot add in columns , index because search operate on number of fields , different items can have different fields, i.e. item can have brand, batteryinformation, name. given requirement of these subfields should searchable better in cloud search or elasticsearch can index , search on arbitrary fields , values within column of object.
since dynamodb table, going use cloudsearch since offers easier indexing option , integration data.
