|Parameter||Description||Applicable CLI Commands|
The type of CLI command to execute. Accepted values:
See Examples below.
For more information on the following commands, see CLI for Connections.
If no password is specified, you are prompted to enter one.
Defines the client-side path where the JSON output is stored for all commands. Default value is
(Optional) When communicating over HTTPS, this setting can be used to override the default behavior of validating the server certificate before executing the command.
(Optional) Connect to the datastore over SSL.
- For Hive, you can publish Avro or Parquet results from HDFS or S3 to Hive.
For Redshift, you can publish CSV, JSON, or Avro results from S3 to Redshift.
NOTE: To publish to Redshift, results must be written first to S3.
NOTE: By default, data is published to Redshift using the
publicschema. To publish using a different schema, Even if you are publishing to the default schema, you mustpreface the
tablevalue with the name of the schema to use:
For existing tables, you can clear them and load them with results from a job. If the table does not exist, a new one is created and populated.
Example (All one command):