HCAT_DESCRIBESCHEMA function

The HCAT_DESCRIBESCHEMA function returns a textual description of the definition of a Db2® Big SQL Hadoop schema as defined by the Hive catalogs. The description is a formatted text string.

Syntax

Read syntax diagramSkip visual syntax diagram HCAT_DESCRIBESCHEMA ( schema )

Description

schema
The Db2 Big SQL schema in which the table resides.

Examples

The following example shows the definition of the schema, S1.
values(syshadoop.hcat_describeschema('S1');
Name        :   s1
Location    :   hdfs://localhost:9000/user/hive/warehouse/s1.db 
Comment     :   null
Parameters  :