What does "sorting projections on spatial columns" mean in Vertica Places ?

Hi Ablimit, 
This is just a heads up that we are migrating this Community to a new platform in the next couple of days. We’ll make every effort to answer your question before that…but if it remains open, please do visit our new forum and pose your question once again. You’ll find the new forum here: https://community.dev.hp.com/t5/Big-Data-and-Analytics/ct-p/bigdata_analytics. Please visit us on Thursday!

Hi Ablimit.

The idea of sorting by a geometry column is to group geometries nearby in the space, which are likely going to be accessed together (e.g., range query), so that a (large, irrelevant) number of geometries can be pruned during query processing. Vertica uses an encoding of the geometries to determine order, but doesn't modify data while sorting.

Hope this helps.

Ariel