How to check iPCV schemas
Although the schemas for iPCVs are published, sometimes you may want to check
these programmatically. To do this you can use SHOW commands:
Get catalogs
Section titled “Get catalogs”SHOW catalogs --[ optional LIKE pattern ] like 'hive%'Get schemas
Section titled “Get schemas”SHOW schemas FROM hive --[ optional LIKE pattern ] like '%ipcv%'Get tables
Section titled “Get tables”SHOW tables FROM hive.explorer_ipcv --[ optional LIKE pattern ] like 'organisation%'Get columns
Section titled “Get columns”SHOW columns FROM hive.explorer_ipcv.patient --[ optional LIKE pattern ] like '%date%'