Win a copy of High Performance Python for Data Analytics this week in the Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Jj Roberts
  • Carey Brown
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

If one cannot query from inside the JSON using DynamoDb then what is the use of storing JSON docs?

 
Ranch Foreman
Posts: 2348
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In Documented oriented NoSql databases , one stores docs (e.g JSONs). Then one can run a sql like query using a field from inside JSON in the where clause of the query. This happens in document oriented nosql dbs like cosmos db and mongodb. DynamoDb despite being a document oriented store does not support such queries. In that case what is the use of storing the JSON docs?
thanks.
 
Marshal
Posts: 3355
492
Android Eclipse IDE TypeScript Redhat MicroProfile Quarkus Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've never worked with DynamoDB, but a quick Google search shows that there is a SQL-like query language called PartiQL

Amazon wrote:PartiQL provides SQL-compatible query access across multiple data stores containing structured data, semistructured data, and nested data. It is widely used within Amazon and is now available as part of many AWS services, including DynamoDB.


Syntax and example for select: PartiQL Select Statements for DynamoDB
 
Monica Shiralkar
Ranch Foreman
Posts: 2348
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks.

For some reason while searching I had read that it doesnt support. I had checked this link https://db-engines.com/en/system/Amazon+DynamoDB%3BMicrosoft+Azure+Cosmos+DB where for DynamoDb it shows cross for the SQL. I will check on PartiQL.
 
Monica Shiralkar
Ranch Foreman
Posts: 2348
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I read that we can query using the partition key and sort key (optional). The documents which we store (e.g the JSON) can have any structure but should have a partition key and can optionally have a sort key. It looks like we need to model our data such that one can fetch that using the partition key and sort key.
 
reply
    Bookmark Topic Watch Topic
  • New Topic