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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Dynamo components in 6.2.1

Hello,
I've just figured out that Talend added Dynamo components to the studio, which is a killer feature for me.
Where can I find more info on how to use it?
Specifics questions, which are important: 
[list=1]

  • How the component manages Throughput? I've run tests on the table with 120 Thoughput units but component used only 4-5 units(200 rows per second).

 

  • I'm getting errors when trying to filter the results of scan expression: (Syntax error on token "creation_day", invalid AssignmentOperator; the left-hand side of an assignment must be a variable; Syntax error on tokens, delete these tokens)

 

  • Inside table we created creation_time column to help us with Incremental refreshes. It is epoch milliseconds with 13 digits and is out of integer type, which throws the error when I use it in filter expression.



Any documentation on this component? Thanks a lot!

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Sabrina,
Thanks a lot for your help. I found a solution: since I manually entered the value for filter, Java automatically assigned it type "Int" which is not enough for my value. I had to expicitly identify that this is Long to make it work by appending "L" to my number.
If I use other components, prior to Dynamo, where I define my variable as BigDecimal, everyting works fine.

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Hi,
Have you already checked component references about: TalendHelpCenter:tDynamoDBInput and  TalendHelpCenter:tDynamoDBOutput?
Best regards
Sabrina
Anonymous
Not applicable
Author

Thank you, Sabrina. I couldn't find these pages in google.

Still one more question left: I'm using a timestamp to filter my results.

I get the following error:  


timestamp field is of BigDecimal type... 
0683p000009MFVU.png 0683p000009MFUt.png
Anonymous
Not applicable
Author

Hi,
Could you please also post your schema setting screenshot into forum?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
Thanks a lot for your help. I found a solution: since I manually entered the value for filter, Java automatically assigned it type "Int" which is not enough for my value. I had to expicitly identify that this is Long to make it work by appending "L" to my number.
If I use other components, prior to Dynamo, where I define my variable as BigDecimal, everyting works fine.
Anonymous
Not applicable
Author

Hi  Ivan.Klimovich,
Thanks for sharing your solution with us. Can we consider your issue as resolved?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hello Sabrina,

Yes. 100%. Thanks a lot for the links!