Monday, April 29, 2013

Latest Vertica Driver Version 6.1 Caveat : LCOPY issue

newer versions of device drivers bring along some performance enhancements giving users better experience. seldom they would require any change in database queries / code that is already there.

but in this case 'LCOPY' command has been replaced with 'COPY LOCAL'. i can't understand the reason behind it, but if you are gonna upgrade your Vertica drivers to Version 6.1 please keep this in mind.

Now for the good part:
-improved performance of UNION and UNION ALL queries
-supports SQL WITH clause in a primary SELECT statement

etc.

No comments:

Post a Comment