Overflow error when changing from direct query to spice

Question & Answer
,
1

Hey,

I’m working with some calculated fields inside the datasets, where I do some simple mathematics. I take the sqrt(x + y + 2*j). Which turns out good, when I’m using direct query. Once i change the query method to spice, I get this error in my analysis:

image

I can fix this by using direct query, but this is not optimal for my case. How do I solve this error?

1 Like
2

Hello @tryingMyBest - Welcome to the Community! Thank you for posting your query. Can you please go through the following threads. It seems similar problem was encountered by others as well. Hope this helps!

2 Likes
3

Hi @tryingMyBest - What is the max value of j? Can you check that.

Regards - Sanjeeb

1 Like
4

Hi @Sanjeeb2022

The max value of j is 37,735,417,264,138.3 which in my calculation times 2 gives: 75,470,834,528,276.7.

5

Hi @sagmukhe ,

Thank you, I’ve tried going through it, but this didn’t get me any further.

6

Hi @tryingMyBest - As per the documentation, the max value of an integer is 9007199254740991 or 2^53 - 1 . and your values are within that limit.

Can you please raise a ticket to AWS Customer support for the same. To raise a ticket, please follow the link Creating support cases and case management - AWS Support

Regards - Sanjeeb

1 Like
7

Thank you @Sanjeeb2022! After reaching out to support, we found that the problem occurred due to some calculation. The solution ended up being converted into a double by using the following calculation:

Sqrt{x + y + 2 * (j^1)}

1 Like
8

Thank you @tryingMyBest … Good to hear that the problem is resolved.

Regards - Sanjeeb