/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
.