Skip to content

/AWS1/CL_GLUINTEGRATIONPARTI00

A structure that describes how data is partitioned on the target.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_fieldname TYPE /AWS1/GLUSTRING128 /AWS1/GLUSTRING128

The field name used to partition data on the target. Avoid using columns that have unique values for each row (for example, LastModifiedTimestamp, SystemModTimeStamp) as the partition column. These columns are not suitable for partitioning because they create a large number of small partitions, which can lead to performance issues.

iv_functionspec TYPE /AWS1/GLUSTRING128 /AWS1/GLUSTRING128

Specifies the function used to partition data on the target. The accepted values for this parameter are:

  • identity - Uses source values directly without transformation

  • year - Extracts the year from timestamp values (e.g., 2023)

  • month - Extracts the month from timestamp values (e.g., 2023-01)

  • day - Extracts the day from timestamp values (e.g., 2023-01-15)

  • hour - Extracts the hour from timestamp values (e.g., 2023-01-15-14)

iv_conversionspec TYPE /AWS1/GLUSTRING128 /AWS1/GLUSTRING128

Specifies the timestamp format of the source data. Valid values are:

  • epoch_sec - Unix epoch timestamp in seconds

  • epoch_milli - Unix epoch timestamp in milliseconds

  • iso - ISO 8601 formatted timestamp

Only specify ConversionSpec when using timestamp-based partition functions (year, month, day, or hour). Glue Zero-ETL uses this parameter to correctly transform source data into timestamp format before partitioning.

Do not use high-cardinality columns with the identity partition function. High-cardinality columns include:

  • Primary keys

  • Timestamp fields (such as LastModifiedTimestamp, CreatedDate)

  • System-generated timestamps

Using high-cardinality columns with identity partitioning creates many small partitions, which can significantly degrade ingestion performance.

Queryable Attributes

FieldName

The field name used to partition data on the target. Avoid using columns that have unique values for each row (for example, LastModifiedTimestamp, SystemModTimeStamp) as the partition column. These columns are not suitable for partitioning because they create a large number of small partitions, which can lead to performance issues.

Accessible with the following methods

Method Description
GET_FIELDNAME() Getter for FIELDNAME, with configurable default
ASK_FIELDNAME() Getter for FIELDNAME w/ exceptions if field has no value
HAS_FIELDNAME() Determine if FIELDNAME has a value

FunctionSpec

Specifies the function used to partition data on the target. The accepted values for this parameter are:

  • identity - Uses source values directly without transformation

  • year - Extracts the year from timestamp values (e.g., 2023)

  • month - Extracts the month from timestamp values (e.g., 2023-01)

  • day - Extracts the day from timestamp values (e.g., 2023-01-15)

  • hour - Extracts the hour from timestamp values (e.g., 2023-01-15-14)

Accessible with the following methods

Method Description
GET_FUNCTIONSPEC() Getter for FUNCTIONSPEC, with configurable default
ASK_FUNCTIONSPEC() Getter for FUNCTIONSPEC w/ exceptions if field has no value
HAS_FUNCTIONSPEC() Determine if FUNCTIONSPEC has a value

ConversionSpec

Specifies the timestamp format of the source data. Valid values are:

  • epoch_sec - Unix epoch timestamp in seconds

  • epoch_milli - Unix epoch timestamp in milliseconds

  • iso - ISO 8601 formatted timestamp

Only specify ConversionSpec when using timestamp-based partition functions (year, month, day, or hour). Glue Zero-ETL uses this parameter to correctly transform source data into timestamp format before partitioning.

Do not use high-cardinality columns with the identity partition function. High-cardinality columns include:

  • Primary keys

  • Timestamp fields (such as LastModifiedTimestamp, CreatedDate)

  • System-generated timestamps

Using high-cardinality columns with identity partitioning creates many small partitions, which can significantly degrade ingestion performance.

Accessible with the following methods

Method Description
GET_CONVERSIONSPEC() Getter for CONVERSIONSPEC, with configurable default
ASK_CONVERSIONSPEC() Getter for CONVERSIONSPEC w/ exceptions if field has no valu
HAS_CONVERSIONSPEC() Determine if CONVERSIONSPEC has a value

Public Local Types In This Class

Internal table types, representing arrays and maps of this class, are defined as local types:

TT_INTEGRATIONPARTITIONSPECLST

TYPES TT_INTEGRATIONPARTITIONSPECLST TYPE STANDARD TABLE OF REF TO /AWS1/CL_GLUINTEGRATIONPARTI00 WITH DEFAULT KEY
.