hive-user mailing list archives

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

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.

Thanks!

Mime
View raw message