Skip to content

Returns Hive partition information for an external table.

func.inspect_hive_part_info(<catalog>, <db>, <table>)
func.inspect_hive_part_info('hive_catalog', 'db', 'tbl')
┌──────────────────┐
│ (partition info) │
└──────────────────┘
INSPECT_HIVE_PART_INFO(<catalog>, <db>, <table>)
SELECT * FROM TABLE(INSPECT_HIVE_PART_INFO('hive_catalog', 'db', 'tbl'));
┌─────────────────────┐
│ (partition details) │
└─────────────────────┘