Skip to Content
avatar image
-1
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.

https://answers.sap.com/questions/453059/hash-partitioning-1.html#

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 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