Skip to Content
avatar image
Former Member

Can we have our own hash function for hash partition?

My question is basically the out come of the hash partitioning test with an integer column. I have raised a question on the hash function: how it generate hash number on an integer column. Below is the link to the ticket.

We want to override hash function according to our need so that it will suit out business need. Is there any way we can override the hash function?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 09, 2018 at 07:33 AM

    There is no option to implement a custom hash function for partitioning in SAP HANA.

    Looking at the original query I'd say you're probably using it the wrong way. Assuming that the hash function is indeed a simply MOD() is overly simplistic and I used it in my answer back in the day to illustrate the concept.

    I recommend checking the available documentation and FAQ notes on Partitioning before assuming it doesn't work.

    Add comment
    10|10000 characters needed characters exceeded