Loading sorted data in vertica

Moderator: NorbertKrupa

Post Reply
dhaneshp
Newbie
Newbie
Posts: 2
Joined: Tue Jan 05, 2016 9:09 am

Loading sorted data in vertica

Post by dhaneshp » Sat Jul 16, 2016 6:56 pm

I have data that is already sorted by primary keys, which I want to load to vertica. Is there anyway to specify that the data is already sorted so that Vertica can make use of that information to make the loads more efficient?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1822
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Loading sorted data in vertica

Post by JimKnicely » Wed Sep 21, 2016 4:23 pm

No, there is not a way to tell Vertica not to sort because you have sorted data.

The reasoning behind that is simple. We require that all columns be sorted once they reach the ROS. Vertica cannot risk that the input record set is sorted, even though the user is telling us that it is.

Although, the good news is that if the data is sorted first, it will load faster into the ROS. This is especially true if you have primary key constraint checking turning on (Vertica 8 handles this situation particularly well!)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Data Load”