Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend DynamoDB component limitations

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
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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