Hello everyone.

I'm trying to understand how BINARY data type works in spark sql. According to examples in the documentation, using cast or literal 'X' should return HEX representation of the binary data type, but when I try the same code, I see base64 representation:

I can not find any reference to such behaviour in the documentation. Is this the default behaviour? If so, what is the rationale behind it?