[
https://issues.apache.org/jira/browse/HIVE-10530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14520411#comment-14520411
]
Mostafa Mokhtar commented on HIVE-10530:
----------------------------------------
[~vgumashta] [~thejas]
Correction, we end up sending queries to MySQL but query that ends up fetching
the column statistics goes against the cache and not MySQL as expected.
{code}
select "COLUMN_NAME", "COLUMN_TYPE", min("LONG_LOW_VALUE"),
max("LONG_HIGH_VALUE"), min("DOUBLE_LOW_VALUE"), max("DOUBLE_HIGH_VALUE"),
min(cast("BIG_DECIMAL_LOW_VALUE" as decimal)),
max(cast("BIG_DECIMAL_HIGH_VALUE" as decimal)), sum("NUM_NULLS"),
max("NUM_DISTINCTS"), max("AVG_COL_LEN"), max("MAX_COL_LEN"), sum("NUM_TRUES"),
sum("NUM_FALSES"),
avg(("LONG_HIGH_VALUE"-"LONG_LOW_VALUE")/cast("NUM_DISTINCTS" as
decimal)),avg(("DOUBLE_HIGH_VALUE"-"DOUBLE_LOW_VALUE")/"NUM_DISTINCTS"),avg((cast("BIG_DECIMAL_HIGH_VALUE"
as decimal)-cast("BIG_DECIMAL_LOW_VALUE" as
decimal))/"NUM_DISTINCTS"),sum("NUM_DISTINCTS") from "PART_COL_STATS"
{code}
> Aggregate stats cache: bug fixes for RDBMS path
> -----------------------------------------------
>
> Key: HIVE-10530
> URL: https://issues.apache.org/jira/browse/HIVE-10530
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 1.2.0
> Reporter: Vaibhav Gumashta
> Assignee: Vaibhav Gumashta
> Fix For: 1.2.0
>
> Attachments: HIVE-10530.1.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
