Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
numeric vs float data type performance
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
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
found a workaround: cast to float on the select query.