select d.name as db_name ,t.tbl_name as tbl_name ,from_unixtime(min(t.create_time)) as create_time ,min(t.owner) as owner ,min(case when tp.param_key = 'COLUMN_STATS_ACCURATE' then tp.param_value end) as COLUMN_STATS_ACCURATE ,min(case when tp.param_key = 'last_modified_by' then tp.param_value end) as last_modified_by ,min(case when tp.param_key = 'last_modified_time' then from_unixtime(tp.param_value) end) as last_modified_time ,min(case when tp.param_key = 'numFiles' then tp.param_value end) as numFiles ,min(case when tp.param_key = 'numRows' th...