<$HIVE_HOME/conf/hive-site.xml grep -A1 jdo

<name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://127.0.0.1/metastore?createDatabaseIfNotExist=true</value>
--
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
--
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>hive</value>
--
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>cloudera</value>

select          *

from                            metastore.DBS             as d

                join            metastore.TBLS            as t

                on              t.DB_ID =
                                d.DB_ID

where           t.TBL_NAME  like '% ... put somthing here ... %'

order by       d.NAME
              ,t.TBL_NAME
;