hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Nastetsky <>
Subject metastore join TBLS to COLUMNS_V2
Date Mon, 25 Aug 2014 16:15:12 GMT

I am trying to run some queries against the metastore, but I am not sure
how to query the list of Hive columns in the COLUMNS_V2 table for a
specific Hive table in the TBLS table.

I want to do something like

select t.tbl_name, c.column_name
from TBLS t
join COLUMNS c
on t.tbl_id = ...

I tried the cd_id field on the COLUMNS_V2 table but it didn't match up. I'm
not sure if there's an intermediate table that needs to be involved or
something else I am missing.


View raw message