Will Multi-Table queries be supported with PartiQL + DynamoDB?
0
Currently you get the error ValidationException: Only Select from a Single Table or index supported
Are the plans to support joins/multi-select even if it is inefficient scans?
Topics
asked 2 months ago5 views
1 Answers
1
I highly doubt there will be support for multiple tables, as this goes against the NoSQL fundamentals.
answered 2 months ago
Relevant questions
Will Multi-Table queries be supported with PartiQL + DynamoDB?
asked 2 months agoGlobal secondary indexes null partition key
asked 5 years agoRowCount for DynamoDB
Accepted Answerasked 3 years agoHow to see the rows of table in order by their ID with SELECT command in QLDB?
asked 3 months agoNow DynamoDB can return the throughput capacity consumed by PartiQL API calls to help you optimize your queries and throughput costs
asked 4 months agoPoint in Time Recovery on Deleted Tables
Accepted Answerasked 4 years agoUser Defined Functions
asked 3 months agoPartiQL select always return ValidationException: Unexpected from source
asked a year agoUsing PartiQL with DAX client for dynamodb
Accepted Answerasked a month agoDynamodb cost for index writes
asked 2 years ago
It's part of the PartiQL REPL https://partiql.org/tutorial.html#querying-nested-data it seems like it would be theoretically possible through an in-memory inner-query (not efficient), in lieu of a true FK constrained join.