cancel
Showing results for 
Search instead for 
Did you mean: 

Can we have our own hash function for hash partition?

0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

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.