I have installed Hdfs conenctor into Vertica to be able to create external tables or load data from Hadoop into Vertica.
For that, I used following statements:
Code: Select all
-- Installation script: defined the shared library and the appropriate entry points
select version();
\set libfile '\'/opt/vertica/packages/hdfs_connectors/lib/libvertica_hdfs_conn.so\'';
CREATE LIBRARY HdfsSource as :libfile;
CREATE SOURCE Hdfs as language 'C++' name 'HdfsFactory' library HdfsSource;
Now I need to grant exec rights to normal users.
Hdfs source is visible when listing procedures with
Code: Select all
\df
List of functions
procedure_name | procedure_return_type | procedure_argument_types
---------------------------------------------------------+------------------------+---------------------------------------------------------------------------------
Hdfs | |
What I've tried:
Code: Select all
grant execute on procedure hdfs to username;
grant execute on procedure hdfs() to username;
grant execute on procedure hdfs(url Varchar, username Varchar) to username;
Regards,
JB