Skip to Content

Can we have our own hash function for hash partition?

Mar 09 at 04:14 AM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
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.

10 |10000 characters needed characters left characters exceeded