[jira] [Created] (TRAFODION-775) LP Bug: 1394421 - Generation of on-demand stats causes subsequent ustats failure

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-775:
------------------------------------

             Summary: LP Bug: 1394421 - Generation of on-demand stats causes subsequent ustats failure
                 Key: TRAFODION-775
                 URL: https://issues.apache.org/jira/browse/TRAFODION-775
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Barry Fritchman
            Assignee: Barry Fritchman
             Fix For: 2.0-incubating


When, in the process of optimizing a query, on-demand stats are generated in the form of small-sample histograms, subsequent invocation of Update Statistics fails with an 8415 error (invalid date, time, or timestamp). This appears to be due to an invalid timestamp value within a row inserted into the SB_HISTOGRAMS table when the on-demand stats are created.

This error only recently surfaced, because the quickie stats are not generated unless an estimate of the table's row count is available via HSTableDef::getRowCount().  This function recently began using NATable::estimateHBaseRowCount(), so when it returns a nonzero estimate, and the HIST_ON_DEMAND_STATS_SIZE cqd is set to a value > 0, the code that produces on-demand stats is executed.

Generation of on-demand stats is currently disabled in the code, pending resolution of this issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)