negative decimals are loaded incorrectly to Athena

[max1111]

Hi, 

I have the following values in the column field23 in excel file: 6, 180, -0.995384615384615, -0.000474888237509459, 0.0172985355751867

I have set that field in select tool as double. As the result in Athena table for example for value

-0.000474888237509459 I see -4.7488823750945923E-4 in Athena database.

I would expect to see: -0.0004749

Could you please let me know what is the reason of such behaviour and how to fix it.

Best regards,

Oksana

[ShankerV]

Hi @max1111 

Instead of double, please convert to Fixed decimal to overcome this issue.

[max1111]

Hi @ShankerV ,

thank you for such prompt response. I did (fixeddecimal 19.6), but I got 1 as result.

Best regards,
Max

[grazitti_sapna]

@max1111 , Here is what you can do to overcome it.

Thanks

[max1111]

@grazitti_sapna thank you for the answer, unfortunately it doesn't work. The strange thing is that when I had double, in the browse tool I saw the correct value -0.0004749, but in Athena it was -4.7488823750945923E-4, so I am a bit confused.

Best regards,

Max

[apathetichell]

A few questions:

1) on canvas or in-db?

2) Are you appending to a table or creating a new table?

3) What ODBC driver are you using?

This assumes that the issue is either related to the ODBC driver, Alteryx's interactivity with the ODBC driver, or a existing field type in your Athena dating - the other posts should have walked you through workflow errors.

[max1111]

Hi @apathetichell

1) I am not using in-db tools ( data is read from Input data tool and then loaded to database )

2) droping table if exist

3) Athena ODBC ( 64-BIT)

Best regards,

Max

[max1111]

I have loaded the final output to excel file and result there is correct , seems like it is the issue, which appears when loading data to Athena.

If anyone could advise how to solve this issue please let me know.

Best regards,

Oksana