I am running into an issue when using the Python Analysis transform, whenever the source data contains negative numbers I get the error “Value was either too large or too small for UInt64”, dispite the data type in the input not being a UInt.
I have set up a minimal cube to demonstrate the issue:
The manual query output is shown as an Int32, and contains negative numbers. If I preview the data of this transform I see the numbers all fine:
The python analysis transform contains a single statement that returns the input:
If I try to preview the data for this transform I get the error indicating it is trying to convert the input to a UInt64:
Is there something I am not configuring correctly, or is this an issue with the way the transform works? (The server is running Python 3.6.6)