Class CopyCommand
- All Implemented Interfaces:
Serializable
,Cloneable
Describes a COPY
command for Amazon Redshift.
- See Also:
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionclone()
boolean
Optional parameters to use with the Amazon RedshiftCOPY
command.A comma-separated list of column names.The name of the target table.int
hashCode()
void
setCopyOptions
(String copyOptions) Optional parameters to use with the Amazon RedshiftCOPY
command.void
setDataTableColumns
(String dataTableColumns) A comma-separated list of column names.void
setDataTableName
(String dataTableName) The name of the target table.toString()
Returns a string representation of this object; useful for testing and debugging.withCopyOptions
(String copyOptions) Optional parameters to use with the Amazon RedshiftCOPY
command.withDataTableColumns
(String dataTableColumns) A comma-separated list of column names.withDataTableName
(String dataTableName) The name of the target table.
-
Constructor Details
-
CopyCommand
public CopyCommand()
-
-
Method Details
-
setDataTableName
The name of the target table. The table must already exist in the database.
- Parameters:
dataTableName
- The name of the target table. The table must already exist in the database.
-
getDataTableName
The name of the target table. The table must already exist in the database.
- Returns:
- The name of the target table. The table must already exist in the database.
-
withDataTableName
The name of the target table. The table must already exist in the database.
- Parameters:
dataTableName
- The name of the target table. The table must already exist in the database.- Returns:
- Returns a reference to this object so that method calls can be chained together.
-
setDataTableColumns
A comma-separated list of column names.
- Parameters:
dataTableColumns
- A comma-separated list of column names.
-
getDataTableColumns
A comma-separated list of column names.
- Returns:
- A comma-separated list of column names.
-
withDataTableColumns
A comma-separated list of column names.
- Parameters:
dataTableColumns
- A comma-separated list of column names.- Returns:
- Returns a reference to this object so that method calls can be chained together.
-
setCopyOptions
Optional parameters to use with the Amazon Redshift
COPY
command. For more information, see the "Optional Parameters" section of Amazon Redshift COPY command. Some possible examples that would apply to Firehose are as follows.delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.delimiter '|
- fields are delimited with "|" (this is the default delimiter).delimiter '|' escape
- the delimiter should be escaped.fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed width in the source, with each width specified after every column in the table.JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the format of the data.For more examples, see Amazon Redshift COPY command examples.
- Parameters:
copyOptions
- Optional parameters to use with the Amazon RedshiftCOPY
command. For more information, see the "Optional Parameters" section of Amazon Redshift COPY command. Some possible examples that would apply to Firehose are as follows.delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.delimiter '|
- fields are delimited with "|" (this is the default delimiter).delimiter '|' escape
- the delimiter should be escaped.fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed width in the source, with each width specified after every column in the table.JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the format of the data.For more examples, see Amazon Redshift COPY command examples.
-
getCopyOptions
Optional parameters to use with the Amazon Redshift
COPY
command. For more information, see the "Optional Parameters" section of Amazon Redshift COPY command. Some possible examples that would apply to Firehose are as follows.delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.delimiter '|
- fields are delimited with "|" (this is the default delimiter).delimiter '|' escape
- the delimiter should be escaped.fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed width in the source, with each width specified after every column in the table.JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the format of the data.For more examples, see Amazon Redshift COPY command examples.
- Returns:
- Optional parameters to use with the Amazon Redshift
COPY
command. For more information, see the "Optional Parameters" section of Amazon Redshift COPY command. Some possible examples that would apply to Firehose are as follows.delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.delimiter '|
- fields are delimited with "|" (this is the default delimiter).delimiter '|' escape
- the delimiter should be escaped.fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed width in the source, with each width specified after every column in the table.JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the format of the data.For more examples, see Amazon Redshift COPY command examples.
-
withCopyOptions
Optional parameters to use with the Amazon Redshift
COPY
command. For more information, see the "Optional Parameters" section of Amazon Redshift COPY command. Some possible examples that would apply to Firehose are as follows.delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.delimiter '|
- fields are delimited with "|" (this is the default delimiter).delimiter '|' escape
- the delimiter should be escaped.fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed width in the source, with each width specified after every column in the table.JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the format of the data.For more examples, see Amazon Redshift COPY command examples.
- Parameters:
copyOptions
- Optional parameters to use with the Amazon RedshiftCOPY
command. For more information, see the "Optional Parameters" section of Amazon Redshift COPY command. Some possible examples that would apply to Firehose are as follows.delimiter '\t' lzop;
- fields are delimited with "\t" (TAB character) and compressed using lzop.delimiter '|
- fields are delimited with "|" (this is the default delimiter).delimiter '|' escape
- the delimiter should be escaped.fixedwidth 'venueid:3,venuename:25,venuecity:12,venuestate:2,venueseats:6'
- fields are fixed width in the source, with each width specified after every column in the table.JSON 's3://mybucket/jsonpaths.txt'
- data is in JSON format, and the path specified is the format of the data.For more examples, see Amazon Redshift COPY command examples.
- Returns:
- Returns a reference to this object so that method calls can be chained together.
-
toString
Returns a string representation of this object; useful for testing and debugging. -
equals
-
hashCode
public int hashCode() -
clone
-