fsprojects / dynamodb.sql Goto Github PK

smaller page size = smaller consumed capacity unit, see best practice guide here (http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/QueryAndScanGuidelines.html#QueryAndScanGuidelines.BurstsOfActivity)

they need to recursively make requests to DynamoDb (similar to what the DynamoDBContext performs under the hood) whilst respecting the overall limit placed upon the query.

also need a retry mechanism as more calls = more chances for failure

Hi Yan,
This could be the same as I mentioned before which you fixed it with long numbers. This time when I'm querying on index with a long number then it is not returning any results and with small number it does. I debugged it a little and found that it is jumping one number up. Following is the query I'm trying and the snapshot of the converted filter

This works
SELECT * FROM pd_cs_friendshiprequest WHERE ForUserId = 578318698 WITH(Index(ForUserIdIndex, false), NoConsistentRead)

This doesn't work
SELECT * FROM pd_cs_friendshiprequest WHERE ForUserId = 10205471065416239 WITH(Index(ForUserIdIndex, false), NoConsistentRead)

http://screencast.com/t/Ti4tizS51

I guess, it will be again a simple fix while converting string to number.
Hoping to hear from you soon.

• investigate compatibility issue with having both AWSSDK.dll and AWSSDK.DynamoDB.dll loaded

http://tomasp.net/blog/2015/query-translation/index.html

http://aws.typepad.com/aws/2013/12/now-available-global-secondary-indexes-for-amazon-dynamodb.html

Table Join Example missing.

Please kindly provide some examples of table joins (join, left join)

Some info on LSI:
http://aws.typepad.com/aws/2013/04/local-secondary-indexes-for-amazon-dynamodb.html
http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/LSI.html
http://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Query.html

Error in Ln: 1 Col: 59
es_active WHERE day = "2021/04/29" AND create_date_device BEGINS WITH "2021/04/
^

The parser backtracked after:
Error in Ln: 1 Col: 65
ve WHERE day = "2021/04/29" AND create_date_device BEGINS WITH "2021/04/29" W
^
Expecting: '<', '<=', '=', '>', '>=' or 'begins with' (case-insensitive)

The parser backtracked after:
Error in Ln: 1 Col: 65
ve WHERE day = "2021/04/29" AND create_date_device BEGINS WITH "2021/04/29" W
^
Expecting: 'between' (case-insensitive)
: InvalidQueryException
at DynamoDb.SQL.Parser.parseDynamoQuery(String str)

http://aws.typepad.com/aws/2013/09/dynamodb-local-for-desktop-development.html
http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Tools.DynamoDBLocal.html

This project needs a new (co-)maintainer - any volunteers?

cc @theburningmonk

I tried querying a table with a "." in it's name. I get the following error: "Expecting: 'where' (case-insensitive)". I get the same error when the table has a hyphen in its name.

I tried using brackets around the table name, as one would do in a SQL client. No luck. I get this error in that case: "Expecting: table name"

Hi there,
I'm getting DynamoDb.SQL.InvalidQueryException when table name has underscores in it. It works fine for other tables without such character. I'm not able to find where it is check for underscores in the table names but it is definitly splitting on the bases of it. (Can't understand F# Code).

Can you let me know how to fix this? Is there any other limitation in table names?

Hi there again,
I have just noticed that the long numbers are not working in sql.
Consider the following two examples

// Not working even the data is present
SELECT * FROM pd_cs_chatroomuser WHERE UserId = 10205471065416056 WITH(Index(UserIdIndex, false), NoConsistentRead)

// Working
SELECT * FROM pd_cs_chatroomuser WHERE UserId = 10205471065 WITH(Index(UserIdIndex, false), NoConsistentRead)

http://aws.typepad.com/aws/2014/04/improved-queries-and-updates-for-dynamodb.html

It would be good if you could use ILMerge to merge the dependencies into the DynamoDB.SQL assembly. That way, we could use any version of AWSSDK.dll along side with any version of DynamoDB.SQL.