numeric vs float data type performance

yossibmyossibm Vertica Customer

Hi,
It looks like reading the same amount of data takes twice as much time using numeric(8,4) as opposed to float (using pyodbc, reading into pandas). Is it the expected behavior?
Thanks,
Yossi

Answers

  • yossibmyossibm Vertica Customer

    found a workaround: cast to float on the select query.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file