on 03-09-2018 4:14 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.