Alternator: Support new DynamoDB's PartiQL syntax #8787
Labels
Milestone
Comments
avikivity
pushed a commit
that referenced
this issue
Jun 3, 2021
In the last year, four new features were added to DynamoDB which we don't yet support - Kinesis Streams, PartiQL, Contributor Insights and Export to S3. Let's document them as missing Alternator features, and point to the four newly-created issues about these features. Refs #8786 Refs #8787 Refs #8788 Refs #8789 Signed-off-by: Nadav Har'El <nyh@scylladb.com> Message-Id: <20210603125825.1179171-1-nyh@scylladb.com>
nyh
added a commit
that referenced
this issue
Jun 3, 2021
In the last year, four new features were added to DynamoDB which we don't yet support - Kinesis Streams, PartiQL, Contributor Insights and Export to S3. Let's document them as missing Alternator features, and point to the four newly-created issues about these features. Refs #8786 Refs #8787 Refs #8788 Refs #8789 Signed-off-by: Nadav Har'El <nyh@scylladb.com> Message-Id: <20210603125825.1179171-1-nyh@scylladb.com>
avikivity
pushed a commit
that referenced
this issue
Jun 6, 2021
In the last year, four new features were added to DynamoDB which we don't yet support - Kinesis Streams, PartiQL, Contributor Insights and Export to S3. Let's document them as missing Alternator features, and point to the four newly-created issues about these features. Refs #8786 Refs #8787 Refs #8788 Refs #8789 Signed-off-by: Nadav Har'El <nyh@scylladb.com> Message-Id: <20210603125825.1179171-1-nyh@scylladb.com>
avikivity
pushed a commit
that referenced
this issue
Jun 6, 2021
In the last year, four new features were added to DynamoDB which we don't yet support - Kinesis Streams, PartiQL, Contributor Insights and Export to S3. Let's document them as missing Alternator features, and point to the four newly-created issues about these features. Refs #8786 Refs #8787 Refs #8788 Refs #8789 Signed-off-by: Nadav Har'El <nyh@scylladb.com> Message-Id: <20210603125825.1179171-1-nyh@scylladb.com>
lauranovich
pushed a commit
to lauranovich/scylla
that referenced
this issue
Jul 29, 2021
In the last year, four new features were added to DynamoDB which we don't yet support - Kinesis Streams, PartiQL, Contributor Insights and Export to S3. Let's document them as missing Alternator features, and point to the four newly-created issues about these features. Refs scylladb#8786 Refs scylladb#8787 Refs scylladb#8788 Refs scylladb#8789 Signed-off-by: Nadav Har'El <nyh@scylladb.com> Message-Id: <20210603125825.1179171-1-nyh@scylladb.com>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
As announced in November 2020, Amazon DynamoDB now supports a subset of the PartiQL syntax for making reads or writes.
PartiQL is an SQL-like statement syntax which doesn't add new features - just a new way of using the same feature. For example, a
SELECTstatement replaces the traditionalGetItem,QueryorScan, andUPDATE,DELETEorINSERTinstead of the traditionalPutItemandUpdateItem. Features of PartiQL that do not have parallels in the DynamoDB world - like JOINs, are not available in the PartiQL subset which DynamoDB implements (see the documentation linked above for exactly what this subset contains).For executing PartiQL statements, DynamoDB introduced new operations:
ExecuteStatement(for executing one PartiQL statement) andBatchExecuteStatement(for executing multiple statements of the same type - reads or writes), as well asExecuteTransactionfor transactions (which Alternator doesn't yet support).The text was updated successfully, but these errors were encountered: