/AWS1/CL_GLUTABLEINPUT¶
A structure used to define a table.
CONSTRUCTOR¶
IMPORTING¶
Required arguments:¶
iv_name TYPE /AWS1/GLUNAMESTRING /AWS1/GLUNAMESTRING¶
The table name. For Hive compatibility, this is folded to lowercase when it is stored.
Optional arguments:¶
iv_description TYPE /AWS1/GLUDESCRIPTIONSTRING /AWS1/GLUDESCRIPTIONSTRING¶
A description of the table.
iv_owner TYPE /AWS1/GLUNAMESTRING /AWS1/GLUNAMESTRING¶
The table owner. Included for Apache Hive compatibility. Not used in the normal course of Glue operations.
iv_lastaccesstime TYPE /AWS1/GLUTIMESTAMP /AWS1/GLUTIMESTAMP¶
The last time that the table was accessed.
iv_lastanalyzedtime TYPE /AWS1/GLUTIMESTAMP /AWS1/GLUTIMESTAMP¶
The last time that column statistics were computed for this table.
iv_retention TYPE /AWS1/GLUNONNEGATIVEINTEGER /AWS1/GLUNONNEGATIVEINTEGER¶
The retention time for this table.
io_storagedescriptor TYPE REF TO /AWS1/CL_GLUSTORAGEDESCRIPTOR /AWS1/CL_GLUSTORAGEDESCRIPTOR¶
A storage descriptor containing information about the physical storage of this table.
it_partitionkeys TYPE /AWS1/CL_GLUCOLUMN=>TT_COLUMNLIST TT_COLUMNLIST¶
A list of columns by which the table is partitioned. Only primitive types are supported as partition keys.
When you create a table used by Amazon Athena, and you do not specify any
partitionKeys, you must at least set the value ofpartitionKeysto an empty list. For example:
"PartitionKeys": []
iv_vieworiginaltext TYPE /AWS1/GLUVIEWTEXTSTRING /AWS1/GLUVIEWTEXTSTRING¶
Included for Apache Hive compatibility. Not used in the normal course of Glue operations. If the table is a
VIRTUAL_VIEW, certain Athena configuration encoded in base64.
iv_viewexpandedtext TYPE /AWS1/GLUVIEWTEXTSTRING /AWS1/GLUVIEWTEXTSTRING¶
Included for Apache Hive compatibility. Not used in the normal course of Glue operations.
iv_tabletype TYPE /AWS1/GLUTABLETYPESTRING /AWS1/GLUTABLETYPESTRING¶
The type of this table. Glue will create tables with the
EXTERNAL_TABLEtype. Other services, such as Athena, may create tables with additional table types.Glue related table types:
- EXTERNAL_TABLE
Hive compatible attribute - indicates a non-Hive managed table.
- GOVERNED
Used by Lake Formation. The Glue Data Catalog understands
GOVERNED.
it_parameters TYPE /AWS1/CL_GLUPARAMETERSMAP_W=>TT_PARAMETERSMAP TT_PARAMETERSMAP¶
These key-value pairs define properties associated with the table.
io_targettable TYPE REF TO /AWS1/CL_GLUTABLEIDENTIFIER /AWS1/CL_GLUTABLEIDENTIFIER¶
A
TableIdentifierstructure that describes a target table for resource linking.
io_viewdefinition TYPE REF TO /AWS1/CL_GLUVIEWDEFNINPUT /AWS1/CL_GLUVIEWDEFNINPUT¶
A structure that contains all the information that defines the view, including the dialect or dialects for the view, and the query.
Queryable Attributes¶
Name¶
The table name. For Hive compatibility, this is folded to lowercase when it is stored.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_NAME() |
Getter for NAME, with configurable default |
ASK_NAME() |
Getter for NAME w/ exceptions if field has no value |
HAS_NAME() |
Determine if NAME has a value |
Description¶
A description of the table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_DESCRIPTION() |
Getter for DESCRIPTION, with configurable default |
ASK_DESCRIPTION() |
Getter for DESCRIPTION w/ exceptions if field has no value |
HAS_DESCRIPTION() |
Determine if DESCRIPTION has a value |
Owner¶
The table owner. Included for Apache Hive compatibility. Not used in the normal course of Glue operations.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_OWNER() |
Getter for OWNER, with configurable default |
ASK_OWNER() |
Getter for OWNER w/ exceptions if field has no value |
HAS_OWNER() |
Determine if OWNER has a value |
LastAccessTime¶
The last time that the table was accessed.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_LASTACCESSTIME() |
Getter for LASTACCESSTIME, with configurable default |
ASK_LASTACCESSTIME() |
Getter for LASTACCESSTIME w/ exceptions if field has no valu |
HAS_LASTACCESSTIME() |
Determine if LASTACCESSTIME has a value |
LastAnalyzedTime¶
The last time that column statistics were computed for this table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_LASTANALYZEDTIME() |
Getter for LASTANALYZEDTIME, with configurable default |
ASK_LASTANALYZEDTIME() |
Getter for LASTANALYZEDTIME w/ exceptions if field has no va |
HAS_LASTANALYZEDTIME() |
Determine if LASTANALYZEDTIME has a value |
Retention¶
The retention time for this table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_RETENTION() |
Getter for RETENTION |
StorageDescriptor¶
A storage descriptor containing information about the physical storage of this table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_STORAGEDESCRIPTOR() |
Getter for STORAGEDESCRIPTOR |
PartitionKeys¶
A list of columns by which the table is partitioned. Only primitive types are supported as partition keys.
When you create a table used by Amazon Athena, and you do not specify any
partitionKeys, you must at least set the value ofpartitionKeysto an empty list. For example:
"PartitionKeys": []
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_PARTITIONKEYS() |
Getter for PARTITIONKEYS, with configurable default |
ASK_PARTITIONKEYS() |
Getter for PARTITIONKEYS w/ exceptions if field has no value |
HAS_PARTITIONKEYS() |
Determine if PARTITIONKEYS has a value |
ViewOriginalText¶
Included for Apache Hive compatibility. Not used in the normal course of Glue operations. If the table is a
VIRTUAL_VIEW, certain Athena configuration encoded in base64.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_VIEWORIGINALTEXT() |
Getter for VIEWORIGINALTEXT, with configurable default |
ASK_VIEWORIGINALTEXT() |
Getter for VIEWORIGINALTEXT w/ exceptions if field has no va |
HAS_VIEWORIGINALTEXT() |
Determine if VIEWORIGINALTEXT has a value |
ViewExpandedText¶
Included for Apache Hive compatibility. Not used in the normal course of Glue operations.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_VIEWEXPANDEDTEXT() |
Getter for VIEWEXPANDEDTEXT, with configurable default |
ASK_VIEWEXPANDEDTEXT() |
Getter for VIEWEXPANDEDTEXT w/ exceptions if field has no va |
HAS_VIEWEXPANDEDTEXT() |
Determine if VIEWEXPANDEDTEXT has a value |
TableType¶
The type of this table. Glue will create tables with the
EXTERNAL_TABLEtype. Other services, such as Athena, may create tables with additional table types.Glue related table types:
- EXTERNAL_TABLE
Hive compatible attribute - indicates a non-Hive managed table.
- GOVERNED
Used by Lake Formation. The Glue Data Catalog understands
GOVERNED.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TABLETYPE() |
Getter for TABLETYPE, with configurable default |
ASK_TABLETYPE() |
Getter for TABLETYPE w/ exceptions if field has no value |
HAS_TABLETYPE() |
Determine if TABLETYPE has a value |
Parameters¶
These key-value pairs define properties associated with the table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_PARAMETERS() |
Getter for PARAMETERS, with configurable default |
ASK_PARAMETERS() |
Getter for PARAMETERS w/ exceptions if field has no value |
HAS_PARAMETERS() |
Determine if PARAMETERS has a value |
TargetTable¶
A
TableIdentifierstructure that describes a target table for resource linking.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TARGETTABLE() |
Getter for TARGETTABLE |
ViewDefinition¶
A structure that contains all the information that defines the view, including the dialect or dialects for the view, and the query.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_VIEWDEFINITION() |
Getter for VIEWDEFINITION |