[datafusion-spark]: Refactor hex's signature away from user_defined

[codetyri0n]

Which issue does this PR close?

• part of #12725

Rationale for this change

moving hex away from a user defined signature as it is out of scope and added a UT for checking correct number of args

Are these changes tested?

existing tests

Are there any user-facing changes?

yes