Can we expand client protocol - add field os_hostname, for security and audit purposes
Can I ask for a new feature - expand client protocol, add field os_hostname.
Right now for Vertica connection I can see IP. While it is sufficient, it is very painful to work with, as DNS is typically slow, and resolving IP to hostname and seeing it in query result on various DC tables is not possible.
I can write c++ UDx that will resolve IP through DNS call, but that would have very unstable performance and can just plain hang. And, generally will be very poorly performing on millions of rows.
If you would add in next version of Vertica protocol (4.4) new field - os_hostname, and populate with what is reported by hostname, you will make working at Vertica connections much easier.
Corresponding DC tables and some system views should be expanded to add new field - os_hostname.
That should be filed under new features for security and audit.