CREATE SERVER statement - Examples for the Rest Service wrapper

Use the CREATE SERVER statement to register server definitions for the Rest Service wrapper.

The following example describes how to register a server definition for a Rest Service wrapper by issuing the CREATE SERVER statement:

CREATE SERVER hdfsserver  TYPE hdfsparquet 
     VERSION 3.5 WRAPPER my_wrapper
     OPTIONS  (HOST 'host_name', PORT 'port_number', DBNAME 'database_name');

hdfsserver: A name that you assign to the hadoop namenode server. Duplicate server definition names are not allowed.
TYPE: Specifies the type of data source server to which you are configuring access. For the hadoop file system wrapper, the server type must be hdfsparquet.
VERSION: The version of the hadoop file system that you want to access.
WRAPPER: The wrapper name that you specified in the CREATE WRAPPER statement.
HOST: The server name where the hadoop namenode server resides. User can specify the IP address as the hostname.
PORT: The namenode server listen port.
DBNAME: The value of this option is not used, but it is also a mandatory option during create server.