you can retrieve table with tag name using query "tagname"
and ACTIVE entity using
hive_table where __state="ACTIVE"
There is no support currently to combine these 2 queries.
You can combine queries like :
hive_table where name="t1" and __state="ACTIVE" which retrieves the ACTIVE hive_tables with name t1
but there is no current support for ACTIVE tables tagged with tagname.