Creating a user mapping for the HDFS data source
When you attempt to access a HDFS data source server, the federated server establishes a connection to the HDFS data source server by using the user ID and password that are valid for that data source.
About this task
You can create a user mapping for every user ID that accesses the federated system to send distributed requests to the HDFS data source.
Issue the CREATE USER MAPPING statement.
CREATE USER MAPPING FOR local_userID SERVER server_definition_name OPTIONS (REMOTE_AUTHID 'remote_userID', REMOTE_PASSWORD 'remote_password')
Although the remote_userID and remote_password variables are specified as options in the CREATE USER MAPPING statement, these options are required to access HDFS data sources.