HCAT_DESCRIBESCHEMA function

The SYSHADOOP.HCAT_DESCRIBESCHEMA function returns a textual description of the definition of a schema as defined by the Hive catalogs.

Syntax

Read syntax diagramSkip visual syntax diagram HCAT_DESCRIBESCHEMA ( schema )

Description

schema
The schema in which the table resides.

Examples

The following example shows the definition of the schema, S1:
db2 "values (varchar(syshadoop.hcat_describeschema('S1'),250))"
The output looks like the following example:

Name : s1
Location : file:/mnt/blumeta0/home/db2inst1/sqllib/bigsql/warehouse/tablespace/external/hive/s1.db
Comment : null
Parameters :
   biginsights.sql.metadata = {"v":1,"source":"BIGSQL","version":"4.0"}

1 record(s) selected.