hive - HiveQL : Query to list only the views -

is there hive query list views available in particular database.

in mysql query think below:

select table_name information_schema.tables table_type 'view' , table_schema 'database_name';

i want similar hiveql.

there no information_schema implementation in hive currently.

there open jira can view @ following link:

however, if hive metastore configured using derby mysql server can access information require.

the different ways of configuring hive metastore can found at:

here detailed e/r diagram of metastore:

after configuring metastore, can obtain information want query like:

select * tbls tbls_type = "view"

And