[HIVE-1145] CREATE VIEW followup: extend metastore get_tables API to allow filtering by table type (view, external table, etc.)

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.6.0
• Component/s: Metastore
• Assignee: Paul Yang
• Reporter: John Sichi
• Created: 09/Feb/10 23:05
• Updated: 16/Jun/10 01:59

Description

e.g. to get tables which start with x, excluding views:

get_tables_by_type('default', 'x.*', 'EXTERNAL_TABLE|MANAGED_TABLE');

Besides direct use, this can also be used to simplify the JDBC getTables() API, which allows filtering by type.

Issue Links

• is related to: HIVE-972 Support views