HiveMetastore 背后的存储
  • select * from DBS;

HiveMetastore插图

  • select * from TBLS;

HiveMetastore插图(1)

select * from TABLE_PARAMS;
HiveMetastore插图(2)

  • 查找出没有 totalSize stats 的table
SELECT DBS.NAME,t.TBL_NAME from DBS inner join (select DB_ID,TBL_NAME from TBLS where TBLS.TBL_ID not in(select TBL_ID from TABLE_PARAMS  where PARAM_KEY = 'totalSize')) t on DBS.DB_ID=t.DB_ID;
本站无任何商业行为
个人在线分享-虚灵IT资料分享 » HiveMetastore
E-->