Skip to Content
-1

Can we have our own hash function for hash partition?

Mar 09 at 04:14 AM

22

avatar image
Former Member

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?

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
0

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.

Share
10 |10000 characters needed characters left characters exceeded