[
https://issues.apache.org/jira/browse/TRAFODION-2166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15431523#comment-15431523
]
David Wayne Birdsall commented on TRAFODION-2166:
-------------------------------------------------
For Hive tables, I found the bug. In
MultiColumnUecList::displayMissingStatsWarning (optimizer/ColStatDesc.cpp), the
code is using HIVE.HIVE.SB_HISTOGRAMS for the location of the histograms table
for Hive tables. It needs to use TRAFODION."_HIVESTAT_".SB_HISTOGRAMS instead.
There is a ustat routine, getHistogramsTableLocation() (ustats/hs_util.cpp)
that will do this transformation for any table. So the fix is to change the
former routine to make use of the latter. (The latter routine is used within
UPDATE STATISTICS code to make this transformation.)
> UPDATE STATS ON NECESSARY COLUMNS does not work on Hive tables
> --------------------------------------------------------------
>
> Key: TRAFODION-2166
> URL: https://issues.apache.org/jira/browse/TRAFODION-2166
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
