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

Tags

Database Amazon DynamoDB

Language

English

ThisAccountDoesntExist

asked 2 years ago624 views

1 Answer

Newest
Most votes
Most comments

1

I highly doubt there will be support for multiple tables, as this goes against the NoSQL fundamentals.

EXPERT

Leeroy Hannigan

answered 2 years ago

ThisAccountDoesntExist
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.

Relevant content

Now DynamoDB can return the throughput capacity consumed by PartiQL API calls to help you optimize your queries and throughput costs
SuellenAragao-AWS
asked 2 years ago
Can we query first n rows from DynamoDB using PartiQL?
Accepted Answer
rePost-User-3543171
asked a year ago
Using PartiQL with DAX client for dynamodb
Accepted Answer
AWS-User-8516166
asked 2 years ago
DynamoDB response time on a simple PartiQL query
Accepted Answer
Jos Rees
asked 2 years ago
How do I correlate the query plan with the query report in Amazon Redshift?
AWS OFFICIALUpdated 2 months ago
How can I restrict an IAM user or role to specific attributes in a DynamoDB table?
AWS OFFICIALUpdated 2 years ago
How can I speed up the creation of a global secondary index for an Amazon DynamoDB table?
AWS OFFICIALUpdated a year ago
Why aren't the items with expired Time to Live deleted from my Amazon DynamoDB table?
AWS OFFICIALUpdated 7 months ago
Getting started with AWS Support App in Slack - 10 questions and answers
EXPERT
AChan
published 2 years ago
Leveraging AWS re:Post with an AWS Support Plan
EXPERT
Shiv_M
published 4 months ago