use metadata;

select tbl.owner, tbl.tbl_name, tbl.tbl_type, sds.location, db.name, db.db_location_uri from DBS db, TBLS tbl, SDS sds

  where db.db_id=tbl.db_id and sds.sd_id=tbl.sd_id --and tbl.tbl_name like '%tb_test%';

    order by db.name, tbl.tbl_name;

* view table의 경우는 location 컬럼의 값이 없으니 참고 할것.

* tb_test table에 대한 예시

owner    tbl_name location                                                                       db_location_uri

gooper   tb_test    hdfs://nameservice1/user/hive/warehouse/gooper.db/tb_test    hdfs://nameservice1/user/hive/warehouse/gooper.db