You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org> on 2011/06/16 05:13:49 UTC
[jira] [Commented] (HIVE-2226) Add API to retrieve table names by
an arbitrary filter, e.g., by owner, retention, parameters, etc.
[ https://issues.apache.org/jira/browse/HIVE-2226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13050195#comment-13050195 ]
jiraposter@reviews.apache.org commented on HIVE-2226:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/910/
-----------------------------------------------------------
Review request for hive and Paul Yang.
Summary
-------
Create a function listTableNamesByFilter that returns a list of names for tables in a database that match a certain filter. The syntax of the filter is similar to the one created by HIVE-1609. You can filter the table list based on owner, retention, or table parameter key/values. The filtering takes place at the JDO level for efficiency/speed. Added a QueryFilterType enum to easily add new filters and separate logic for filtering.
Example filter statements include:
filterType = QueryFilterType.OWNER; filter = "owner like ".*test_user.*"
filterType = QueryFilterType.RETENTION; filter = "retention < 90 and retention > 30"
filterType = QueryFilterType.PARAMS; filter = "numPartitions = \"2\" and retention_days = \"30\""
The filter can currently parse string or integer values, where values interpreted as strings must be in quotes.
This addresses bug HIVE-2226.
https://issues.apache.org/jira/browse/HIVE-2226
Diffs
-----
trunk/metastore/if/hive_metastore.thrift 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.java 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/IMetaStoreClient.java 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/RawStore.java 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/parser/ExpressionTree.java 1135227
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/parser/Filter.g 1135227
trunk/metastore/src/test/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java 1135227
Diff: https://reviews.apache.org/r/910/diff
Testing
-------
Added test cases to TestHiveMetaStore
Thanks,
Sohan
> Add API to retrieve table names by an arbitrary filter, e.g., by owner, retention, parameters, etc.
> ---------------------------------------------------------------------------------------------------
>
> Key: HIVE-2226
> URL: https://issues.apache.org/jira/browse/HIVE-2226
> Project: Hive
> Issue Type: Improvement
> Components: Metastore
> Reporter: Sohan Jain
> Assignee: Sohan Jain
> Attachments: HIVE-2226.1.patch
>
>
> Create a function called get_table_names_by_filter that returns a list of table names in a database that match a certain filter. The filter should operate similar to the one HIVE-1609. Initially, you should be able to prune the table list based on owner, retention, or table parameter key/values. The filtering should take place at the JDO level for efficiency/speed.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira