Skip to content

/AWS1/CL_GLU=>GETTABLES()

About GetTables

Retrieves the definitions of some or all of the tables in a given Database.

Method Signature

IMPORTING

Required arguments:

IV_DATABASENAME TYPE /AWS1/GLUNAMESTRING /AWS1/GLUNAMESTRING

The database in the catalog whose tables to list. For Hive compatibility, this name is entirely lowercase.

Optional arguments:

IV_CATALOGID TYPE /AWS1/GLUCATALOGIDSTRING /AWS1/GLUCATALOGIDSTRING

The ID of the Data Catalog where the tables reside. If none is provided, the Amazon Web Services account ID is used by default.

IV_EXPRESSION TYPE /AWS1/GLUFILTERSTRING /AWS1/GLUFILTERSTRING

A regular expression pattern. If present, only those tables whose names match the pattern are returned.

IV_NEXTTOKEN TYPE /AWS1/GLUTOKEN /AWS1/GLUTOKEN

A continuation token, included if this is a continuation call.

IV_MAXRESULTS TYPE /AWS1/GLUCATALOGGETTERPAGESIZE /AWS1/GLUCATALOGGETTERPAGESIZE

The maximum number of tables to return in a single response.

IV_TRANSACTIONID TYPE /AWS1/GLUTRANSACTIONIDSTRING /AWS1/GLUTRANSACTIONIDSTRING

The transaction ID at which to read the table contents.

IV_QUERYASOFTIME TYPE /AWS1/GLUTIMESTAMP /AWS1/GLUTIMESTAMP

The time as of when to read the table contents. If not set, the most recent transaction commit time will be used. Cannot be specified along with TransactionId.

RETURNING

OO_OUTPUT TYPE REF TO /AWS1/CL_GLUGETTABLESRESPONSE /AWS1/CL_GLUGETTABLESRESPONSE