[ https://issues.apache.org/jira/browse/HIVE-6052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14001247#comment-14001247 ]
Lefty Leverenz commented on HIVE-6052: -------------------------------------- *hive.metastore.integral.jdo.pushdown* is now documented in the wiki: * [hive.metastore.integral.jdo.pushdown | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.metastore.integral.jdo.pushdown] > metastore JDO filter pushdown for integers may produce unexpected results > with non-normalized integer columns > ------------------------------------------------------------------------------------------------------------- > > Key: HIVE-6052 > URL: https://issues.apache.org/jira/browse/HIVE-6052 > Project: Hive > Issue Type: Bug > Affects Versions: 0.12.0, 0.13.0 > Reporter: Sergey Shelukhin > Assignee: Sergey Shelukhin > Fix For: 0.13.0 > > Attachments: HIVE-6052.01.patch, HIVE-6052.02.patch, HIVE-6052.patch > > > If integer partition columns have values stores in non-canonical form, for > example with leading zeroes, the integer filter doesn't work. That is because > JDO pushdown uses substrings to compare for equality, and SQL pushdown is > intentionally crippled to do the same to produce same results. > Probably, since both SQL pushdown and integers pushdown are just perf > optimizations, we can remove it for JDO (or make configurable and disable by > default), and uncripple SQL. -- This message was sent by Atlassian JIRA (v6.2#6252)