Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

In Vertica Place documentation it says  "Consider sorting projections on spatial
columns to improve the performance  of .... ".

What does this mean in technical terms ? Assigning space filling curve values for objects so that the algorithm can filter them during the query processing ?
 

Comments

  • 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

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.