Talend DynamoDB component limitations

Anonymous — Tue, 02 Aug 2016 08:38:46 GMT

Hi,
I waited long for this component to release and now I am stuck which I think is the limitation of this component.
What I want to do is to Query a DynamoDB table which has a date column in which date is in "epoch" format i.e 1469898515983 =2016-07-30 17:08:35+00.
So I used the SCAN option and then I used FILTER EXPRESSION. Now the problem is that this value is in number format in DynamoDB and when I gave same value i.e 1469898515983 in tDynamoDBInput -> Filter expression Table. When I search with a String Column, it returns appropriate row. But when I search it with a number It gives me an error that that value is not in integer range. As I have to give that value in a cell that is defined in EXPRESSION TABLE i.e "Value1" I can't do anything about that. Shouldn't it's backend variable be double or something?
here is a picture to illustrate, 1st expression works fine with a string attribute
2nd expression is an integer and don't work when value is given in quotes as it is a number. And without quotes, it gives an error of out of range.

Please help me find a solution. I tries to query by giving 2 expressions in which I cut off last 4 digits from that number and used >= and <= in both expressions but It returned 0 rows every time.
Save

Re: Talend DynamoDB component limitations

Anonymous — Thu, 11 Aug 2016 09:19:34 GMT

Hi,
Could you please create a workaround jira issue on talend bug tracker?
https://jira.talendforge.org/secure/Dashboard.jspa
Best regards
Sabrina

topic Re: Talend DynamoDB component limitations in Talend Studio

Talend DynamoDB component limitations

Re: Talend DynamoDB component limitations