[ https://issues.apache.org/jira/browse/HIVE-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438357#comment-13438357 ]
Jakob Homan commented on HIVE-2702: ----------------------------------- This is very limiting for HCat as it means HCat clients cannot access non-string partitions from Pig or MR, whereas they are available via Hive directly. The JDOQL that's used in generateJDOFilter() to generate the query is not powerful enough to support stripping out the value, casting it to a number, and then sorting it thusly. The best solution is probably to re-write ObjectStore.listPartitionNamesByFilter() to not use the Partitions table (which stores the values as "PARTITION=FOO" but rather take advantage of PARTITION_KEY_VALS, which stores the partition values by themselves. Any objections to this approach? > listPartitionsByFilter only supports string partitions > ------------------------------------------------------ > > Key: HIVE-2702 > URL: https://issues.apache.org/jira/browse/HIVE-2702 > Project: Hive > Issue Type: Bug > Affects Versions: 0.8.1 > Reporter: Aniket Mokashi > Assignee: Aniket Mokashi > Attachments: HIVE-2702.1.patch, HIVE-2702.D2043.1.patch > > > listPartitionsByFilter supports only non-string partitions. This is because > its explicitly specified in generateJDOFilterOverPartitions in > ExpressionTree.java. > //Can only support partitions whose types are string > if( ! table.getPartitionKeys().get(partitionColumnIndex). > > getType().equals(org.apache.hadoop.hive.serde.Constants.STRING_TYPE_NAME) ) { > throw new MetaException > ("Filtering is supported only on partition keys of type string"); > } -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira