amazon-dynamodbdynamodb-queriespartiql

New to PartiQL - what is wrong with this SELECT statement?

Using DynamoDB with PartiQL, I am trying to select records using a global index:

SELECT *
FROM "My-Table.My-Index"
WHERE Foo = 'bar'
AND Timestamp >= 638014354649346173
AND Timestamp <= 638014355249346173
ORDER BY Timestamp

I am getting an exception of:

One or more errors occurred. (Statement wasn't well formed, can't be processed: Unexpected keyword)

Not sure what I am doing wrong here as I am new to PartiQL syntax.

Solution

  • It should be like this:

    SELECT *
FROM "My-Table"."My-Index"
WHERE "Foo" = 'bar'
AND "Timestamp" >= 638014354649346173
AND "Timestamp" <= 638014355249346173
ORDER BY "Timestamp"