Skip to content

scientific notation negative numbers #150

Closed

Description

@amirjalali1

Negative numbers are coming with scientific notation for example this number:

-229.196852 will be shown as 3.4028236692093845e+32 whenever query by SDK,
Is there any workaround?

Activity

  1. kravets-levko commented on Jun 14, 2023

    @kravets-levko
    Contributor

    Hi @amirjalali1! yes, I can confirm that something's wrong there, and it's realted to Apache Arrow - for some reason it decodes signed floating point numbers as unsigned decimals. For now, as a workaround, try to explicitly cast those numbers to double (CAST(-229.196852 AS DOUBLE) - it should help. Once I find a proper solution - I'll ping you. Sorry for the inconveniences, and thank you for finding and reporting this bug!

  2. kravets-levko commented on Jun 14, 2023

    @kravets-levko
    Contributor

    It look that it's a bug in apache-arrow library which should be fixed in v13 (apache/arrow#35067). Meanwhile, I'll try to find some workaround on our end

  3. amirjalali1 commented on Jun 21, 2023

    @amirjalali1
    Author

    @kravets-levko is the problem persists in ODBC driver as well?

  4. kravets-levko commented on Jun 21, 2023

    @kravets-levko
    Contributor

    @amirjalali1 TBH I don't know, but it looks that this problem is related to this driver only

  5. vishalsingh2972 commented on Aug 9, 2023

    @vishalsingh2972

    Hi @kravets-levko any update on the issue, is this still open or in triage?

  6. kravets-levko commented on Aug 31, 2023

    @kravets-levko
    Contributor

    Hi @vishalsingh2972 (and others in this thread). apache-arrow@13 was released few days ago, so I'm going to check if the issue is fixed there. Will keep you posted. Sorry for the delay

  7. kravets-levko commented on Sep 18, 2023

    @kravets-levko
    Contributor

    Upgrading to apache-arrow@13.0.0 fixed this issue. The fix will become available with v1.5.0 release which is going to be published in few days

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions