How to deploy c++ udx using only database credentials
To create library, Vertica require .so file to be visible on one of cluster nodes.
That require OS access to cluster nodes, to copy .so files from build boxes to one of nodes in Vertica cluster.
That goes straight into a face to database security policies.
Is it possible to deploy c++ udx using only database credentials.
I was thinking how it is possible to do. My idea is around new c++ UDX that will accept as parameter very very long hex string, and dump it into file on initiator node as binary. my UDx typically around 10M, that means 20M chars in SQL that has to be sent to Vertica. Hopefully SQL parser and optimiser will not go crazy when they see this long SQL.
Or. UDx function can append to file. Then I can form .so file on one of Vertica nodes incrementally, using multiple invocations of SQL with modestly sized hex stings.
I can write it by myself, no problems, but I would prefer if it would be an approved and properly supported Vertica solution.
Please tell me better alternatives do exist.