[
https://issues.apache.org/jira/browse/HIVE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14001236#comment-14001236
]
Lefty Leverenz commented on HIVE-6188:
--------------------------------------
Also documented:
* [hive.metastore.integral.jdo.pushdown |
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.metastore.integral.jdo.pushdown]
But this patch added *hive.metastore.integral.jdo.pushdown* to
hive-default.xml.template a second time. That will get fixed when HIVE-6037 is
committed. HIVE-6037 uses the other description: "Allow JDO query pushdown
for integral partition columns in metastore. Off by default. This improves
metastore perf for integral columns, especially if there's a large number of
partitions. However, it doesn't work correctly with integral values that are
not normalized (e.g. have leading zeroes, like 0012). If metastore direct SQL
is enabled and works, this optimization is also irrelevant."
In the wiki I added the parameter name for metastore direct SQL, which is the
main difference between the two descriptions.
Here's the description in this patch: "Whether to enable JDO pushdown for
integral types. Off by default. Irrelevant if hive.metastore.try.direct.sql is
enabled. Otherwise, filter pushdown in metastore can improve performance, but
for partition columns storing integers in non-canonical form, (e.g. '012'), it
can produce incorrect results."
> Document hive.metastore.try.direct.sql & hive.metastore.try.direct.sql.ddl
> --------------------------------------------------------------------------
>
> Key: HIVE-6188
> URL: https://issues.apache.org/jira/browse/HIVE-6188
> Project: Hive
> Issue Type: Improvement
> Components: Documentation
> Reporter: Lefty Leverenz
> Assignee: Sergey Shelukhin
> Priority: Minor
> Fix For: 0.13.0
>
> Attachments: HIVE-6188.patch
>
>
> The hive.metastore.try.direct.sql and hive.metastore.try.direct.sql.ddl
> configuration properties need to be documented in hive-default.xml.template
> and the wiki.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
