Specifies the port number to use.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Aliases: | BULKLOAD_PORT= [Hadoop, Impala] |
| BLPORT= [Impala] | |
| Default: | 8020 [Hadoop] |
| 8080 [Greenplum, HAWQ] | |
| 50070 [Impala] | |
| Restriction: | Hadoop: This option is required if Hadoop HDFS service is running on a port other than 8020. |
| Requirement: | To specify this option, you must first specify BULKEXTRACT= YES or BULKLOAD=YES. |
| Interaction: | Greenplum: Use the GPLOAD_PORT environment variable to specify the port for the bulk-loading utility. The BL_PORT= data set option overrides the value of the GPLOAD_PORT environment variable. |
| Data source: | Greenplum, Hadoop, HAWQ, Impala |
| See: | BULKLOAD= data set option |
| Examples: | Specify the GPLOAD_PORT value on PC hosts in the Advanced
system settings:
|
Export the GPLOAD_PORT value on UNIX hosts for the
C shell:
|
|
Specify the GPLOAD_PORT value within the SAS invocation
command:
|
Table of Contents
Use this option to specify the port number that bulk loading uses to communicate with the server where the input data file resides.