ORC Time Partitioned Dataset Sink (Deprecated)
Note: Datasets and the ORC Time Partitioned Dataset Sink are deprecated and will be removed in CDAP 7.0.0.
Sink for a TimePartitionedFileSet that writes data in ORC format. Every time the pipeline runs, a new partition in the TimePartitionedFileSet will be created based on the logical start time of the run. All data for the run will be written to that partition.
This sink is used whenever you want to write to a TimePartitionedFileSet in ORC format. For example, you might want to create daily snapshots of a database table by reading the entire contents of the table and writing to this sink.
Configuration
Property | Macro Enabled? | Description |
|---|---|---|
Dataset Name | Yes | Required. Name of the |
Dataset Base Path | Yes | Optional. Base path for the |
Partition Directory Format | Yes | Optional. Format for the time partition, as used by |
Time Zone | Yes | Optional. The string ID for the time zone to format the date in. Defaults to using UTC. This setting is only used if |
Partition Offset | Yes | Optional. Amount of time to subtract from the pipeline runtime to determine the output partition. Defaults to 0m. The format is expected to be a number followed by an 's', 'm', 'h', or 'd' specifying the time unit, with 's' for seconds, 'm' for minutes, 'h' for hours, and 'd' for days. For example, if the pipeline is scheduled to run at midnight of January 1, 2016, and the offset is set to '1d', data will be written to the partition for midnight Dec 31, 2015." |
Clean Partitions Older Than | Yes | Optional. configures the sink to delete partitions older than a specified date-time after a successful run. If set, when a run successfully finishes, the sink will subtract this amount of time from the runtime and delete any partitions for time partitions older than that. The format is expected to be a number followed by an 's', 'm', 'h', or 'd' specifying the time unit, with 's' for seconds, 'm' for minutes, 'h' for hours, and 'd' for days. For example, if the pipeline is scheduled to run at midnight of January 1, 2016, and this property is set to 7d, the sink will delete any partitions for time partitions older than midnight Dec 25, 2015. |
Compression Codec | No | Optional. Determines the compression codec to use on the resulting data. Valid values are None, Snappy, ZLIB. Default is None. |
Compression Chunk Size | No | Required if setting compressionCodec. Number of bytes in each compression chunk. |
Bytes per stripe | No | Required if setting compressionCodec. Number of bytes in each stripe. |
Rows between index entries | No | Required if setting compressionCodec. Number of rows between index entries (must be >= 1,000). |
Create inline indexes | No | Required if setting compressionCodec. Whether to create inline indexes. |
Output Schema | Yes | Required. The maximum number of alerts to publish per second. Default is 100. |
Example
This example will write to a TimePartitionedFileSet named 'users':
Property | Value |
|---|---|
Dataset Name |
|
Partition Directory Format |
|
Time Zone |
|
It will write data in ORC format using the given schema. Every time the pipeline runs, a new partition in the TimePartitionedFileSet will be created based on the logical start time of the run with the output directory ending with the date formatted as specified. All data for the run will be written to that partition.
For example, if the pipeline was scheduled to run at 10:00am on January 1, 2015 in Los Angeles, a new partition will be created with year 2015, month 1, day 1, hour 10, and minute 0, and the output directory for that partition would end with 2015-01-01/10-00.
Created in 2020 by Google Inc.